Course Outline

Microsoft Access 2007 Level 1
This class is designed for the beginning Access user. Participants will learn to design and create tables and to enter and manipulate data. The class covers how to filter and sort records and to use queries to select and analyze data.6 hours
Course prerequisites: Introduction to Microsoft Windows or equivalent experience. Excel experience helpful.

Why use a database?
What does a database consist of?
Starting Access
Understanding content security
Setting Access Options
Using the Quick Access Toolbar
Opening and closing a database
Opening and closing a table
Viewing a table
Editing and deleting data in a record
Adding data in a table
Deleting a record from a table
Finding data Basic Query 

Basic Query
What is a query?
Opening and closing a query
Designing a query
Switching between design and datasheet
Creating a query
Adding and removing a table from a query
Adding or deleting a field in a query
Saving a query Sorting in a Query 

Sorting in a Query
Sorting data with visible fields
Moving the fields in a query
Adding all fields in a query
Deleting all fields in a query
Sorting data with hidden columns
Quick sort Query with Single Criteria

Query with Single Criteria
Selecting the records in a query
What is a value?
Clearing a single criteria
Using logical criteria
Using wildcards in criteria
Searching for no value
Using criteria with hidden columns
Quick filter

Query with Multiple Criteria
Searching for a range of values
Searching for multiple values in a single field
Using "And" and "Or" criteria in multiple fields
Deleting and inserting criteria Building the Database/Table


Creating a database

Creating a table
Naming a field in a table
Selecting field data types and arguments
Saving a table
Switching between design and datasheet
Primary key field
Renaming a field
Deleting a field
Moving a field
Inserting a field Formatting and Printing a Datasheet

Formatting and Printing a Datasheet
Changing the field width/record height
Freezing fields on the screen and printout
Formatting cells
Printing a table or query
Changing the page setup
Exporting a table or query
Changing the font
Moving/hiding/un-hiding a field

Prerequisites:  Introduction to Microsoft Windows or equivalent experience.
Revised 1/21/2008
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600