Microsoft Access 2016 Advanced

Welcome to the second part of our Microsoft Office Access 2016 courseware. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This course is intended to help all users get up to speed on the different features of Access and to become familiar with it’s more advanced features. We will cover how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards.

 

This manual assumes that the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Access 2016 courseware, including:

Getting started with Access

Working with table data

Querying a database

Creating advanced queries

Generating reports and using advanced reporting tools

Customizing the Access environment

Designing a relational database

Joining tables

Organizing a database for efficiency

Sharing data across applications

 

This course is aimed at all users of Microsoft Outlook 2016, Microsoft’s powerful information management program. It will help users get up to speed on the various Outlook 2016 features and become familiar with its more advanced options.

 

Prerequisites

 

This manual assumes that the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Access 2016 courseware, including:

Getting started with Access

Working with table data

Querying a database

Creating advanced queries

Generating reports and using advanced reporting tools

Customizing the Access environment

Designing a relational database

Joining tables

Organizing a database for efficiency

Sharing data across applications

 

Topics

 

Module 1: Implementing Advanced Form Design

Module 2: Using Data Validation

Module 3: Using Macros to Improve User Interface Design

Module 4: Using Advanced Database Management

Module 5: Distributing and Securing a Database

Module 6: Managing Switchboards