Microsoft Access 2010 - Module 2

B&W printed

This publication is primarily designed for people who need to know how create fully relational databases, automate operations and perform complex queries in Microsoft Access 2010. It is ideal for people who have a need to record, query and report large quantities of data.

Topics covered include:

  • designing relational databases
  • setting table relationships
  • creating and using relational queries including calculated, aggregated and action queries
  • modify and create forms using a range of techniques
  • create and use macros

This publication assumes that you can create a database file, store and manage data, it would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip