Microsoft Access 2003
Part
2
Course Code: AD537

A practical course designed to enhance productivity using Access. This course extends beyond the basics to include fields, forms, charts and query functions and report techniques.

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®

 [Back to MS Office Training Courses]