Booking options
£25
Course Images
Access 365 Intermediate
By iStudy UK
- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
4 hours 32 minutes
All levels
Description
Learning Objectives
Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion
Pre-Requisites
Access 365 Beginner or equivalent experience.
Description
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.
Module 1: Design Tables for Better Data Entry | |||
Reviewing Table Design Principles | 00:11:00 | ||
Setting Field Size, Formats, and Captions | 00:11:00 | ||
Setting Default Values and Required Fields | 00:05:00 | ||
Restricting Data Entry-Validation Rules | 00:07:00 | ||
Restricting Data Entry-Input Masks | 00:09:00 | ||
Module 2: Share Data with Other Apps | |||
Exporting Tables and Queries to Excel | 00:05:00 | ||
Exporting Data to a SharePoint List | 00:02:00 | ||
Importing Data from Excel | 00:06:00 | ||
Importing Data from a SharePoint List | 00:02:00 | ||
Linking External Data Sources | 00:05:00 | ||
Using Word Merge | 00:06:00 | ||
Module 3: Work with Action Queries | |||
What are Action Queries | 00:04:00 | ||
Creating an Update Query | 00:06:00 | ||
Creating an Append Query | 00:04:00 | ||
Creating a Delete Query | 00:04:00 | ||
Creating a Make Table Query | 00:04:00 | ||
Changing Start Number of an Auto Number Field | 00:04:00 | ||
Module 4: Advanced Query Techniques | |||
Modifying Query Joins | 00:06:00 | ||
Using Self Joins to Combine Data | 00:06:00 | ||
Creating Find Unmatched and Find Duplicate Queries | 00:09:00 | ||
Creating Parameter Queries | 00:05:00 | ||
Creating a Top X Query | 00:02:00 | ||
Reviewing Calculated Query Fields | 00:06:00 | ||
Summarizing Query Data with Totals | 00:04:00 | ||
Creating Crosstab Queries | 00:06:00 | ||
Module 5: Automate Processes with Macros | |||
Understanding Macro Basics | 00:14:00 | ||
Creating Macros to Open Forms by Record | 00:09:00 | ||
Validating Data Entry with Macros | 00:10:00 | ||
Creating a Macro to Automate Data Entry | 00:08:00 | ||
Advanced Data Entry Using Macros and DLOOKUP | 00:11:00 | ||
Module 6: Advanced Form Techniques | |||
Using Conditional Formatting | 00:04:00 | ||
Working with the New Label Name Property | 00:03:00 | ||
Organizing Form Fields with Tab Controls | 00:09:00 | ||
Creating an Option Group Control | 00:06:00 | ||
Creating a Combo Box Control | 00:04:00 | ||
Configuring a Combo Box Control to Show Search Results | 00:04:00 | ||
Using a Subform to Show Data From a Related Table | 00:06:00 | ||
Module 7: Advanced Report Techniques | |||
Inserting a Chart on a Report | 00:07:00 | ||
Showing Data in Columns | 00:07:00 | ||
Inserting a Subreport | 00:05:00 | ||
Configuring Reports with Parameter Queries | 00:03:00 | ||
Sending Reports | 00:03:00 | ||
Resource | |||
Resource - Access 365 Intermediate | 00:00:00 | ||
Final Exam | |||
Final Exam - Access 365 Intermediate | 00:20:00 |
About The Provider
We understand more than anyone how important it is for yo...
Reviews
There are no reviews for Access 365 Intermediate yet.Why not be the first one to review this course?