| 1.
Introduction
2. Getting Started
- starting Access, the Access application window, terminology
- examining Access objects, resetting the working folder
- displaying help information, exiting from Access
3. Setting up a new database
- creating a new database, creating a new table
- entering records in datasheet view
- printing the datasheet of a table
- closing a table/closing a database
4. Creating a form/modifying and
manipulating data
- reopening a database/reopening a table
- creating a form
- browsing through records in form view/closing a form
- reopening a form
- switching between form view and datasheet view
- entering records in form view
- editing records in datasheet view and form view
- using the find feature, deleting records
- modifying the datasheet view of a table
- sorting the records in a table
|
5. Displaying
selected records
- creating and applying a filter
- creating and running a query, modifying a query
- including a numeric condition in a query
- including a calculated field in a query
6. Creating a report
- creating a simple tabular report
- creating a grouped report, modifying a report
7. Miscellaneous Access features
- using the spelling checker
- copying, renaming and deleting database objects
- importing spreadsheet data into an Access table
8. Final case study |
