Objectives
After completing the course, participants will be able to:

• Define a default field value

• Specify and define field information

• Resize & reposition the Table window

• Work with multiple tables

• Design and use a custom form

• Extract information from multiple tables

• Create different types of Queries

• Define Input Masks

• Export an Access object to an HTML file

• Create a Data Access Page

What you will learn
Topics covered by this course include:

Modifying the Design of a Table

• Specifying a Required Field/Defining a Default Field Value

• Setting a Primary Key

• Adding a Memo Field to a Table

Working with Multiple Tables

• Displaying Multiple Tables

• Resizing & Repositioning the Table Window

Relating Tables

• Creating a Relationship between Two Tables

• Displaying and Using a Subdatasheet

Working with a Custom Form

• Designing a Custom Form

• Using a Custom Form to Enter Data

• Adding a Header/Footer to a Form

• Using a Custom Form to Enter Data

Intermediate Query Techniques

• Extracting Information from Multiple Tables

• Creating a query to generate summary information

• Creating a Crosstab, Unmatched and Duplicate query

Intermediate Report Techniques

• Creating a Report

• Adding a Calculated Control to a Report

Working with Data Access Page

• Creating a Data Access Page

• Adding a Pivot table and Pivot Chart to a Data Access Page

Additional Intermediate Access Features

• Adding a Lookup Field to a Table

• Defining an Input Mask for a Field

• Exporting an Access Datasheet to Excel

• Viewing object dependencies

• Using the Database wizard

Prerequisites
Course participants should have completed Access 2003 Part 1 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®