|
INTRODUCTION TO MICROSOFT ACCESS 2003
AIMS AND OBJECTIVES
This one-day session will give participants an understanding
of the basic functions of Microsoft Access. During the session
participants will receive training on many different uses of the
programme, including an introduction to creating tables, filters,
reports and forms.
WHO SHOULD ATTEND?
The training session is designed for those who are new to Microsoft
Access. A basic knowledge of working within the Windows environment
and using the mouse is desirable. Each participant will be given
a comprehensive reference manual to take away with them which
includes hints and tips on using Access and training exercises.
COURSE CONTENT
What is Access?
- Starting Access
- Basic Concepts of Access
- The Data Protection Act |
Queries
- Selection queries
- Setting criteria
- Sorting by a field
- Saving the query
- Executing the query |
Table Creation
- Creating Fields
- Selecting Data Types
- Setting Field Properties |
Creating Forms
- Introduction to Forms
- Creating Forms
- Modifying Forms
- Entering Data using Forms
|
Entering Data
- Opening Tables
- Entering Data
- Moving between Fields
- Correcting Errors
- Sorting Data |
Creating Reports
- Introduction to Reports
- Creating Reports
- Modifying Reports
- Printing Reports |
Filtering Data
- Creating Filters
- Saving Filters |
Printing and Page Setup
- Orientation
- Margins
- Printing Options |
|
