Access Advanced
Software: Microsoft Access
Training Course: Advanced Microsoft Access
Location: London
To Book Call: 0700 233 6600 or click here .
Summary: This course provides particpants with an in-depth knowledge of Access the opportunity to go beyond simple tasks and concentrate on using Access to its full extent.
Pre-requisites: All attendees to Microsoft Access courses must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered on our Microsoft Access 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 Access ' 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
