INTRODUCTION
Course
length: 3
half-day sessions
Who
should attend: Anyone
new to Access
Suggested
Background: Basic
Windows skills
If you need to keep
track of and organize information, this is the course for you. First you will learn to enter and modify
data, and then create a simple database.
You will create and use queries to extract information from your
database based on your conditions. You
will design reports to present your data as a printed document.
Upon completion of this course, you will be able
to:
Work with Tables
Understand
database relationships
Identify screen elements and move
around efficiently
Add, delete, change, and view records
Find records and replace data
Plan, create, and modify tables and a
database
Work with Queries
Understand queries and criteria
Create and modify select queries
Control the appearance of the query
results
Define and use simple, complex, and
compound criteria
Create a multi-table query
Understand report sections
Create and format controls
Add and remove fields, controls and
sections
Understand bound & unbound objects
Create calculated fields
Base a report on the results of a query