When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Access 365 Intermediate: Take Your DB to the Next Level!
Delve deeper into queries, forms and reports with Action Queries, Sub Forms, SQL and creating Dialog Boxes.
This Course Includes
udemy
4.5 (2 reviews )
5h 10m 
english
Online - Self Paced
professional certificate
Udemy
About Access 365 Intermediate: Take Your DB to the Next Level!
After taking my Access 365
Foundations
course you are now ready for the next level:
Access 365 Intermediate
. Continue your educational journey with up-to-date content on how to take your Access 365 Database to the next level by creating Action Queries, using Sub Forms, and creating Dialog Boxes for your users. Students will learn to connect to various data sources as well as linking to them. They will then look at the advanced features of Queries, Forms and Reports. Creating action queries, using wildcards in queries, and working with sub forms and popup modal forms are just some of the advanced skillsets they will acquire. Then they focus on report grouping techniques, using SQL to pull reports and how to add blank lines and creating columns in their reports. Build your ultimate Access 365 database with the skills you learn in this course and build the confidence to tackle even bigger databases in the industry. All databases in the world have the same logic when it comes to all the objects within such a database and this course will provide you with those skills and logic. This course is intended who want to build on their skill set of MS Access databases and start to take their data to the next level. This course will prep the student for the MS Access O365 Expert course. Your InstructorRobin Solonenko
What You Will Learn?
- Importing / Exporting and Linking to External Data Sources. .
- Creating queries to find duplicates and unmatched records. .
- Learn to create and when to use Action Queries. .
- How to create and use sub forms. .
- Learn to create advanced form controls. .
- When to use popup / modal forms. .
- Use functions in your reports. .
- Using SQL to pull your reports. .
- Enhance your reports with adding emphasis at runtime, blank lines and columns..