Acknowledgments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxix
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xli
Part I: Access Building Blocks
1
Chapter 1: An Introduction to Database Development . . . . . . . . . . . . . 3
The Database Terminology of Access ....................................................................................4
Databases ....................................................................................................................4
Tables ..........................................................................................................................5
Records and fields ......................................................................................................6
Values ..........................................................................................................................6
Relational Databases ..............................................................................................................7
Working with multiple tables ......................................................................................7
Knowing why you should create multiple tables ..........................................................7
Access Database Objects and Views ......................................................................................8
Datasheets ..................................................................................................................8
Queries........................................................................................................................9
Data-entry and display forms ......................................................................................9
Reports ......................................................................................................................10
Designing the system’s objects ..................................................................................10
A Five-Step Design Method ................................................................................................10
Step 1: The overall design — from concept to reality ................................................11
Step 2: Report design ................................................................................................13
Step 3: Data design: What fields are required. ..........................................................14
Step 4: Table design ..................................................................................................17
Step 5: Form design: Input ........................................................................................21
Summary ............................................................................................................................22
Chapter 2: Creating Access Tables . . . . . . . . . . . . . . . . . . . . . . . 23
Getting Started with Access 2007 ........................................................................................23
The Templates section ..............................................................................................24
The File menu ..........................................................................................................25
Creating a Database ............................................................................................................26
xiii
02_046732 ftoc.qxp 11/21/06 8:43 AM Page xiii
|
|