Microsoft Access 2003 Advanced

This intensive One-day Training Course will benefit those wishing to gain further understanding of database design principles, advanced forms, reports & query design using Access 2003.

Duration	Price
1 day	£ 250

Course Overview

Database Design

· Theory of normal forms

· De-normalisation

· Naming conventions

Access Performance Issues

· Indexes

· Data validation

· Table level validation

· Relationships & referential integrity

· Relationships

· Field types

· Referential integrity options

· Join types

· Using Lookups for referential integrity

· Multi-table datasheet view

Building & Modifying Forms

· Using advanced form features

· The form worksurface

· Creating a calculated control

· Adding a graphic to a form

· Multi-table forms

· Using the sub-form control

· Switchboard forms

Access & the Internet

· Using hyperlinks

· Using hyperlinks in forms

· Exporting datasheet views to HTML

· Data Access pages

Advanced Queries

· Filtering query results

· Parameter queries

· Creating summary queries

· Formatting query output

· Query join types

· Self joins and aliases

· Cross joins

Action Queries

· What is an action query?

· Planning an action query

· Make table queries

· Append queries

· Delete queries

· Update queries

Producing Reports

· Applying sorting and grouping to reports

· Performing calculations on reports

· Adding a graphic to a report

· Using the sub-report control

· Modifying section properties

· Using the Chart Wizard

If booking for more than one delegate, please contact us on 01189 778562 for discounted prices.