Microsoft Access 2007
Part
2
Course Code: AD571

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

  • Add a Calculated Control to a Report

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

  • Create a query to find unmatched records

  • Create a query to find duplicate records

Intermediate Report Techniques

  • Creating a Report

  • Adding a Calculated Control to a Report

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 Templates

 

Prerequisites
Course participants should have completed Access 2007 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]