Microsoft Access 2003 Advanced

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.