Access 2016 Part 2

Microsoft Office Access 2016 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 2016’s features and tools.

The Microsoft Access 2016 Part Two program covers advanced Access features, including:

• Implementing Advanced Form Design
• Using Data Validation
• Using Macros to Improve User Interface Design
• Using Advanced Database Management
• Distributing and Securing a Database
• Managing Switchboards

Course Topics:

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