• LOGIN
  • No products in the basket.

Login

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.

 

Course Curriculum

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

FAQs

This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.

No prior qualifications are needed to take this course.

You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!

Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.

Don’t worry if you fail the test, you can retake it as many times as you want.

You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.

We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.

After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.

© iStudy
Select your currency
GBP Pound sterling