Course Details and Schedule

Starting with a set of related tables (previously built), you use wizards to create the tools that make the database usable and interesting: queries to interrogate the data and set criteria, forms where human users can work safely on the data and reports to help you draw conclusions from it.

See below for course schedule

Key topics
  • Designing queries to select data from tables
  • Setting criteria and using expressions
  • Creating a simple form
  • Working with controls in a form or report
  • Rearranging and altering controls
  • Creating a simple report
  • Grouping records in a report
  • Summary calculations in a report
Course information
Intended audience Those who have designed and built a database structure, and now need forms, queries and reports to make the database usable
Prior knowledge We assume that you have already designed and built your Access database with tables and relationships (as covered in Access: Building a database)
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software Microsoft Access 2010
Format Presentation with practical exercises
Further information Using Access 2003 or 2007? See our Microsoft Office page
Where next? Access: Designing forms and reports and Access: Analysing data
Taught using:
Windows XP

Course provider: IT Learning Programme

Schedule

Frequency: Every term. Express an interest in future dates for this course.