Course outline for
Microsoft Access 2016: Part Two

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1:
Implementing Advanced Form Design

Types of Controls

Command Buttons

Quick Start Fields

Calendar/Datepicker Control

Form Layouts

Quick Styles

Tab Order

The Anchoring Tool

Activity 1-1

Move Form Controls

Add Form Controls

Remove Form Controls

Modify Data Sources

Set Form Control Properties

Manage Labels

Activity 1-2

Subforms

Activity 1-3

Tab Pages

Activity 1-4

Navigation Control and Navigation Forms

Setting Navigation Options

Creating a Navigation Form

Using a Navigation Form

Activity 1-5

Insert Headers And Footers

Insert Images

Auto-Order Forms

Sort Records

Apply Themes

Insert Backgrounds

Change Margins

Activity 1-5

Conditional Formatting

Activity 1-6

Summary

Review Questions

Lesson 2:
Using Data Validation

Field Properties

Input Masks

The Input Mask Wizard

Input Mask Characters

Lookup Lists

Expression Builder

Activity 2-1

Form Validation

Control Wizards

The Combo Box Control

The List Box Control

The Option Group Control

Record Validation

Activity 2-2

Summary

Review Questions

Lesson 3:
Using Macros to Improve User Interface Design

Macros

The Macro Builder Window

Macro Actions

Types of Macro Actions

Action Arguments

Object Events

Macros in Access Web Apps

Activity 3-1

Macro Conditions

The Where Condition

Activity 3-2

Event Properties for Data Validation

Macro Actions for Data Validation

Embedded Macros

Activity 3-3

Event Properties for Automating Data Entry

Macro Actions for Automating Data Entry

Activity 3-4

Macros and VBA

Activity 3-5

Summary

Review Questions

Lesson 4:
Using Advanced Database Management

External Data Sources

The Linked Table Manager

Activity 4-1

Exclusive Mode

Database Access Modes

Database Backup

The Compact and Repair Database Option

Activity 4-2

Object Dependency

Activity 4-3

The Database Documenter

Activity 4-4

Performance Analyzer

Activity 4-5

Summary

Review Questions

Lesson 5:
Distributing and Securing a Database

Splitting a Database

Merging a Database

Activity 5-1

Security Strategies in Access 2016

The Message Bar

The Trust Center Dialog Box

Trusted Locations

Activity 5-2

Password Protection Guidelines

Activity 5-3

The ACCDE File Format

User Templates

Saving Databases as Templates

Activity 5-4

Digital Signatures

Digital Certificates

The Package and Sign Feature

Activity 5-5

Summary

Review Questions

Lesson 6:
Managing Switchboards

Switchboards

Switchboard Manager

Activity 6-1

Switchboard Modification

Activity 6-2

Database Startup Options

Activity 6-3

Summary

Review Questions

Lesson Lab 1-1

Lesson Lab 1-2

Lesson Lab 1-3

Lesson Lab 2-1

Lesson Lab 3-1

Lesson Lab 3-2

Lesson Lab 4-1

Lesson Lab 4-2

Lesson Lab 5-1

Lesson Lab 5-2

Lesson Lab 6-1

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

Index