ADVANCED ACCESS - Stage 3 Course

Overview

At the end of this course the student will have a complete understanding of the higher functions of Access. Functions will be automated by creating simple and then advanced macros. Querying ability will be advanced and the use of SQL statements in queries will be explored.

Other area covered are how to work objects, the fundamentals of database management and how to protect data sources.

Prior Knowledge Requirements

The advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access at Intermediate level.

The course covers the following areas:

PivotTables and PivotCharts

• Create PivotTables
• Modify a PivotTable
• Working with a PivotChart

Creating Advanced Forms

• Design a Form based on joined tables
• Automating data entry
• Grouped control
• How to improve the user interface
• Designing Subforms

Macros

• Create and run Macros
• Attach Macros to Events of database objects

Creating Advanced Macros

• Create Macros to provide user interaction
• Use AutoKeys and AutoExec Macros

Exploring Access SQL

• How to identify different SQL clauses
• Writing SQL statements
• Attach SQL statements to database obects

 

What's next?

Progression to the VBA course for Access.         

Data Access Pages

• Designing Data Access Pages
• Apply Web Graphic Themes
• Working with Data Access Pages
• Work with Hyperling fields
• Control & Navigate Data Access Pages

Create Switchboards and set Startup Options

• Create a Database Switchboard
• Modify a Database Switchboard
• Set the Startup Options
• Modify the Startup Options

Managing Databases

• Work with database utilities to optimise resources
• Secure data by database replication

Distributing and Securing the Database

• Split a Database
• Implement Security
• Set Passwords
• Encode and Decode a Database
• Convert an Access Database to an MDE file