Course Outline
Course:
|
Access 2000 Introduction |
Duration:
|
2 days |
Objectives:
|
This course is an introduction to the Microsoft
relational database, Access 2000. It
includes an introduction to database design and terminology, alongside
instruction on the database objects e.g. tables, forms, queries and
reports. The course lasts two
days and comprises a mixture of demonstrations, tutor-led examples and
student exercises. |
Pre-Requisites:
|
Students should be familiar with the use of an IBM
compatible PC and with the Windows operating system. No prior knowledge of database terminology or Microsoft
Access is assumed. No
programming experience is necessary.
|
Topics:
|
 |
Introducing Access 2000
 |
Database Overview |
|
Access Overview |
|
Starting Access |
|
The Screen, Toolbars, |
|
The Right Mouse Button Bar |
|
About Microsoft Access |
|
Opening a Database |
|
Wizards & Cue Cards |
|
|
Table Design
|
Normalisation |
|
Field Names, Data Type, Descriptions, |
|
Field Properties, Field Size, Format |
|
Custom Formats, Decimal Places |
|
Input Masks |
|
Caption, Values, Validation |
|
Saving a design |
|
|
Working with Tables
|
The Datasheet View |
|
Editing, Adding, Deleting, Finding Records |
|
Changing the look of the Datasheet |
|
Printing the datasheet
|
|
Sorting Records in the Database |
|
Filters |
|
Creating, Saving, Loading a Query |
|
Criteria & Filter Examples |
|
|
Data Entry
|
Importing and Attaching Data |
|
Import from Spreadsheet or Database |
|
|
Queries
|
Creating a select Query |
|
Adding, Linking
a Query in a table |
|
Join properties |
|
Parameter Queries |
|
Calculation in Queries |
|
Summary Queries |
|
Action Queries
|
|
|
Forms & Reports
|
Using AutoForm & Form Wizard |
|
Views, Modifying the Form Design |
|
Form Properties |
|
Using Report & Report Wizard |
|
Including Calculated and Statistical Fields |
|
Summary Expression |
|
Generating Labels |
|
Conditional Formatting |
|
|
Security & Maintenance
|
Passwords |
|
Compacting and Repair |
|
Download Printer-Friendly copy (Word Format) |
|
