Access for Office 365 - Part 2

Course Overview

Course Outline

1 - Improving Table Usability

  • Topic A: Create Lookups Within a Table
  • Lookup Fields
  • Field Properties for Lookups
  • How to Use the Lookup Wizard
  • Creating Lookups in a Table
  • Topic B: Work with Subdatasheets
  • Subdatasheets
  • How to Add a Subdatasheet to a Table
  • Adding a Subdatasheet to a Table
  • Topic A: Create Lookups Within a Table
  • Lookup Fields
  • Field Properties for Lookups
  • How to Use the Lookup Wizard
  • Creating Lookups in a Table
  • Topic B: Work with Subdatasheets
  • Subdatasheets
  • How to Add a Subdatasheet to a Table
  • Adding a Subdatasheet to a Table

2 - Creating Advanced Queries

  • Topic A: Create Query Joins
  • Query Joins
  • Types of Joins
  • Inner Join
  • Outer Join
  • Left vs. Right Outer Join
  • Self Join
  • The Join Properties Dialog Box
  • How to Create Query Joins
  • Creating Inner and Outer Joins
  • Creating a Self Join
  • Showing Records with Null Values
  • Topic B: Create Subqueries
  • Subqueries
  • Advantages and Disadvantages of Using Subqueries
  • Subquery Entered as an Expression
  • Subquery Syntax
  • How to Create Subqueries
  • Using a Subquery in a Query
  • Topic C: Summarize Data
  • Crosstab Query
  • The Crosstab Query Wizard
  • How to Summarize Data
  • Creating a Crosstab Query

3 - Improving Form Presentation

  • Topic A: Apply Conditional Formatting
  • Conditional Formatting
  • The Conditional Formatting Rules Manager
  • How to Apply Conditional Formatting
  • Changing the Display of Data Conditionally
  • Topic B: Create Tab Pages with Subforms and Other Controls
  • Tab Pages
  • How to Use the Tab Control
  • Creating Tab Pages
  • Visual Content
  • Control Properties
  • How to Include Attachments in a Database
  • Adding Attachments to a Database
  • Adding a Subform to a Page

4 - Creating Advanced Reports

  • Topic A: Apply Advanced Formatting to a Report
  • Report Format Options
  • Control Format Options
  • Data Bars
  • How to Show Data Bars in a Field
  • Showing Data Bars in Fields
  • Themes
  • Quick Styles
  • How to Format a Report
  • Formatting a Report
  • Topic B: Add a Calculated Field to a Report
  • Calculated Values in Report Controls
  • Expression Builder
  • How to Add a Calculated Field to a Report
  • Adding a Calculated Value to a Report
  • Topic C: Control Pagination and Print Quality
  • Print Layout Options
  • Report Pagination
  • Keep Together Property
  • Force New Page Property
  • How to Prepare a Report for Printing
  • Preparing a Report for Printing
  • Topic D: Add a Chart to a Report
  • Charts
  • How to Add a Chart to a Report
  • Adding a Chart to a Report

5 - Importing and Exporting Table Data

  • Topic A: Import and Link Data
  • External Data Sources
  • Dynasets
  • Linking Limitations
  • External Data Options
  • The Get External Data Wizard
  • Delimiters
  • The Linked Table Manager
  • Union Queries
  • How to Import and Link Data to Access
  • Importing Data from a Text File
  • Linking to Data in an Excel File
  • Combining Output from Multiple Data Sources
  • Topic B: Export Data
  • Data Export to Text File Formats
  • Data Export to Excel
  • How to Export Data
  • Exporting Data
  • Topic C: Create a Mail Merge
  • The Microsoft Word Mail Merge Wizard
  • The Mail Merge Task Pane
  • How to Create a Mail Merge
  • Merging Access Data with a Word Document (Optional)

6 - Using Queries to Manage Data

  • Topic A: Create Action Queries
  • Action Queries
  • Types of Action Queries
  • How to Create Action Queries
  • Using an Append Query to Copy Records
  • Creating a Delete Query
  • Topic B: Create Unmatched and Duplicate Queries
  • Unmatched and Duplicate Records
  • The Find Unmatched Query Wizard
  • The Find Duplicates Query Wizard
  • How to Create Unmatched and Duplicate Queries
  • Creating a Query to Search for Duplicate Records
  • Creating a Query to Search for Unmatched Records

