Microsoft Access 2003: Advanced (1 day)

Course Overview

This course is valuable for anyone who plans to prototype, build and integrate relational databases using Access to an advanced level.

Save hours of endless web browsing for the right course, if this Microsoft training course isn't suitable, use our advanced search function and you could be attending your next Microsoft training course in 3 simple clicks.

Related Courses

• Microsoft Access 2003: Introduction for Beginners (1 day)
• Microsoft Access 2003: Intermediate (2 day)
• Microsoft Access 2003: Introduction for Beginners (2 day)
• Microsoft Access 2003: Advanced (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2002 2003: Advanced Development in Microsoft Access
• Microsoft Access 2003: Programming with VBA

Audience

Familiarity with Windows is assumed. Ideally you will have attended an Access Intermediate course; alternatively you should have a good understanding of creating flat file and relational databases.

Skills Gained

After the course delegates will be able to:

• Create and save macros using course handouts
• Practise password and user level protection implementation
• Perform advanced queries using course review questions

Course Outline

Advanced Queries

• Querying Multi-Tables
• Action Queries
• Cross tab/Summary Queries
• Calculations in Queries
• Querying from a Form

Macros

• Creating
• Saving
• Running and Debugging

Implementation of Macros

• In Forms
• In Reports

Securing your Database

• Password Protection
• User Level Protection

Database Administration

• Database Back up
• Repairing a database