Please Note: This site’s design is only visible in a graphical browser that supports web standards, but its content is accessible to any browser or Internet device.

Microsoft Access 2007 - A Running Start

This two-day course is for beginners who want to create mission-critical Access databases. Make sure your database will be soundly built. Learn to design user forms, queries and reports. See how to mail merge information to MS Word.

Course Outline

  • Introduction to databases
  • Designing databases
  • How to use the ribbon
  • Creating Access database and tables
  • Creating and modifying tables and setting a primary key
  • Field properties
  • Importing and attaching tables
  • Adding and editing data
  • Datasheet layouts
  • Creating and editing relationships
  • Designing and modifying forms
  • Adding controls
  • Using properties
  • Sorting and filtering data
  • Queries and dynasets
  • Printing Reports
  • Mail Merge to Word

Who would benefit from the course?

This course is designed for new users of Access especially those wanting to leave the wizards behind and create business-critical databases.

Pre-requisites

Delegates should be familiar with the rudimentary PC keyboard and mouse.