Access 365 Expert: The Ultimate Access 365 Database Course

Focused View

Robin Solonenko

3:37:27

97 View

1. Getting Started

1. Course & Instructor Introduction.mp4

01:00

2. Support Notes for Students.html

3.1 Access O365 Expert Data Files.zip

3. Coruse Resource Files & PDF Manual.html

4. Contacting the Instructor.mp4

00:52

5. Lets Set Some Expectations.mp4

02:25

6. PDF Manual & Video Correlation.html

2. Access Event Model

1. ASCII Code & CurrentUser.mp4

11:29

2. Date & Time Stamp.mp4

07:31

3. On No Data Event.mp4

03:57

4. Creating Running & Page Totals.mp4

13:57

5. Auto Populate Combo Boxes.mp4

16:08

6. Secetion 2 Lesson 1 Exercise.mp4

00:44

3. Using Data Access Macros

1. Event Driven Data Access Macros.mp4

10:50

2. Data Access Macros to Update Inventory.mp4

22:08

3. Section 3 Lesson 2 Exercise.mp4

00:39

4. Creating Access Macros

1. Simple Message Macro.mp4

06:18

2. Multi-Action Macro.mp4

12:57

3. Macros based on a Condition.mp4

21:53

4. Section 4 Lesson 3 Exercise.mp4

00:37

5. Bullet Proofing Access Applications

1. Creating a Login Dialog Box.mp4

15:37

2. Password Protecting Your Database.mp4

03:39

3. Removing Access to Ribbons & Menus.mp4

04:26

4. Building Multi-User Applications.mp4

11:06

5. Hack Proof Read-Only Objects.mp4

14:39

6. .accdb vs .accde.mp4

06:10

7. Section 5 Lesson 4 Exercise.mp4

00:47

6. Access Database Nuggets

1. Perceived Speed & the Hourglass.mp4

12:16

2. Loading & Hiding Forms.mp4

09:22

3. Compact & Repair.mp4

03:36

4. Section 6 Lesson 5 Exercise.mp4

00:32

7. Next Steps

1. Instructor Thankyou.mp4

00:52

2. Access Expert Project.mp4

01:00

Description

Final touches on your database: auto populate, building macros, executable files and deployment options.

What You'll Learn?

Students will learn and use the Access Event Model and delve more into Access VBA.
Students will learn when and how to use Data Access Macros and assign them to the table level.
Students will learn more about Access Macros to maintain inventory tables.
Students will use Access Macros to create simple messages to calling multi-action queries.
Students will learn to password protect database and vba code.
Students will learn how to build and deploy multi-user applications

Who is this for?

Anyone who wants to take their MS Access knowledge to the highest level.

Anyone who wants to integrate VBA into their forms, reports and queries.

Anyone who wans to learn how to deploy their final Access Database project.

More details

Description
The ultimate Access 365 Expert course is now available for all those students who have taken my Access 365 Foundations and Access 365 Intermediate courses or for those students with Access experience and just want to learn any cool nuggets of information that other courses have left out.
This course will put the final touches on your learning journey with Access Databases to learn how to auto populate combo boxes, creating data access macros as well as regular macros, embedding macros, hack proofing read only objects and deploying multi-user applications.
Students will learn to connect auto populate forms, create Data Access Macros as well as VBA Macros. Then they will finalize their database project by making objects read only, removing access to the tab and ribbon system as well as assigning passwords to their data.
This course will take you to the finish line in your own Access Database projects where you just need to learn all the features to lock your content down and get it ready for use within your organization. Access Expert will take you over that finish line and give you the confidence you need to deploy your final project.
This course is intended for those who want to learn the advanced options that can be applied to any Access database and deploy their hard work for all their fellow employees to use.

Your Instructor
Robin Solonenko

Who this course is for:
Anyone who wants to take their MS Access knowledge to the highest level.
Anyone who wants to integrate VBA into their forms, reports and queries.
Anyone who wans to learn how to deploy their final Access Database project.

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.