Course outline for
Microsoft 365 Access: Part 2

About This Course

Course Prerequisites

Course Overview

Course Objectives

How to Use This Book

Lesson 1: Implementing Advanced Form Design

TOPIC A: Add Controls to Forms

About Form Editing Modes

About the Types of Controls

Adding a Date Picker Control

About Quick Styles

About Tab Order

Using the Anchoring Tool

Activity 1-1: Adding Controls to Forms

TOPIC B: Set Form Controls

Moving Form Controls

Add Form Controls from the Field List

Remove Form Controls

Modify Data Sources

Set Form Control Properties

Activity 1-2: Managing Controls on a Form

TOPIC C: Create Subforms

About Subforms

Activity 1-3: Creating a Subform

TOPIC D: Organize Information with Tab Pages

Tab Pages

Activity 1-4: Organizing Information with Tab Pages

TOPIC E: Enhance Navigation with Forms

Creating a Navigation Form

Using a Navigation Form

Activity 1-5: Creating and Using a Navigation Form

TOPIC F: Format a Form

Insert Headers and Footers

Insert Images

Sort Records

Apply Themes

Insert Backgrounds

Change Margins

Activity 1-6: Inserting and Formatting Form Headers and Footers

TOPIC G: Apply Conditional Formatting

Conditional Formatting

Activity 1-7: Applying Conditional Formatting

Summary

Review Questions

Lesson 2: Using Data Validation

TOPIC A: Form and Field Validation

Field Properties

Input Masks

The Input Mask Wizard

Input Mask Characters

Lookup Lists

Expression Builder

Record Validation

Activity 2-1: Validating Data With a Field Property

TOPIC B: Data Validation Using Controls

Control Wizards

The Combo Box Control

The List Box Control

The Option Group Control

Activity 2-2: Using Combo Box Controls in a Form

Summary

Review Questions

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

Activity 3-1: Creating a Macro

TOPIC B: Restrict Records Using a Condition

Macro Conditions

The Where Condition

Activity 3-2: Using the Where Condition to Restrict Data

TOPIC C: Validate Data Using a Macro

Event Properties for Data Validation

Macro Action for Data Validation

Embedded Macros

Activity 3-3: Validating Data Using a Macro

TOPIC D: Automate Data Entry Using a Macro

Event Properties for Automating Data Entry

Macro Actions for Automating Data Entry

Activity 3-4: Automating Data Entry Using a Macro

TOPIC E: Convert a Macro to VBA

Macros and VBA

Activity 3-5: Converting a Macro to VBA

Summary

Review Questions

Lesson 4: Using Advanced Database Management

TOPIC A: Link Tables to External Data Sources

External Data Sources

The Linked Table Manager

Activity 4-1: Link Tables to External Data Sources

TOPIC B: Manage a Database

Exclusive Mode

Database Access Modes

Database Backup

The Compact and Repair Database Option

Activity 4-2: Managing a Database

TOPIC C: Determine Object Dependency

Object Dependency

Object Dependencies Task Pane

Activity 4-3: Viewing Object Dependency

TOPIC D: Document a Database

The Database Documenter

Activity 4-4: Documenting a Database

TOPIC E: Analyze the Performance of a Database

Performance Analyzer

Activity 4-5: Analyzing the performance of a database

Summary

Review Questions

Lesson 5: Distributing and Securing a Database

TOPIC A: Split a Database for Multiple User Access

Splitting a Database

The Database Splitter

Merging a Database

Activity 5-1: Splitting a Database

TOPIC B: Implement Security

Security Strategies in Access

The Message Bar

The Trust Center Dialog Box

Trusted Locations

Activity 5-2: Adding a Trusted Location

TOPIC C: Set Passwords

Password Protection Guidelines

Activity 5-3: Setting a Database Password

TOPIC D: Convert an Access Database to an ACCDE File

The ACCDE File Format

Activity 5-4: Converting a Database to ACCDE Format

TOPIC E: Package a Database with a Digital Signature

Digital Signatures

Digital Certificates

The Package and Sign Feature

Activity 5-5: Packaging a Database With a Digital Signature

Summary

Review Questions

Lesson 6: Managing Switchboards

TOPIC A: Create a Database Switchboard

Switchboards

Switchboard Manager

Activity 6-1: Creating a Simple Switchboard

TOPIC B: Modify a Database Switchboard

Switchboard Modification

Activity 6-2: Modifying a Database Switchboard

TOPIC C: Set Startup Options

Database Startup Options

Activity 6-3: Setting Startup Options

Summary

Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson Lab 1-2

Lesson Lab 1-3

Lesson 2

Lesson Lab 2-1

Lesson 3

Lesson Lab 3-1

Lesson Lab 3-2

Lesson 4

Lesson Lab 4-1

Lesson Lab 4-2

Lesson 5

Lesson Lab 5-1

Lesson Lab 5-2

Lesson 6

Lesson Lab 6-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

Index