Course Details and Schedule

This course covers a variety of techniques for manipulating and analysing the data in a relational database. Starting with a set of related tables you have already built (see the previous course, Access: Building a database), you will learn how to manage and look after data and how to set up different kinds of calculations in various parts of the database.

See below for course schedule

Key topics
  • Data management - import and export
  • Action queries for housekeeping a database
  • More flexible queries using parameters
  • Calculations in queries
  • Calculated controls in a form or a report
  • Summary calculations in a report
  • Building simple macros to automate actions
Course information
Intended audience Those who have created a database structure, and now need more techniques to analyse the findings
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 and Access: Creating queries, forms and reports)
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
Taught using:
Windows XP

Course provider: IT Learning Programme

Schedule

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