Microsoft Access Module C (Special Features and Automation)

‍Course Code: ACMODC19

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

‍