Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Access - Advanced

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

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.

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.

Regions:
  • London
  • Midlands
  • South East England
  • South West England
Delivery:
  • In House
  • Public
Category:
Difficulty:
  • Advanced

Further Details

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.

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

Guide price

£195 +VAT

 

Sponsored links

Interested in this course?

 

 

Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net