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 tables

• Create different types of reports

• Display Subdatasheets

• 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

• Displaying a Table in Design View

• 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

• Adding a Calculated Control to a Form

Intermediate Query Techniques

• Extracting Information from Multiple Tables

• Finding Unmatched Records in a Table

Intermediate Report Techniques

• Creating a Report

• Adding a Calculated Control to a Report

• Adding a Cover Sheet to a Report

Working with Data Access Page

• Creating a Data Access Page

• Adding a Group Level to a Data Access Page

• Adding a Hyperlink to a Data Access Page

Additional Intermediate Access Features

• Using a Database Wizard

• Adding a Lookup Field to a Table

• Defining an Input Mask for a Field

• Exporting an Access Datasheet to Excel

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

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

© Copyright The Fourth R^®