Access 365 Intermediate
Intermediate
4h
By: Andy Altaner
Overview
This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.
Modules
1. Introduction
1.1 Access 365 Intermediate Introduction2 min
2. Designing Tables for Better Data Entry
2.1 Reviewing Table Design Principles11 min
2.2 Setting Field Size, Formats, and Captions11 min
2.3 Setting Default Values and Required Fields5 min
2.4 Restricting Data Entry-Validation Rules7 min
2.5 Restricting Data Entry-Input Masks9 min
3. Sharing Data with Other Applications
3.1 Exporting Tables and Queries to Excel5 min
3.2 Exporting Data to a SharePoint List2 min
3.3 Importing Data from Excel6 min
3.4 Importing Data from a SharePoint List2 min
3.5 Linking External Data Sources5 min
3.6 Using Word Merge6 min
4. Working with Action Queries
4.1 What are Action Queries4 min
4.2 Creating an Update Query6 min
4.3 Creating an Append Query4 min
4.4 Creating a Delete Query4 min
4.5 Creating a Make Table Query4 min
4.6 Changing Start Number of an Auto Number Field4 min
5. Advanced Query Techniques
5.1 Modifying Query Joins6 min
5.2 Using Self Joins to Combine Data6 min
5.3 Creating Find Unmatched and Find Duplicate Queries9 min
5.4 Creating Parameter Queries5 min
5.5 Creating a Top X Query2 min
5.6 Reviewing Calculated Query Fields6 min
5.7 Creating Crosstab Queries6 min
6. Automating Processes with Macros
6.1 Understanding Macro Basics14 min
6.2 Creating Macros to Open Forms by Record9 min
6.3 Validating Data Entry with Macros10 min
6.4 Creating a Macro to Automate Data Entry8 min
6.5 Advanced Data Entry Using Macros and DLOOKUP11 min
7. Advanced Form Techniques
7.1 Using Conditional Formatting4 min
7.2 Working with the New Label Name Property3 min
7.3 Organizing Form Fields with Tab Controls9 min
7.4 Creating an Option Group Control6 min
7.5 Creating a Combo Box Control4 min
7.6 Configuring a Combo Box Control to Show Search Results4 min
7.7 Using a Subform to Show Data From a Related Table6 min
8. Advanced Report Techniques
8.1 Inserting a Chart on a Report7 min
8.2 Showing Data in Columns7 min
8.3 Inserting a Subreport5 min
8.4 Configuring Reports with Parameter Queries3 min
8.5 Sending Reports3 min
9. Conclusion
9.1 Access 365 Intermediate Recap1 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES