| Introduction |
| Getting started |
 | · | what is Access? starting Access, the Access application window |
 | · | using the access menu system, using the Microsoft Office button |
 | · | using the quick access toolbar, basic Access terminology |
 | · | examining Access objects |
 | · | resetting the database folder, displaying help information |
 | · | exiting from Access |
| Setting up a new database |
 | · | designing a new database, creating a new database |
 | · | creating a new table, entering records in datasheet view |
 | · | printing the datasheet of a table |
 | · | navigating through records in datasheet view |
 | · | closing a table/closing a database file |
| Creating a form/modifying and manipulating data |
 | · | reopening a database file/reopening a table |
 | · | creating a form |
 | · | navigating through records in form window/closing a form |
 | · | reopening a form |
 | · | switching between form view and datasheet view |
 | · | entering records |
 | · | editing records in datasheet view and form view/using the |
| find feature |
 | · | deleting records in datasheet view and in form view |
 | · | modifying the datasheet view of a table |
 | · | sorting the records in a table |
| Displaying selected data |
 | · | filtering the records in a table |
 | · | creating a simple query |
 | · | creating a query in design view |
 | · | modifying a query |
 | · | including a numeric condition in a query |
 | · | including a calculated field in a query |
| Creating a report |
 | · | creating a simple tabular report |
 | · | creating a grouped tabular report, modifying a report |
| Additional Access features |
 | · | copying, renaming and deleting database objects |
 | · | compacting and repairing a database, backing up a database |
 | · | importing spreadsheet data into an Access table |
 | · | importing text into an Access table |
| Final case study |