Outline for Access 7.0 Level I

Computer Training

OUTLINE FOR ACCESS 2000 FOR Windows 98 LEVEL I

Introduction
Getting Started
- starting Access, the Access application window, terminology
- examining Access objects, resetting the working folder
- displaying help information, exiting from Access
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
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
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 report, modifying a report
Miscellaneous Access features
- using the spelling checker
- copying, renaming and deleting database objects
- importing spreadsheet data into an Access table
Final case study

Duration: 1 day