Access 365 Intermediate: Take Your DB to the Next Level!

Focused View

Robin Solonenko

5:07:53

124 View

1. Getting Started

1. Course & Instructor Introduction.mp4

01:12

2. Support Notes for Students.html

3.1 Access Intermediate Data Files.zip

3. Course Resources & PDF Manual.html

4. Contacting the Instructor.mp4

00:52

5. Lets Set Some Expectations.mp4

02:47

6. PDF Manual & Video Correlation.html

2. Import Export with External Data

1. Linking to External Data.mp4

10:03

2. LInked Table Manager.mp4

06:26

3. Importing & Exporting Data.mp4

10:28

4. Appending a Data File.mp4

14:40

5. Section 2 Lesson 1 Exercise.mp4

00:38

3. Advanced Query Techniques

1. Creating Special Types of Queries.mp4

11:12

2. Action Queries.mp4

25:32

3. Using Wildcards in Queries.mp4

09:20

4. Using Dates in Calculations.mp4

11:00

5. Self Joining Queries.mp4

06:04

6. Section 3 Lesson 2 Exercise.mp4

00:42

4. Advanced Form Techniques

1. Working with Sub Forms.mp4

12:17

2. Using Tab Controls.mp4

09:55

3. Using Chart Controls.mp4

05:58

4. Navigation Forms.mp4

04:52

5. Code & Expression Builders.mp4

33:51

6. Popup & Modal Forms.mp4

07:09

7. Adding Navigation Buttons.mp4

07:40

8. Passing Values - Forms & Queries.mp4

16:23

9. Counting Records.mp4

09:56

10. Auto Closing Forms.mp4

04:23

11. Creating a Main Menu.mp4

10:43

12. Section 4 Lesson 3 Exercise.mp4

00:46

5. Advanced Report Techniques

1. Grouping Report Data.mp4

17:23

2. Creating Report Totals.mp4

09:39

3. Using SQL to Pull Reports.mp4

13:51

4. Adding Emphasis at Runtime.mp4

07:52

5. Adding Blank Lines.mp4

11:55

6. Creating Report Columns.mp4

09:49

7. Section 5 Lesson 4 Exercise.mp4

00:39

6. Next Steps

1. Instructor Thankyou.mp4

00:42

2. Access 365 Intermediate Project.mp4

01:14

Description

Delve deeper into queries, forms and reports with Action Queries, Sub Forms, SQL and creating Dialog Boxes.

What You'll 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.

Who is this for?

Anyone who needs to create a database to hold all your data for your business.

Anyone who has outgrown using Excel to hold and collect your data.

Anyone who wants a better understanding of Relational Databases

Anyone who has learnt the basics of MS Access Databases and needs to go to the next level.

More details

Description
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 Instructor
Robin Solonenko

Who this course is for:
Anyone who needs to create a database to hold all your data for your business.
Anyone who has outgrown using Excel to hold and collect your data.
Anyone who wants a better understanding of Relational Databases
Anyone who has learnt the basics of MS Access Databases and needs to go to the next level.

User Reviews

Rating

average 0

Total votes0

Focused display

Having over 25 years of Microsoft training under my belt, I am well versed in Microsoft products and have delivered and developed Microsoft courses for corporate giant Suncor Energy and currently technical education institutes across western Canada. I am also well versed in MS Power BI, DAX, PowerApps, Power Automate and SharePoint Administration.I have created and released NAIT's first Power Platform certificate program being released in November 2022. I bring extensive knowledge of end user Microsoft applications and their integration to our every day office lives. I love to empower my students and help them take their knowledge to the next level in any course to make them feel confident in the workplace.I have been instructing Microsoft products since 1997 and have developed course content since 2013 by writing manuals for all the courses I instruct today. From the Power line of products (Power BI, PowerApps, Power Automate) to SharePoint Online to Access Databases I can teach you and your employees in any environment.From classroom instruction to virtual training to course video content, I offer you hands on training and skills development for all levels of these products and because I write my own content (manuals) for these products I can maintain their accuracy and keep them current with all the changes that Microsoft pushes out.I am glad to be a part of your educational journey and I hope my course(s) give you the confidence you need to use the products at your employment to your fullest potential.Thank you once again and I will see you on the other side.Robin Solonenko

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.