A hands-on instructor-led Microsoft Access training course helping people to improve their existing Access skills and automate and manage a database more effectively. This upskilling is achieved through learning, discussion and practice while working together with a master-class-level trainer in a professional classroom environment.

Pricing
- 1 Day of group training is £799 + VAT per day
- 2 Days of group training is £699 + VAT per day
- 3 Days of group training is £649 + VAT per day
- One-to-one training is £349 + VAT per day
• Creating advanced queries for good data management
• Improving experiences with the user interface using forms
• Automating the database using macros for ease and control
• Managing the security, performance and structure of the database
This third level Access training course is suitable for those competent at Access's Forms, Queries, Tables and Reports and are looking to learn about advanced query and form features, database utilities and database security.

Whats covered in this course

Database Structure
- Table and Database structure
- Junction tables
- Revision of Relationships
- Relationship types and options
Advanced Queries
- Find unmatched Query
- Find duplicates Query
- Crosstab
- Sub Queries
- Union Queries
Advanced Forms
- Navigation Forms/Switchboards
- Form Properties
- Show form at Startup
Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Macro Groups
Database Utlities
- Determining Object Dependency
- Documenting a Database
- Analysing the Performance of a Database
- Compact and Repair Database
- Splitting a Database
- Linked Table Manager
Database Security
- Setting a Database password
- Securing a database

What Etopia clients are saying about our training courses

"I can honestly say I think it was one of the best trainings I’ve had, Irene is a very good, clear and patient trainer, 15 out of 10.
★★★★★".

Fiona Slater, Shell, MS Access.
"Just wanted to drop you a quick email to say how impressed we were with the training over the past 2 days. Our trainer Emma was very knowledgeable and the training was held at a nice relaxed comfortable pace.
★★★★★".

Daniel Clissett, SSE, Access Training.

Live Online Training

A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.
Classroom Training

We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.
Training at Your Workplace

Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.

Send an enquiry or call us on 0141 730 0025