Workshop on Microsoft Access Master-class: Unlocking the Power of MS Accessfrom Basics to Advanced Functionalities in Database Management

Program overview:

Microsoft Access is a program for the creation and management of database. It allows its’ users to manage, capture and report data in a professional way.

This program is designed to equip participants with essential skills and knowledge required to create and design databases, query tables and create forms and reports to achieve desired results. It will walk participants through various Access basics to advanced features, tools and functionalities needed to create and design Access databases, manage and design interfaces with Access Forms, work with Access tables, relationships and automate tasks with Macros and VBA. .

This Master-class training is a complete Access learning loop from introduction to advanced. It is designed to really unlock the power of the Access program from basic to advanced functionality in database management.

Note: Participants should come along with their Laptops and have a basic working knowledge in windows’ environment.

For whom:

This course is designed for participants who wish to unlock the power of Microsoft Office Access from basics to advanced functionality in database management. Anybody working as Data Analysts, Data Administrators, and those who are new to the Access Database will equally benefit from this program.

This program is equally relevant to Office job holders, such as PA, Secretary, Admin Assistant, and Administrator, Office Manager, IT Technician, Web Developer, Accountant or any other role in the office environment.

Learning objectives:

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

• learn and understand how to navigate the Microsoft Access environment;
• list and explain the various ways to write queries;
• list the various query types;
• build Forms and Reports based on Queries;
• automate tasks using Macros;
• create a Master-Child relationship in Access Forms;
• embed Sub-Reports in a report;
• share data with other Microsoft native applications;
• retrieve data from unrelated tables;
• learn how to import and export data from excel; and
• save time on repetitive tasks by forming macros.

Day 1: Access Basics

Module 1: Microsoft Access: Overview

Orientation to Microsoft Access

Create a Simple Access Database

Get Help and configure options in Microsoft Access

Module 2: Working with Table Data

Modify Table Data

Sort and Filter Records

Module 3: Creating and Using Basic Queries

Create Basic Queries

Sort and Filter Data in a Query

Perform Calculations in a Query

Module 4: Creating and Using Forms

Create Basic Access Forms

Work with Data on Access Forms

Module 5: Generating and Formatting Reports

Create a Report

Add Controls to a Report

Enhance the Appearance of a Report

Prepare a Report for Print

Organize Report Information

Format Reports

Day 2 & 3 Access Intermediate

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

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

Day 4 & 5 Access Advanced           

Microsoft Access 2016 – Basics

Introduction to MS Access

Creating Tables & Setting up Properties

Queries

Creating Forms & Reports

Working with Macros, Integrating Access with Office Suite

Database Management

Exercise Files- Microsoft Access 2016

Microsoft Access 2016 – Advance Questions in depth

Introduction to Access 2016 Advance Questions in Depth

Understanding Queries

Query Criteria

Parameters Queries

Use Mathematical Operations and Functions

Summarize Data with Aggregate Functions

Dates, Time and Numbers Functions

IF Function and Calculations

Records and Database

Explore the Basics of SQL

Values, Database and Markup

Exercise Files- ACCESS 2016 – Advance questions in depth

Microsoft Access 2016 – Advanced tricks and tips

Introduction to Trick and Tips of Access 2016

Explore Startup Options

Embed Queries in Reports

Create a Back End and Front Ends

Build the Forms and Reports

Add Customized Functions and Visual Basics

Exercise Files- Access 2016 Advance Tips & Tricks

Training Methodology

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