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.
This training course has been designed to give delegates a solid understanding of advanced Access tools and concepts in order to increase their knowledge.
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
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
Delegates should have attended the Intermediate course or gained similar knowledge in the workplace.
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?