Access Introduction

Course Outline

Duration
3 half days

Prerequisite
Experience with Microsoft Windows and use of a mouse.

Objectives
To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Access.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Confirmation of Assessment Plan
This will be issued to the trainee at commencement of training session.

Expected Outcome
By the end of the course the participant should be able to use the following functions and features of Microsoft Access.

CONTENT

Access Basics

Database overview
Elements of a database system
How other DBMS products work
How Access works
Starting Access
Working from startup
Working with Menus
Using the toolbar
Closing a Database
Opening a database window
Quick Review

Access Help
Online Help
Using the Office Assistnat
Customising the Office Assistant
Removing the Office Assistant
Using Help Contents
Using the Help index
Using the What's This?
Checking your system details
Quick Review

Creating a Database
Creating a database
Scoping the system
Creating a new database file
Creating a new table
Creating fields
Creating a Primary key
Creating field properties
Saving the table
Quick Review

Adding Records
Overview of data entry
Entering records directly into the table
Using the data entry facility
Adding records through a form
Quick Review

Changing Data
Overview changing the data
Changing table structures
Updating records
Finding a record to change
Changing several records at once
Deleting records
Quick Review

Working with a Table
Data overview
Moving about a table
Finding records
Searching and replacing
Filtering data
Filtering by form
Printing from a Table
Quick Review

Formatting a Table
Formatting overview
Widening columns
Selecting data
Changing the grid lines
Hiding columns
Freezing columns
Changing row heights
Changing fonts
Moving columns
Quick Review

Select Queries
Quering overview
Creating a query design window
Selecting fields for output
Dragging several fields
Double clicking fields
Selecting records
Selecting data within ranges
Sepcifying OR conditions
Using An-In-Line OR
Saving a query

Report Wizards
Reports overview
Creating a columnar report
Creating a tabular report
Using the report wizard
Using a query for a report
Changing a reports design
Running a report
Quick Review

Forms From Wizards
Forms overview
Creating a columnar auto-form
Creating a datasheet auto-form
Creating a tabular auto-form
Using the form wizard
Working with a form
Creating a form from a query
Quick Review

Conclusion

				Suite 2/2 Shepherd Street GPO Box 1815 Darwin NT 0801 Phone: 08-89412344 Fax: 08-89410141 Email: dcainfo@iinet.com.au