Access 365 Intermediate

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Designing Tables for Better Data Entry

Lecture 1: Reviewing Table Design Principles

Lecture 2: Setting Field Size, Formats and Captions

Lecture 3: Setting Default Values and Required Fields

Lecture 4: Restricting Data Entry: Validation Rules

Lecture 5: Restricting Data Entry: Input Masks

Chapter 3: Sharing Data with Other Applications

Lecture 1: Exporting Tables and Queries to Excel

Lecture 2: Exporting Data to a SharePoint List

Lecture 3: Importing Data from Excel

Lecture 4: Importing Data from a SharePoint List

Lecture 5: Linking External Data Sources

Lecture 6: Using Word Merge

Chapter 4: Working with Action Queries

Lecture 1: What are Action Queries?

Lecture 2: Creating an Update Query

Lecture 3: Creating an Append Query

Lecture 4: Creating a Delete Query

Lecture 5: Creating a Make Table Query

Lecture 6: Changing the Auto Number Field

Chapter 5: Advanced Query Techniques

Lecture 1: Modifying Query Joins

Lecture 2: Using Self Joins to Combine Data

Lecture 3: Creating Find Unmatched and Find Duplicate Queries

Lecture 4: Creating Parameter Queries

Lecture 5: Creating a Top X Query

Lecture 6: Reviewing Calculated Query Fields

Lecture 7: Summarizing Query Data with Totals

Lecture 8: Creating Crosstab Queries

Chapter 6: Automating Processes with Macros

Lecture 1: Understanding Macro Basics

Lecture 2: Creating Macros to Open Forms by Record

Lecture 3: Validating Data Entry with Macros

Lecture 4: Creating a Macro to Automate Data Entry

Lecture 5: Advanced Data Entry Using Macros and DLOOKUP

Chapter 7: Advanced Form Techniques

Lecture 1: Using Conditional Formatting

Lecture 2: Working with the New Label Name Property

Lecture 3: Organizing Form Fields with Tab Controls

Lecture 4: Creating an Option Group Control

Lecture 5: Creating a Combo Box Control

Lecture 6: Configuring a Combo Box Control to Show Search Results

Lecture 7: Using a Subform to Show Data From a Related Table

Chapter 8: Advanced Report Techniques

Lecture 1: Inserting a Chart on a Report

Lecture 2: Showing Data in Columns

Lecture 3: Inserting a Subreport

Lecture 4: Configuring Reports with Parameter Queries

Lecture 5: Sending Reports

Lecture 6: Accessing Dataverse Connector with Power Platform

Chapter 9: Conclusion

Lecture 1: Course Recap

Chapter 10: Final Assessment Quiz – Access 365 Intermediate