Advanced Access

Duration: ONE DAY 

Pre-requisites:

Delegates should have attended the intermediate course 

Course Objectives:

After attending the course, delegates should have enhanced their use and understanding of the advanced features of Access 

Course Content:

Advanced queries: 

Queries which refer to controls on forms (hidden and unhidden)

Queries using advanced functions: Data conversion, date and time, string manipulation, logical, domain Aggregate functions

Advanced forms:

Creating forms which contain charts

Using the Pivot Table Wizard

Creating forms to get user input

Referring to control values on a form

Referring to controls on parent and sub-forms

Setting event properties for controls

Finding data from drop-downs, option buttons and other controls

Creating dialogue boxes from forms 

Advanced Reports:

Creating reports which contain charts 

Filtering Report data through a macro

Advanced macros:

Using conditional macros review

Macros which refer to controls on forms

Macros which find data specified on forms

Collecting macros into groups:

Naming macros

Referring to a macro in a group

Using the expression builder

Controlling the properties of objects through macros 

Auto-executing macros

An introduction o Visual Basic for Applications (VBA)

Converting macros to VBA

Customising the application: 

Creating and controlling the display of toolbars and menu bars

Setting Startup options

Analysing and documenting the database

Understanding and managing database replication

Understanding and managing database security