Microsoft Access 365 Part 2

Microsoft Office Access 365 is the newest version of Microsoft’s popular database program. This is the second part of a two-level course, and it explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of Access 365’s features and tools.

In this lesson you will learn how to:

• Split a database for multiple user access
• Manage Switchboards
• Advanced Database Management
• Data Validation
• Using Macros to Improve user Interface Design

Course Topics:

Lesson 1: 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
• Review Question Answers
• Lesson Lab 5-1
• Lesson Lab 5-2
• Course Completion

Lesson 2: 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
• Review Question Answers
• Lesson Lab 6-1
• Course Completion

Lesson 3: 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

Lesson 4: 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
• Review Question Answers
• Lesson Lab 2-1
• Course Completion

Lesson 5: 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
• Review Question Answers
• Lesson Lab 3-1
• Lesson Lab 3-2
• Course Completion