1. Database Design
What is a relational database?
Primary and foreign keys
Relationships2. Using Field Properties for Protection
Required
Default value
Input mask
Validation rule and validation text
Lookups
3. Table Relationships
What is a relationship?
Relationship types
Creating and editing relationships
Using lookups for referential integrity
Multi-table datasheet view |
|
4. Queries
Multi-table queries
Calculated fields
Adding a calculated field to a query
The Expression Builder
Calculating summary information
Crosstab queries
General query properties
Checking referential integrity
5. Forms
Form sections
Form controls
Form control layout
Using form controls
Control properties
Control Wizards
Multiple table forms |
|
6. Reports
Using Report Wizards as the basis for reports
Report sections
Report controls
Report control layout
Using specific controls
Publishing datasheet views on the Internet
Adding hyperlinks to datasheet views
Adding hyperlinks to HTML pages7. Access tools
Importing from other data sources
Importing data using Drag-and-Drop
Backing up and restoring a database
Compacting and repairing a database |
