Pre-requisites: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered on our introduction course, either directly by attending the course, or having had hands on experience of the areas covered.

Duration: 1-Day
Start & Finish Times: 10am to 5pm

Objectives: This hands-on course will enable participants to go beyond the simple creation of basic tables, forms and reports. It concentrates on building greater flexibility into Access databases by studying the additional features that Access has to offer.

Who should attend: Our ‘Advanced' course is designed for busy people who need to develop their own Databases. If you have to build a database from scratch or enhance an existing one, and are familiar with our Introductory and Intermediate levels, this course will develop your skills further.

Overview of Content

Database Design Concepts: Further Analysis of Relationships. Join Types. Normalisation.

Creating A User Interface: Using the Toolbox Controls to create Command Buttons, Option Buttons, List Boxes, Tab Controls, Label and Text Boxes. Using the Field List.  Automating the User Interface via the Start-Up Dialogue Box.

Working With Macros: What are Macros? Create and Run Single Macros. Create and Run Group Macros. Analyse the Macro Actions List.  Automatically Execute Macros.  Create Conditions for Macros to run under. Add Macros to Forms and Form Objects.

Security: Initiating the Workgroup Administrator. Setting up the User And Group Accounts. Running the User-Level Security Wizard. Setting up the User And Group Permissions.

Working With Pivot Tables: Creating Pivot Tables. Re-Launching the Pivot Table Wizard. Using the Pivot Table toolbar. Filtering a Pivot Table.

Public Course Cost. £220.00
Reward Price. £110.00

Company Room Rates & Work Shops – Please call for quote Associated Access courses:  Programming