An organisation development specialistLinked In

Access Advanced 2010 / 2007

Duration 1 day

Designed for

This course is for experienced users who wish to extend their knowledge further and for those who are responsible for maintaining databases for other users


Delegates should have attended the introductory course or have been using the software for at least three months and have a thorough understanding of tables, queries and reports before attending this course.

Course Aims

By the end of this course delegates will be able to design a relational database, write complex queries and create advanced forms and reports. In addition they will be able to develop more sophisticated database models for use in a multi-user environment

Course Content

  • A Review of the Basics
  • Indexes
  • Hyperlinks and Attaching Files to Records
  • Adding Calendar Controls and other Active X Controls
  • Editing the Tab order
  • Creating Option Buttons, Combo and List Boxes
  • Creating Interactive Forms for Criteria Input and Menus
  • Queries to Link Data from Different Tables
  • Conditional Formatting with Reports
  • Integrating with other Microsoft Applications
  • Exporting to PDF
  • SharePoint Overview
  • Macros – Creating, Events, Grouping, Conditional
  • Startup Databases
  • Switchboard Manager Vs Automated Forms
  • Database Documenter
  • Analyze Table and Performance
  • Additional Items – Time Allowing
  • The Need for Security (SharePoint Services)
  • Activating Log On Procedure to Secure the Database


Content may vary slightly depending on version being used