Microsoft Access 2003 Intermediate

This intensive one-day training course will benefit all those wishing to build on their existing Access 2003 knowledge and create data views, queries and reports.

Duration	Price
1 day	£ 250

Course Overview

Database Design

What is a regional database?
Primary and Foreign Keys
Relationships

Using Field Properties for Protection

Required
Default Value
Input Mask
Validation rule and Validation text
Lookups

Table Relationships

What is a relationship?
Relationship types
Creating and Editing Relationships
Using Lookups for Referential Integrity
Multi-table datasheet view

Queries

Multi-table Queries
Calculated fields
Adding a calculated field to a query
The Expression Builder
Calculating summary information
Crosstab queries
General query properties
Checking referential integrity

Forms

Form sections
Form controls
Form control layout
Using form controls
Control properties
Control wizards
Multiple table forms

Reports

Using Report Wizard as the basis of reports
Report sections
Report controls
Report control layout
Using specific controls
Publishing datasheet views on the Internet
Adding Hyperlinks to datasheet view
Adding Hyperlinks to HTML pages

Access Tools

Importing from other data sources
Importing data using Drag-and Drop
Backing up and restoring a database
Compacting and Repairing a database

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.