Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Handelsbanken

I am very impressed with the training. My access skills are very much self taught and I was unsure about whether the level of the course would be right. The training was delivered in a really clear manner and at the right pace. Thank you very much to Richard for the course. I would thoroughly recommend it.

Blaby District Council

"I found the training session really interesting as I use Access daily and had no idea on how much it actually can do. Simon is a fantastic trainer and takes his time explaining all the background so you get to understand better, he is thorough and has the patience of a saint. I would highly recommend anyone considering this training to consider going booking Simon and his team."

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Locations outside Oxford

Microsoft Access 365 Training Course Advanced Oxford

Oxford Advanced Microsoft Access 365 Course Overview

Advanced Microsoft Access 365 Training Course training course in Oxford - Radcliffe Camera

The university town of Oxford. They say that people go to Cambridge to study science, and Oxford to study politics. Whatever the reason, Oxford a fantastic place to conduct your Advanced Microsoft Access 365 Training Course training course.

Other training courses in Oxford.

Oxford, the City of Dreaming Spires, is famous for its prestigious university and beautiful architecture.

Course Duration: 1 Day

Course Prerequisites for your training in Oxford

To make the most of this course, we recommend:

A solid understanding of Access basics, including creating and editing tables, forms, and queries
Familiarity with relational databases, including linking tables and designing relationships
General experience navigating the Access interface and managing database objects like forms and reports

Not sure if you're ready for the advanced course? Take a quick look at the beginners training to make sure you're all set. Microsoft Access 365 Training Course Beginners.

Complete Course Outline

Implementing Advanced Form Design

Add controls to forms
Set form controls
Create subforms
Organise information with tab pages
Enhance navigation with forms
Format a form
Apply conditional formatting

Using Data Validation

Form and field validation
Data validation using controls

Using Macros to Improve User Interface Design

Create a macro
Restrict records using a condition
Validate data using a macro
Automate data entry using a macro
Convert a macro to VBA

Using Advanced Database Management

Link tables to external data sources
Manage a database
Determine object dependency
Document a database
Analyse the performance of a database

Distributing and Securing a Database

Split a database for multiple user access
Implement security
Set passwords
Convert an Access database to an ACCDE file
Package a database with a digital signature

Managing Switchboards

Create a database switchboard
Modify a database switchboard
Set start up options

Other Related Courses

Microsoft Access Training Courses

Microsoft Access 365 Training Course Beginners

Microsoft Access 2019 Training Course Intermediate

Post-Course Resources

Training notes & exercise files
Online materials: video tutorials & shortcuts
3 months post training support

Microsoft Access training is available for online and in person training.

Live Online Training