Key Training Logo

Microsoft Access 2016 – Module C (Special Features)

Course Code: ACCMODC16

Duration: 1 Day

Course Aims:

This course provides attendees with the knowledge required to carry out more complex design and
maintenance tasks and build an automated database application.

Course Pre-requisites:

This course is open to anyone seeking to create an effective database with an intuitive and user-friendly
customised interface. Significant knowledge of designing and creating database objects (tables, queries, forms and reports) is required together with notions about how to apply the learning to a real-life database application.

Course Objectives:

On completion of this course delegates will be able to:
▪ Improve the effectiveness of a database by transferring data from other sources and employing
maintenance tools;
▪ Automate tasks and functionality using macros; and
▪ Produce a customised interface to facilitate using the database.

 

Course Content:

Introduction and Objectives

Database Design
▪ Importing data tables into an Access database
▪ Linking data tables into an Access database
▪ Database tools and utilities

Special Queries
▪ Action queries
▪ Find duplicates query
▪ Find unmatched query
▪ Crosstab query

Creating Macros
▪ Using the Macro Builder
▪ Macro actions and arguments
▪ Running macros

Using Macros
▪ Assigning macros to form event properties
▪ Creating conditional macros
▪ Using sub macros

Creating and Using a switchboard

Customising start up options for enabling
switchboard use

Action planning

Review of Programme

Key Affiliations

 
REC Logo
Skills for health Quality Mark
Ofsted
ESFA
Matrix
RI Supplier Awards
5 Percent Club
Youth Employment UK
RI Top 500
European Union
Best Company 2019
AELP
Team Service Provider
Apprenticeships
ARC
Inspiring the future
Investors in people