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.
|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)|
|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|
Frequency: Every term. Express an interest in future dates for this course.