Training at Blue Novation



Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Access Advanced

This training course has been designed to give delegates a solid understanding of advanced Access tools and concepts in order to increase their knowledge.

Course Topics


creating macros • the macro design window • saving and running a macro • creating a macro group • referring to control names • using conditions • debugging macros • autoexec & autokeys macros

Using Macros in Forms

form events • macros that respond to events • setting values • going to controls, pages, records • filtering records • finding a record • displaying messages • synchronising forms

Using Macros in Reports

report events • highlighting data and sections • totals in page headers & footers

Custom Toolbars and Menus

creating custom toolbars • the customise dialog box • changing a buttons appearance • showing and hiding toolbars • allowing use of built in toolbars • creating custom menus

Pivoting Data

Creating a PivotTable • Creating a PivotChart • Using PivotTables and PivotCharts

Using SQL in Access

using SQL to populate controls • creating union queries • creating sub-queries

Securing Your Database

securing an application • activating the logon password • creating a workgroup • adding users • creating and managing groups • assigning permissions • changing passwords • creating a shortcut to open a database



Follow on Courses

Access VBA

Course Dates

Course Dates

On Request

Bring Your Own Device Option

This is a BYOD (bring your own device) course.
Don’t have a laptop? No worries, we can provide a PC for training. 

Course Duration

1 day

Course Timings





Delegates should have attended the Intermediate course or gained similar knowledge in the workplace.

Training Formats

Private course · tailored · 1 to 1 (all instructor led)


A comprehensive course manual provides support throughout the course and upon your return to the office.

Not found the course you are looking for?


We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.




Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email