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