Microsoft Access 2000 Advanced

Course Aims
This one-day intensive training course is designed to give existing users of Microsoft Access 2000 an insight into some of the more advanced features of Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations.
Who Should Attend?
Existing users of Microsoft Access 2000 who want to customise forms, queries and reports. Note : A good working knowledge of Microsoft Access 2000 is required.
Course Outline: Microsoft Access 2000 Advanced
Access Tools
· Importing from Other Data Sources · Importing Data Using Drag-and-Drop · Backing Up and Restoring a Database · Compacting and Repairing a Database
Database Normalisation
· Theory of Normal Forms · De-normalisation · Naming Conventions
Access 2000 Performance Issues
· Indexes · Data Validation · Table Level Validation · Relationships and Referential Integrity · Relationships · Field Types · Referential Integrity Options · Join Types · Using Lookups for Referential Integrity · Multi-Table Datasheet View
Access and the Internet
· Using Hyperlinks · Using Hyperlinks in Forms · Exporting Datasheet Views to HTML · Data Access Pages
Advanced Form Design
· Using Advanced Forms Features · The Form Worksurface · Creating a Calculated Control · Adding a Graphic to a Form · Multi-Table Forms · Using the Subform Control · Switchboard Forms
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
Advanced Report Design
· Applying Sorting and Grouping to Reports · Performing Calculations on Reports · Adding a Graphic to a Report · Using the Subreport Control · Modifying Section Properties · Using the Chart Wizard