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
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
9th week Thursday 26 June 09:15-12:15 1 9.00 IT Services, 13 Banbury Road Booking opens May 27th 2014 Email me when booking opens

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term.