7 - Creating Complex Reports and Forms

  • Topic A: Create Subreports
  • Subreports
  • Subforms on a Report
  • How to Create Subreports
  • Adding a Subreport to an Existing Report
  • Topic B: Create a Navigation Form
  • Navigation Control and Navigation Forms
  • Database Start-Up Options
  • How to Create a Navigation Form
  • Creating a Navigation Form
  • Setting Startup Options
  • Topic C: Show Details in Subforms and Popup Forms
  • Subforms
  • Popup Forms
  • How to Show Details in Subforms and Popups
  • Showing Details through a Subform
  • Showing a Reference Form as a Popup

8 - Creating Access Macros

  • Topic A: Create a Standalone Macro to Automate Repetitive Tasks
  • Macros
  • Macro Actions
  • The Macro Builder Window
  • Types of Macro Actions
  • Action Arguments
  • How to Create a Macro
  • Creating a Standalone Macro to Export Data
  • Topic B: Create a Macro to Program a User Interface Component
  • Object Events
  • Event Properties for User Interface Programming
  • Macro Actions for User Interface Programming
  • How to Attach a Macro to an Event
  • Creating an Event-Driven Macro to Open a Form
  • Topic C: Filter Records by Using a Condition
  • Macro Conditions
  • The Where Condition
  • How to Use a Where Condition in a Macro
  • Using the Where Condition to Filter Data
  • Topic D: Create a Data Macro
  • Data Macros
  • Event Properties for Data Validation
  • Common Actions for Data Macros
  • Data Blocks
  • How to Create a Data Macro
  • Creating a Macro to Validate Data
  • Revising a Data Validation Macro

9 - Using VBA to Extend Database Capabilities

  • Topic A: Introduction to VBA
  • VBA
  • Macros and VBA
  • How to Create a VBA Module
  • Guidelines for Using VBA vs. Access Macros
  • Converting a Macro to VBA
  • Modules
  • Sections of a Module
  • Procedures
  • The VBA Editor
  • VBA Naming Conventions
  • Using the VBA Code Editor to Edit and Run Code
  • Topic B: Using VBA with Form Controls
  • Objects
  • Properties
  • Methods
  • Events
  • How to Enhance Forms by Using VBA
  • Associating a VBA Procedure with a Control Event

10 - Managing a Database

  • Topic A: Back Up a Database
  • Database Access Modes
  • Exclusive Mode
  • How to Open a Database in Exclusive Mode
  • Database Backup
  • How to Create a Database Backup
  • The Compact and Repair Database Option
  • Compact On Close
  • How to Use the Compact and Repair Command on a Database
  • Backing Up and Compacting a Database
  • Topic B: Manage Performance Issues
  • Performance Analyzer
  • Error Checking Options
  • How to Use Performance Analyzer
  • Using the Performance Analyzer
  • Object Dependency
  • Object Dependencies Pane
  • How to Check Object Dependencies
  • Viewing Object Dependency
  • Topic C: Document a Database
  • The Need for Database Documentation
  • The Database Documenter
  • The Documenter Dialog Box
  • How to Document a Database with Database Documenter
  • Using the Database Documenter

11 - Distributing and Securing a Database

  • Topic A: Split a Database for Multiple-User Access
  • The Split Database
  • Advantages of a Split Database
  • How to Split a Database
  • Splitting a Database
  • Topic B: Implement Security
  • Security Strategies in Access for Office 365
  • The Message Bar
  • The Trust Center Dialog Box
  • Trusted Locations
  • How to Add a Trusted Location
  • Adding a Trusted Location
  • Password Protection
  • How to Set a Database Password
  • Setting a Database Password
  • Topic C: Convert an Access Database to an ACCDE File
  • The ACCDE File Format
  • User Templates
  • Database as a Template
  • How to Convert an Access Database to an ACCDE File
  • Converting a Database to ACCDE Format
  • Topic D: Package a Database with a Digital Signature
  • Digital Signatures
  • Digital Certificates
  • The Package and Sign Feature
  • How to Digitally Sign a Database
  • Digitally Sign a Database

12 - Appendix A: More Queries and Calculations

13 - Appendix B: Microsoft® Access® for Office 365 Common Keyboard Shortcuts

14 - Appendix C: Common SQL Commands

15 - Appendix D: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500

Enroll Today

This is a 2-day class

Price: $790.00
Payment Options

ILT Instructor‑Led Training


GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.