| Fundamentals |
| |
Basic database concepts
Designing a basic database
Overview of MS Access
Opening an existing database
The Access environment
Access Objects
Editing an Access table
Navigating through a table
Deleting records
Adding new records
Finding and sorting |
|
| Creating tables |
| |
Creating
an Access database
Creating tables in design view
Using the Table Wizard
Setting field attributes
Setting a primary key
Datasheet view |
|
| Filtering and
sorting |
| |
Finding
records
Filtering records
Filtering with forms
Sorting records |
|
| Working with forms |
| |
Overview of forms
Using the Form Wizard
AutoForms
Bound and unbound forms
Data validation
Adding records via a form |
|
| Relationships |
| |
Relationships overview
Creating relationships
About referential integrity |
|
| Queries |
| |
Design view queries
Setting criteria
Using the query wizard
Sorting queries
Modifying and updating queries
Querying multiple tables |
|
| Creating reports |
| |
AutoReports
The Reports Wizard
Formatting a report
Linking reports to queries
Generating groupings
Creating custom headers
Adding your logo
Printing reports |
|
