Access O365 Expert: The Ultimate Access 365 Database Course

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

Requirements

Must have taken my Access O365 Intermediate course or equivelant database experience.

Logical and problem solving skills.

You must have MS Access installed on your system - subscription to O365 will be necessary.

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 InstructorRobin Solonenko

Overview

Section 1: Getting Started

Lecture 1 Course & Instructor Introduction

Lecture 2 Support Notes for Students

Lecture 3 Coruse Resource Files & PDF Manual

Lecture 4 Contacting the Instructor

Lecture 5 Let's Set Some Expectations

Lecture 6 PDF Manual & Video Correlation

Section 2: Access Event Model

Lecture 7 ASCII Code & CurrentUser

Lecture 8 Date & Time Stamp

Lecture 9 On No Data Event

Lecture 10 Creating Running & Page Totals

Lecture 11 Auto Populate Combo Boxes

Lecture 12 Secetion 2 / Lesson 1 Exercise

Section 3: Using Data Access Macros

Lecture 13 Event Driven Data Access Macros

Lecture 14 Data Access Macros to Update Inventory

Lecture 15 Section 3 / Lesson 2 Exercise

Section 4: Creating Access Macros

Lecture 16 Simple Message Macro

Lecture 17 Multi-Action Macro

Lecture 18 Macros based on a Condition

Lecture 19 Section 4 / Lesson 3 Exercise

Section 5: Bullet Proofing Access Applications

Lecture 20 Creating a Login Dialog Box

Lecture 21 Password Protecting Your Database

Lecture 22 Removing Access to Ribbons & Menus

Lecture 23 Building Multi-User Applications

Lecture 24 Hack Proof Read-Only Objects

Lecture 25 .accdb vs .accde

Lecture 26 Section 5 / Lesson 4 Exercise

Section 6: Access Database Nuggets

Lecture 27 Perceived Speed & the Hourglass

Lecture 28 Loading & Hiding Forms

Lecture 29 Compact & Repair

Lecture 30 Section 6 / Lesson 5 Exercise

Section 7: Next Steps

Lecture 31 Instructor Thankyou

Lecture 32 Access Expert Project

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.