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

Macros

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