Get Access to Entire Course Library of 2000+ Courses at £99 Get Now
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 2019 Beginner or equivalent experience.
Description
This course is designed to teach students intermediate level skills in Microsoft Access 2019. 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 2019 Advanced course.
Course Curriculum
| Access 2019 Intermediate | |||
| Module 01: Introduction to the Course | 00:02:00 | ||
| Module 02: Reviewing Table Design Principles | 00:11:00 | ||
| Module 03: Setting Field Size, Formats and Captions | 00:09:00 | ||
| Module 04: Setting Default Values and Required Fields | 00:06:00 | ||
| Module 05: Restricting Data Entry-Validation Rules | 00:06:00 | ||
| Module 06: Restricting Data Entry-Input Masks | 00:07:00 | ||
| Module 07: Exploring Tables and Queries to Excel | 00:04:00 | ||
| Module 08: Exporting Data to a SharePoint List | 00:02:00 | ||
| Module 09: Importing Data from Excel | 00:06:00 | ||
| Module 10: Importing Data from a Sharepoint List | 00:02:00 | ||
| Module 11: Linking External Data Sources | 00:06:00 | ||
| Module 12: Using Word Merge | 00:07:00 | ||
| Module 13: What are Action Queries | 00:03:00 | ||
| Module 14: Creating an Update Query | 00:06:00 | ||
| Module 15: Creating an Append Query | 00:04:00 | ||
| Module 16: Creating a Delete Query | 00:05:00 | ||
| Module 17: Creating a Make Table Query | 00:04:00 | ||
| Module 18: Changing Start Number of an Auto Number Field | 00:04:00 | ||
| Module 19: Modifying Query Joins | 00:09:00 | ||
| Module 20: Using Self Joins to Combine Data | 00:06:00 | ||
| Module 21: Creating Find Unmatched and Find Duplicate Queries | 00:09:00 | ||
| Module 22: Creating Parameter Queries | 00:07:00 | ||
| Module 23: Creating a Top X Query | 00:03:00 | ||
| Module 24: Reviewing Calculated Query Fields | 00:05:00 | ||
| Module 25: Summarising Query Data with Totals | 00:05:00 | ||
| Module 26: Creating a Crosstab Query | 00:07:00 | ||
| Module 27: Understanding Macro Basics | 00:14:00 | ||
| Module 28: Creating Macros to Open Forms by Record | 00:08:00 | ||
| Module 29: Validating Data Entry with Macros | 00:09:00 | ||
| Module 30: Creating a Macro to Automate Data Entry | 00:08:00 | ||
| Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions | 00:09:00 | ||
| Module 32: Using Conditional Formatting | 00:04:00 | ||
| Module 33: Working with the New Label Name Property | 00:02:00 | ||
| Module 34: Organising Form Fields with Tab Controls | 00:05:00 | ||
| Module 35: Creating an Option Group Control | 00:06:00 | ||
| Module 36: Creating a Combo Box Control | 00:05:00 | ||
| Module 37: Configuring a Combo Box Control to Show Search Results | 00:04:00 | ||
| Module 38: Using a Subform to Show Data from a Related Table | 00:05:00 | ||
| Module 39: Inserting a Chart on a Report | 00:07:00 | ||
| Module 40: Showing Data in Columns | 00:08:00 | ||
| Module 41: Inserting a Subreport | 00:04:00 | ||
| Module 42: Configuring Reports with Parameter Queries | 00:05:00 | ||
| Module 43: Sending Reports | 00:02: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.
