Click here to send this to a colleague or friend.

Microsoft Access: Advanced

Microsoft Office version 2010, 2013 and 2016

Many organisations have large databases in Access that have built up over the years. Staff have learned how to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports. However when databases get big, making your queries and forms effective can become more complex, and it is worth investing in Advanced Access training to get the most from your data and save time.

Advanced Microsoft Access training builds upon skills covered on our Microsoft Access Training Course.

During this workshop you will master the following:

  • How to streamline data entry and maintain data integrity with the use of macros
  • Look for duplicate or unmatched records in the data
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
  • Write advanced queries to analyse and summarize data
  • Learn to improve forms
  • Present the application is such a way that user can navigate to the appropriate tools
  • Understand how to maintain databases using Microsoft Office Access tools
  • Learn to share data between Access and other applications
  • Create and revise Microsoft Office Access macros
shadow

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists.

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

shadow
shadow
Register now for this workshop
WHAT WILL BE COVERED ON THIS ONE-DAY WORKSHOP?

Workshop Outline:
Querying with SQL (Structured Query Language)
Examining SQL Statements
Writing simple SQL Queries

Complex Queries
Find Unmatched Query
Finding Duplicate Records
The Crosstab Query Wizard

Macro’s
Creating a Simple Macro
Running Macros
Deleting Macros
Modifying Macros
Attaching Macro’s to events of Database objects
Attaching Macro’s to Command Buttons
Creating Advanced Macro’s
Macro Security

Application Navigation
Switchboards
Splash Screens
Automating Splash Screens and Switchboards

shadow

Importing and Exporting Objects
Importing from Access and Saving Import Specifications
Import from an Excel Workbook and Saving the Import Specifications
Import Text (CSV) Files
Using Saved import Specifications
Exporting from Access to another access database and Saving Import Specifications
Exporting from Access to Excel and Saving Import Specifications
Using Saved Export Specifications
Linking Objects
Linking to an Access Table
Linking to an Excel Workbook
Using the Linked Table Manager
Updating Links

Database Management
Convert a Database to a prior version
Analysing Performance
Splitting a Database
Compact and Repair Databases
Backing up a Database
Protecting a Database
Remove Password

Setting Options and Properties
Setting Access Options
Database Properties

shadow shadow

Who should attend?

This course is intended for a delegate who knows the basics of Microsoft Access. Delegates should already be able to create their own queries in Microsoft Access and they must understand the concepts of a database.

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

shadow
Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training.
Event Information:
Date: 30th January 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

6th March 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

Map: View map
Duration: 1 Day
Cost: R 2 350 .00 excl VAT
R 2 705.50 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow
Discount:

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates


In-house at your offices
25%
discount for 5 or more delegates

30% discount for 8 or more delegates
35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions

shadow

Bookings:

Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Screenshot: http://images.frontfoot.com
shadow
Microsoft workshop presenters are Certified Microsoft Office Specialists
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time


Workbooks and workshops are aligned to the prevailing Unit Standard;
Front Foot provide business training to business people;
Training is held at premium training venues