Udemy – Access VBA (Basic to Super Advance – 40 Hours) 2024-3

What you will learn in the Access VBA (Basic to Super Advance – 40 Hours) course

• Scope variables, forms, dashboards, database security, do cmd, events, error handling.
• Writing subloops, basics, error explanations.
• Arrays, collection loops, Do while, for next loops, IF statements, SQL, forms, Early binding, late binding.
• VBA Editor: We learn how to enter the VBA editor and understand its structure.
• Scope of variables: How long a variable exists, global, local, and module-level variables, and the use of Option Explicit.
• Loops: For Next with Do While – How to write and use them on recordsets.
• Collection loops: Iterate over tables, queries, forms, modules, reports, and objects – pretty amazing.
• Arrays: option base1, one-dimensional, multi-dimensional arrays with practical exercises.
• Functions (UDF and built-in):
• Error handling: On error resume next, Go to err – how to use them smartly.
• Connect to Excel: Work with Excel and control it in any way you want.
• Late binding and early binding with PowerPoint and Word programs:
• SQL commands: Select, update, Delete, Create, Drop, INSERT INTO – Use all SQL commands in VBA.
• DoCmd function:
• IF function: simple IF, nested IFs, with loops and objects.
• File and Folder: How to create folders, files, how to work with the script library – very fun.
• File Dialogs: Why we need them and how to use them with the script library to select data from any folder.

This course is suitable for people who:

• Students who want to pursue a career in data analysis and want to become an Access programmer. Knowing Access VBA means you can fully master Access and integrate it well with Excel.

Installation Guide

After Extract, view with your favorite player.

Subtitles: None

Quality: 720p