Access 2007
Part 3
Course Code: AD572

Maximise the potential of Microsoft Access. Learn how to customise menus and multiple-table forms using macros and object linking and embedding.

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

  • Create and validate fields
  • Create a Master-Detail form
  • Create queries and adjust as required
  • Create a master detail report
  • Utilise special queries including Action and Parameter
  • Export Access data to an XML document
  • Create a database password
  • Create and run a command button macro
  • Learn how to use tools and additional advanced access features

What you will learn
Topics covered by this course include:

Advanced Table Design Techniques

  • Validating field entries
  • Creating a Custom Input Mask

Advanced Form Techniques

  • Creating a Master-Detail Form
  • Adding a Picture and Date to a Form
  • Modifying Form properties
Advanced Filter and Query Techniques
  • Including multiple conditions in a query
  • Creating Parameter and Action queries
  • Create an advanced Filter

Advanced Report Techniques

  • Creating a Master Detail report
  • Completing the report
  • Add a Cover sheet to a report
  • Modifying Report Properties

Working with Macros and Modules

  • Creating and running a Macro
  • Creating a Command Button Macro
  • Writing an Event Procedure

Using Tools menu options

  • Setting up Start up options
  • Setting a Database password
  • Using Database Splitter
  • Use Linked manager
  • Creating a Replica

Additional Advanced Access Features

  • Creating a Many-to-Many relationship
  • Creating a Switchboard
  • Exporting Access Data to an XML document
  • Saving an Access Database into a ACCDE file
  • Macro Security

Prerequisites
Course participants should have completed Microsoft Access 2007 Part 2 (or equivalent).

Dates and times
Courses are available either in the morning or the evening. Contact the relevant training centre for further details and enrolment information.

© Copyright The Fourth R®

 [Back to MS Office Training Courses]