Microsoft Access 2003 Foundations
|
Course Duration: 1 Day
|
|
Lesson
|
Topics
|
|
Access Basics
|
Understanding Databases
Using the Database Wizard
Open an Existing Database
The Access Environment
A Look at Tables
|
A Look at Forms
A Look at Queries
A Look at Reports
Creating a Blank Database
|
|
Working with Tables
|
Using the Table Wizard
Entering Data into a Table
Using Design View
Creating a Table from Scratch
Setting a Primary Key
|
Changing Column Width and Row Height
Rearranging Fields
Inserting and Deleting Fields
Changing Field Properties
|
|
Working with Data
|
Editing Data
Importing Excel Data into an Existing Table
Importing a Text File into a New Table
Selecting and Deleting Records
Sorting Records
Finding and Replacing Data
|
Filtering Data by Selection
Filtering Data by Form
Hiding/Unhiding Columns
Freezing Columns
Rearranging Columns
|
|
Working with Queries
|
Working in Query Design View
Creating a Query in Design View
Adding Fields to a Query
Removing Fields from a Query
Saving a Query
Running a Query
|
Adding Criteria to a Query
Specifying Multiple Criteria
Sorting Data in a Query
Moving Columns in a Query
Using the Query Wizard
|
|
Creating Forms
|
Using the Form Wizard
Entering Data into a Form
A Look at Design View
|
Adding a Field to a Form
Changing Control Properties
Finding Records in a Form
|
|
Creating Reports
|
Creating an Autoreport
Using the Report Wizard
A Look at Design View
|
Modifying Report Setup
Printing Reports
Using the Label Wizard
|