Skip to content

Access Database Design and Programming

Spend $50 to get a free DVD!

ISBN-10: 0596002734

ISBN-13: 9780596002732

Edition: 3rd 2002

Authors: Steven Roman, Ron Petrusha

List price: $39.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

"Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas: Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data. Queries. The book examines multi-table…    
Customers also bought

Book details

List price: $39.99
Edition: 3rd
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 1/17/2002
Binding: Paperback
Pages: 448
Size: 7.25" wide x 9.00" long x 1.00" tall
Weight: 1.540
Language: English

Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".

Preface
Database Design
Introduction
Database Design
Database Programming
The Entity-Relationship Model of a Database
What Is a Database?
Entities and Their Attributes
Keys and Superkeys
Relationships Between Entities
Implementing Entity-Relationship Models: Relational Databases
Implementing Entities
A Short Glossary
Implementing the Relationships in a Relational Database
The LIBRARY Relational Database
Index Files
NULL Values
Database Design Principles
Redundancy
Normal Forms
First Normal Form
Functional Dependencies
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
Normalization
Database Queries
Query Languages and the Relational Algebra
Query Languages
Relational Algebra and Relational Calculus
Details of the Relational Algebra
Access Structured Query Language (SQL)
Introduction to Access SQL
Access Query Design
Access Query Types
Why Use SQL?
Access SQL
The DDL Component of Access SQL
The DML Component of Access SQL
Database Architecture
Database System Architecture
Why Program?
Database Systems
Database Management Systems
The Jet DBMS
Data Definition Languages
Data Manipulation Languages
Host Languages
The Client/Server Architecture
Visual Basic for Applications
The Visual Basic Editor
The Project Window
The Properties Window
The Code Window
The Immediate Window
Arranging Windows
The Visual Basic Editor, Part II
Navigating the IDE
Getting Help
Creating a Procedure
Run Mode, Break Mode, and Design Mode
Errors
Debugging
Variables, Data Types, and Constants
Comments
Line Continuation
Constants
Variables and Data Types
VBA Operators
Functions and Subroutines
Calling Functions
Calling Subroutines
Parameters and Arguments
Exiting a Procedure
Public and Private Procedures
Fully Qualified Procedure Names
Built-in Functions and Statements
The MsgBox Function
The InputBox Function
VBA String Functions
Miscellaneous Functions and Statements
Handling Errors in Code
Control Statements
The If...Then Statement
The For Loop
The Exit For Statement
The For Each Loop
The Do Loop
The Select Case Statement
A Final Note on VBA
Data Access Objects
Programming DAO: Overview
Objects
The DAO Object Model
The Microsoft Access Object Model
Referencing Objects
Collections Are Objects Too
The Properties Collection
Closing DAO Objects
A Look at the DAO Objects
The CurrentDb Function
Programming DAO: Data Definition Language
Creating a Database
Opening a Database
Creating a Table and Its Fields
Creating an Index
Creating a Relation
Creating a QueryDef
Programming DAO: Data Manipulation Language
Recordset Objects
Opening a Recordset
Moving Through a Recordset
Finding Records in a Recordset
Editing Data Using a Recordset
ActiveX Data Objects
ADO and OLE DB
What Is ADO?
Installing ADO
ADO and OLE DB
The ADO Object Model
Finding OLE DB Providers
A Closer Look at Connection Strings
An Example: Using ADO over the Web
ADOX: Jet Data Definition in ADO
The ADOX Object Model
Programming Problems
Some Common Data Manipulation Problems
Running Sums
Overlapping Intervals I
Overlapping Intervals II
Making Assignments with Default
Time to Completion I
Time to Completion II
Time to Completion III--A MaxMin Problem
Vertical to Horizontal
A Matching Problem
Equality of Sets
Appendixes
DAO 3.0/3.5 Collections, Properties, and Methods
The Quotient: An Additional Operation of the Relational Algebra
Open Database Connectivity (ODBC)
Obtaining or Creating the Sample Database
Suggestions for Further Reading
Index