Microsoft Access 2007 Intermediate

This one-day training course builds on the skills and concepts taught in our Microsoft Access 2007 Introduction course.

Duration	Price
1 day	£ 250

Course Overview

Relational databases

• Database normalization

• Relating tables

• Implementing referential integrity

Related tables

• Lookup fields

• Modifying lookup fields

• Subdatasheets

Complex queries

• Joining tables in queries

• Calculated fields

• Summarizing and grouping values

Advanced form design

• Adding unbound controls

• Adding Graphics

• Adding calculated values

• Adding combo boxes

• Advanced form types

Reports and printing

• Customized headers and footers

• Adding calculated values

• Printing

• Labels

Charts

• Charts in forms

• Charts in reports

PivotTables and PivotCharts

• PivotTables

• Modifying PivotTables

• PivotCharts

• PivotTable forms

If booking the Microsoft Access 2007 Intermediate course for more than one delegate, please contact the Mass Training Centre at Wokingham on 01189 778560 for discounted prices.