Overview

You’ve covered many of the basic functions of Microsoft® Office Access® 2016, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Objectives

In this course, you will learn to create and manage a fundamental Access 2016 database.

You will:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.

Audience

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.

Prerequisites

To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

  • Microsoft® Office Access® 2016: Part 1
  • Microsoft® Office Access® 2016: Part 2

Outline

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

– Controls

– Types of Controls

– Command Buttons

– How to Add a Command Button to a Form

– Calendar/Datepicker Control

– How to Add a Datepicker to a Form

– Form Layouts

– How to Adjust a Form’s Layout

– Quick Styles

– How to Apply Quick Styles to Form Controls

– Tab Order

– How to Change Form Tab Order

– The Anchoring Tool

– How to Use the Anchoring Tool to Set a Form’s Screen Position

– Changing the Tab Order on a Form

Topic B: Enhance Navigation and Organization of Forms

– Subforms

– The Subform Control

– How to Create a Subform

– Creating a Subform

– Tab Pages

– How to Use the Tab Control

– Creating Tab Pages

– Navigation Control and Navigation Forms

– How to Create a Navigation Form

– Creating a Navigation Form

Topic C: Apply Conditional Formatting

– Conditional Formatting

– The Conditional Formatting Rules Manager

– How to Apply Conditional Formatting

– Changing the Display of Data Conditionally

Lesson 2: Sharing Data Across Applications

Topic A: Import Data into Access

– Data Importing

– The Get External Data Wizard

– Delimiters

– How to Import Data Into Access

– Importing Data from a Text File

– Importing Data from an Excel File

Topic B: Export Access Data

– Data Export to Text File Formats

– Data Export to Excel

– How to Export Data

– Exporting Data

Topic C: Link Tables to External Data Sources

– External Data Sources

– The Linked Table Manager

– How to Use an External Data Source

– Using an External Data Source

Topic D: Create a Mail Merge

– The Microsoft Word Mail Merge Wizard

– Merge Fields

– The Mail Merge Task Pane

– How to Create a Mail Merge

– Merging Access Data with a Word Document (Optional)

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

– Macros

– The Macro Builder Window

– Macro Actions

– Types of Macro Actions

– Action Arguments

– Object Events

– How to Attach a Macro to an Event

– Macros in Access Web Apps

– Access Web Apps User Interface Macros

– Access Web Apps Data Macros

– Creating a Macro to Open a New Record on a Form

Topic B: Restrict Records by Using a Condition

– Macro Conditions

– Conditions

– The Where Condition

– How to Use a Where Condition in a Macro

– Using the Where Condition to Restrict Data

Topic C: Validate Data by Using a Macro

– Event Properties for Data Validation

– Macro Actions for Data Validation

– Embedded Macros

– How to Use a Macro to Validate Data

– Using a Macro to Validate Data

Topic D: Automate Data Entry by Using a Macro

– Event Properties for Automating Data Entry

– Macro Actions for Automating Data Entry

– How to Automate Data Entry with a Macro

– Automating Data Entry with a Macro