|
|
Access 97 / 2000 / 2002 level 1
prerequisites
- Windows 9x / 2000 / NT / Me / XP Level 1
- quite comfortable with the mouse and keyboard
nice-to-know experience
- other database products
- relational database management theory
- other Microsoft products
durations
This course is taught over a full-day.
objectives
To learn how to effectively and properly use Microsoft's rather powerful and popular
database application. Data entry is discussed and practiced in some detail. This assists
participants who regularly perform database maintenance. New databases, tables, and
queries are made by hand. This in turn helps people required to begin new systems for new
projects. As much as possible wizards are used in the creation of new form and report
objects.
specific topics
- Introduction and Terminology
- Using Databases, Discussing Examples
- Starting Access
- Opening a Database File
- Choosing the Preferred Object
- Closing an Object
- Working with Tables
- Moving through a Table
- Searching for a Record
- Saving in Access
- Editing a Field
- Adding a Record
- Undoing Changes
- Deleting Records
- Quickly Sorting a Table
- Working with a Form
- Printing a Report
- Creating Objects
- Creating a Query Manually
- Creating a Database
- Creating Tables
- Creating a Table with a Wizard
- Creating a Table Manually
- Importing Data from Other Products
- Optimizing Data Collection
- Creating Forms with a Wizard
- Creating Reports with a Wizard
- Saving Data in Access (Review)
- Saving Objects in Access (Review)
- Exiting Access
- Getting Additional Information
- Planning Where To Go From Here
|
