Advanced Microsoft Access Training

Many organisations have large databases in Access that have built up over the years.

Staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.

However when databases get big, making your queries and forms effective can become more complex, and it is worth investing in advanced Access training to get the most from your data and save time.

Advanced Microsoft access training builds upon skills covered on our beginners Microsoft Access Training Course.

Delegates on our advanced Microsoft access training course will learn how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

We also provide private and in-company Microsoft Access courses. Call +44 (0) 1273 622272 to discuss.

Microsoft Access Course Objectives:

By the end of this Advanced MS Access training course, delegates will have extended their knowledge of Access databases to advanced levels to include using macros.

Advanced Microsoft Access Training Course Prerequisites:

Delegates on this Microsoft access course should understand the basic concepts of creating an Access Database or attended our Beginners Access training course.

Read More About Access on our Blog:

• New Features in Access 2010
• Microsoft Office Shortcuts

Advanced Microsoft Access Course Content

Introduction

• Review of basic concepts:
• Design concepts
• Relationships between tables

Designing Queries

• Using And and Or statements
• Totals Queries
• Creating calculations in queries
• Parameter Queries
• Autolookup Queries

Designing Forms

• Adding controls
• Working with combo boxes
• Working with calculated controls
• Control properties
• Working with subforms

Report Design

• Creating a report using the Wizard
• Designing grouped reports
• Adding sub-totals to reports

Macros

• Creating simple macros
• Creating grouped macros
• Creating conditional macros
• Assigning macros to command buttons
• Creating a Switchboard
• Using macros to pass conditions between forms
• Using macros to pass conditions to run reports

Microsoft Access VBA Course Recommended Reading

Advanced Database Projects in Access 2007