Categories

Our Workshops

Microsoft Access: Advanced

Microsoft Office Suite

Description

Microsoft Access Advanced

1-Day Workshop

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.

Microsoft Access Advanced 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

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.

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

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

_______________________________________________________________________________________________________________________________________________________________

On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material

________________________________________________________________________________________________________________________________________________________________

Workshop Dates