Learning MS Access
Sponsored by The
KenMat Foundation
Subjects and Topics to be covered in each class are listed below:
Introduction to Access-60 Minutes
What is an Access Database?
Starting Access
Exploring the Task Pane
Opening the Database File
Introducing the Database Window
Getting to Know the Access Screen
Saving and Closing a Database File
Getting Help
Exiting Access
Working with Databases – 60 Minutes
Using the Database Wizard
Working with Datasheets
Moving Between Records
Using Goto
Updating Records
Selecting Rows and Columns
Finding Records
Changing Column Width
Saving and Closing a Datasheet
Performing Database Maintenance
Working with Tables- 90 Minutes
Creating a New Database
Adding Tables to a Database
Adding Fields to Tables
Setting a Primary Key
Saving a Table
Adding Records to a Table
Sorting and Filtering Records
Importing Data
Using the Office Clipboard
Exporting Data as a Webpage
Using the Table Wizards
Creating and Running Queries - 90
Minutes
What is a Query?
Creating a Query
Working with Queries
Saving and Running a Query
Creating Calculated Fields
Understanding Query Properties
Creating Multi-Table Select Queries
Joining Tables
Enforcing Referential Integrity
Printing Table Relationships
Using Subdatasheets
Using Forms – 80 Minutes
What is a Form?
Using an AutoForm
Creating a Form with the Form Wizard
Working in Design View
Applying an AutoFormat
Changing the Form Layout
Using Calculated Controls
Working with Records on a Form
Creating a Data Access Page
Generating Reports -90 Minutes
What is a Report?
Creating an AutoReport
Preview and Printing a Report
Saving a Report
Designing a Report
Changing the Report Layout
Understanding Controls
Using a Calculated Control
Creating Mailing Labels