1. Database design
Theory of normal forms
De-normalisation
Naming conventions2. Access performance issues
Indexes
Data validation
Table level validation
Relationships and referential integrity
Relationships
Field types
Referential integrity options
Join types
Using Lookups for referential integrity
Multi-table datasheet view
3. Building and modifying forms
Using advanced forms features
The form worksurface
Creating a calculated control
Adding a graphic to a form
Multi-table forms
Using the Subform control
Switchboard forms |
|
4. Advanced queries
Filtering query results
Parameter queries
Creating summary queries
Formatting query output
Query join types
Self joins and aliases
Cross joins5. Access and the Internet
Using hyperlinks
Using hyperlinks in forms
Exporting datasheet views to HTML
Data access pages
6. Action queries
What is an action query?
Planning an action query
Make table queries
Append queries
Delete queries
Update queries |
|
7. Producing reports
Applying sorting and grouping to reports
Performing calculations on reports
Adding a graphic to a report
Using the sub-report control
Modifying section properties
Using the Chart Wizard8. Database Management Tools
Setting a database password
Sharing a database
Start-up options
Splitting a database
9. Access Macros
What is a Macro?
Creating a Macro
Running a Macro
Using Macros with events
Macro examples |
