 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2002 (XP) Introduction
Course Aims
MS Access 2002 (XP) is the latest database from Microsoft designed specifically for a graphical environment. This courses is designed to teach the reader to create and update a simple database using the application Microsoft Access 2002. You will learn to add and edit records, create a table and apply basic field properties and to produce simple queries, forms and reports. |
Assumed Knowledge
A working knowledge of PCs and Windows 95/98/NT is assumed, gained from the workplace or by prior reading our "MS Windows 95/98/NT User Introduction" course. |
Course Audience
New, recent or intending users of MS Access 2002 (XP) who have little or no existing database knowledge. |
|
Table of Contents
|
Getting Started with Access 2002
|
Recognize the different elements of the Access screen
|
|
Display and select items from menus and toolbars
|
|
Create a new blank database
|
|
Select a database object using the Objects Bar
|
|
Open an existing database
|
|
Create a database using the Database Wizard
|
|
|
|
Getting Assistance with Access 2002
|
Use the Office Assistant to get help
|
|
Use the Contents, Answer Wizard and Index to get help
|
|
Manipulate the Help window
|
|
Use the Ask a Question box
|
|
Display What's this? help
|
|
|
|
Adding and Editing Records
|
Create a table using the Table Wizard
|
|
Enter records using a datasheet
|
|
Undo changes to a field or record
|
|
Navigate through records in a datasheet
|
|
Delete records from a table
|
|
|
|
Designing a Table
|
Determine data inputs and outputs for a database
|
|
Create a table in design view
|
|
Switch between design and datasheet views and different object windows
|
|
Modify field properties (size, format, caption, indexed)
|
|
|
Working with Data
|
Modify the layout and formatting of a datasheet
|
|
Sort records by a single field or by more than one field
|
|
Use Filter by Selection or Filter by Form
|
|
|
|
Using a Form
|
Understand the differences between a form and a datasheet
|
|
Use AutoForm to generate a simple form
|
|
Create a form with the Form Wizard
|
|
Enter records using a form
|
|
Navigate through records in a form
|
|
|
|
Using a Select Query
|
Understand the differences between a query and a sort or filter
|
|
Create a query using the Simple Query Wizard
|
|
Add and remove query fields in design view
|
|
Specify criteria in a query
|
|
|
|
Using a Report
|
Print output from database objects (table, query, form or report)
|
|
Use AutoReport to generate a basic report
|
|
Preview and print a report
|
|
Create a report with the Report Wizard
|
|
Move and resize a control
|
|
|
|
|
Glossary
|
|
|
|
|
