Microsoft Advanced Access Training - 1 day - £195 + vat – dates
Advanced Microsoft Access Training uk
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..
Microsoft Access Training Course Objectives:
By the end of this Advanced MS Access training course, delegates will have extended their knowledge of Access databases to include using macros to advanced levels.
Microsoft Access Training 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
Advanced Microsoft Access Course Prerequisites:
Delegates on this microsoft access training course should understand the basic concepts of creating an Access Database or attended our Beginners Access training courseBook this Advanced Microsoft Access training course one to one for £450 + vat
Access Advanced Training Recommended Reading
Advanced Projects for MS Access 2000 -
Philip A. Koneman - buy
from amazon
Access 2002 Bible - Cary Prague - buy
from amazon
Microsoft Access 2002 - buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft and Business Applications UK
UpMicrosoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.