Workshop on Advanced Microsoft Access Course: Expanding Your Skills to the Advanced Functionalities

Program overview:

Microsoft Access is a powerful database application that enables its users to manipulate data in a number of ways. Data can be analyzed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more. Microsoft Access is extremely flexible and can be linked to data stored in other applications or to databases held in other programs.

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer based application is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, participants will be introduced to the concept of the relational database and the Microsoft Office Access 2016 relational database application and its information management tools.

For whom:

This course is designed for participants who wish to unlock the power of Microsoft Office Access advanced functionality in database management. Anybody working as Data Analysts, Data Administrators, and those who want to advance their knowledge of Microsoft Access tools and functionality 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:

• explain how to navigate the Microsoft access environment;
• list the various ways to write queries;
• explain 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;
• import and export data from excel; and
• save time on repetitive tasks by forming macros.

Course outline:

Day 1: 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

Day 2: 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

Day 3: 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.