Microsoft Access Level 1
Getting Started
- what is Access? starting Access, the Access application window
- working with Access menus, basic Access terminology
- examining Access objects
- resetting the database folder, displaying help information
- exiting from Access
Setting up a new database
- designing and 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
Creating a form/modifying and manipulating data
- reopening a database/reopening a table
- creating a form
- navigating 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 in datasheet view and form view
- modifying the datasheet view of a table
- sorting the records in a table
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
Creating a report
- creating a simple tabular report
- creating a grouped tabular report, modifying a report
Additional Access features
- using the spelling checker
- copying, renaming and deleting database objects
- importing spreadsheet data into an Access table
