After completing Access 97: Using a Database, the user should be able to:
| Change a table's design |
| Edit and add records in a table or form |
| Create and modify basic queries |
| Create and modify simple forms |
| Create a basic report |
|
Modifying a Table's Design
Changing field names
Inserting and deleting fields
Moving fields
Changing column widths
Finding Records
Searching through a specific field
Searching through all fields in a table
Editing Records
Selecting values and records
Deleting records
Using Undo commands
Copying values and records
Query Basics
Running a query
Viewing a query's design
Creating and designing a query
Controlling the number of visible fields
Sorting and Saving a Query
Controlling the order of records
Rearranging the design grid fields
Saving and naming a query
Setting Criteria in a Query
Setting selection criteria
Controlling which records appear
Editing records from the query datasheet
Form Basics
Viewing data in a form
Creating a form with Form Wizard
Specifying fields and form layout
Basic form design
Modifying Simple Forms
Modifying a form's design
Previewing a form
Printing a form
Sorting and Editing Records in a Form
Sorting records
Filtering records
Editing records
Adding new records
Creating Basic Reports
Previewing and printing a report
Reviewing basic report design
Creating a report with Report Wizard
|
This course is distributed with
Exercises, with sample files, that allow users to practice in Access 97 |
A file containing the text of the exercises |
Simulations that allow users to practice course skills, even if they don't have access to the Access 97 product |
An Access 97 glossary |
|