Microsoft Access 2016/19
Introduction

Course Overview

This course is for the students who has never worked with an Access database before. The course introduces you to Microsoft Access 2016/19 which is a powerful database application software. During this course, you will learn how to create simple tables, forms, queries and reports. At the end of the course you will be able to create your own simple database.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Design a Table

Design a table with various field types and properties to collect data.

Design a Form

Create a simple form based on a table to display the fields in a more user-friendly environment.
Use the formatting commands to design your form.
Use the property sheet or callouts located next to each section or control to design your form.
Create your own AutoFormats for future forms.

Create Queries

Create select queries using wildcards and operators to extract information that you have collected on your table.
Create a calculated field in a query.
Run Delete and Update queries.
Create calculated fields in a query.
Create summary queries using SUM, AVERAGE, MAX AND MIN to summarize data.

Set up Relationships

Set up simple relationships between tables based on a key field.
Display related tables in a query.

Create a Report

Create a simple report based on tables or queries to display your data.
Place a calculated control on a report.

Validations and Restrictions

Add validations, restrictions and input masks on fields to ensure data is consistent.

Mail Merge

Create a query in Microsoft Access that is based on two tables and then merge the query into a Word letter.

Application Overview: Microsoft Access 2016/19

Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. Get started quickly with prebuilt applications that you can modify or adapt to your needs. You can create and edit detailed reports that display sorted, filtered, and grouped information. Using Microsoft Access, you can manage all your information from a single database file, run queries to find and retrieve just the data you want, create forms to view, add, and update data in tables.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Access 2016/19 Introduction