Workshop on Microsoft Access Intermediate: Expanding Skills for Microsoft Access Functionality

Program overview:

Microsoft Access is a program for the creation and management of database. It allows its’ users to capture, manage and report data in a professional way. It is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment settings and industrial sectors. Expanding your Microsoft Access tools and functionality knowledge will result in a robust, functional database application for you.

In this 2 days intensive hands-on program on Microsoft Access Intermediate course, participants will be walked through on many aspects of Access tools and functionalities including; relational database design, writing advanced queries, manipulating existing data, validating data entered into a database, and customizing reports using advanced tools, using the query wizard, adding a field, exporting an html document, adding charts to forms, and creating macros in analyzing data, presenting reports and information.

Note: This is a hands-on practical training; participants should come along with their laptops for step by step instructions and applications. Access basic knowledge is required.

For whom:

This program is designed for participants who individuals, SME owners, Entrepreneurs, Managers, Senior Supervisors and Professionals who want to expand their Microsoft Access skills from basics to intermediate level.

Learning objectives:

At the end of the program, participants will be able to:

• create a relational database;
• join tables and retrieve data from unrelated tables;
• carry out data validation in a database;
• use advanced queries to manipulate your data;
• organize a database for efficiency and performance;
• maintain data integrity; and
• customize reports to organize the displayed information and produce specific print layouts.

Course outline:

Day One

Module 1: Designing a Relational Database

Relational Database Design

Creating a Table

Creating Table Relationships

Module 2: Joining Tables

Creating Query Joins

Relating Data within a Table

Working with Subdatasheets

Module 3: Using Data Validation

Using Field Validation

Using Form and Record Validation

Day two

Module 4: Creating Advanced Queries       

Creating Parameter Queries

Summarizing Data

Creating Sub-queries

Creating Action Queries

Creating Unmatched and Duplicate Queries

Module 5: Organizing a Database for Efficiency

Data Normalization

Creating a Junction Table

Improving Table Structure

Module 6: Using Advanced Reporting Techniques

Including Control Formatting in a Report

Adding a Calculated Field to a Report

Adding a Sub-report to an Existing Report

Training Methodology

Lectures, discussions, exercises, and case studies will be used to reinforce these teaching/learning methods.