Access Advanced

Access Advanced

Requirements:
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.
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.