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
RI Top 500
ESFA
Skills for health Quality Mark
Matrix
ARC
Team Service Provider
Apprenticeships
Disability Confident Committed
Best Company 2019
Youth Employment UK
AELP
RI Supplier Awards
European Union
Inspiring the future
Investors in people
Cyber Essentials
Ofsted
5 Percent Club