Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Access Database Programmer's Bundle: SQL & VBA

Name: Access Database Programmer's Bundle: SQL & VBA
Rating: 4.5 (25 reviews)

Master SQL and VBA for Efficient Access Database Development

Highest Rated

Created byIsáBel .

Last updated 1/2026

English

What you'll learn

WRITE SQL Queries in Your Microsoft Access Databases
CREATE Tables and Insert Records Using SQL
LEARN About Functions
- - - Files & SQL Script Included!
NAVIGATE Comfortably in the Visual Basic Editor
LEARN the Essentials of Writing Access VBA Code
PROGRAM Command Buttons
CREATE User Interactive Dialog Boxes, like message boxes and input boxes
DEBUG Your VBA Code
- - - Databases & VBA Included!

Course content

28 sections • 218 lectures • 7h 46m total length

Welcome0:48
Downloading Resources0:22

The SELECT Syntax2:11
Learn the structure of the SELECT statement, used to retrieve data from your database.
SELECT Statements10:32
Multiple examples will walk you through the core of scripting SQL - the SELECT statement.
Aliasing Columns3:55
Learn to use aliases to temporarily rename a column heading
Section SQL - SELECT0:13
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - SELECT

The WHERE Syntax1:22
The WHERE clause is in SQL used to filter records
Understanding Filtering Operators LIKE, *, and [ ]4:46
In SQL, wildcard characters are used with the LIKE operator, and can be used to substitute any character(s) in a string.
Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL4:24
Learn additional ways to filter records in SQL
WHERE Part I8:07
Examples of how you can use WHERE to filter records in SQL
WHERE Part II7:27
More examples of how you can use WHERE to filter records in SQL
Section SQL - WHERE0:42
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - WHERE

Intro to Aggregate Functions1:48
In SQL, use aggregate functions to return one value, calculated from multiple values in a column
SUM7:03
Examples of the SQL SUM function
AVERAGE1:16
Examples of the SQL AVERAGE function
COUNT4:47
Examples of the SQL COUNT function
MIN and MAX3:41
Examples of the SQL MIN and MAX functions
Section SQL - Aggregate Functions0:42
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - Aggregate functions

Date0:45
Examples of the SQL DATE function
Now0:18
Example of the SQL NOW function
Day0:36
Example of the SQL DAY function
MonthName0:58
Example of the SQL MonthName function
DatePart3:39
Examples of the SQL DatePart function
DateAdd2:31
Examples of the SQL DateAdd function
DateDiff2:02
Examples of the SQL DateDiff function
DateValues1:42
Examples of the SQL DateValue function
Formatting Dates2:58
Learn how to format dates using SQL in your Microsoft Access databases
Section SQL - Date Functions0:20
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - Date Functions

Using CONCATENATE1:52
Learn how to bring fields together using SQL
LCase and UCase1:21
Use SQL to convert the value of a field to lowercase or uppercase
Left and Right1:44
Extract characters from the left or right side of a character string in SQL
Mid1:44
Extract characters from a character string in SQL
Len0:43
In SQL, find the length of a value in a string
Trim, LTrim, and RTrim1:13
Remove blank characters from the beginning and/or end of a character string in SQL
Replace3:54
Replace characters with other characters
Section SQL - String Functions0:17
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - String Functions

The UPDATE Syntax1:55
In SQL, use UPDATE to update existing records in a table
UPDATE9:41
Examples of how you can use UPDATE in SQL to update existing records in your Access databases
The DELETE Syntax2:22
In SQL, use DELETE to delete existing records in a table
DELETE5:03
Examples of how you can use DELETE in SQL to delete existing records in your Access databases
Section SQL - Updating and Deleting Records0:20
The SQL used in this section.
Exercise: Lesson Lab0:04
Exercises to reinforce the SQL you learned in this section of the course - Updating and Deleting Records

Primary Key and Foreign Key3:42
The PRIMARY KEY uniquely identifies each record in a table. A FOREIGN KEY in one table is the PRIMARY KEY in another table.
Common Types of Joins5:12
Learn about INNER JOINS and OUTER JOINS
The JOIN Syntax5:08
Learn the SQL syntax for creating Joins
JOIN12:47
Examples of how to Join tables in your Access database using SQL
More Examples of Three Table Joins0:02
Examples of joining 3 or more tables in the Northwind database.
Aliasing Tables in Joins3:28
Learn to use aliases to temporarily rename tables
Subqueries vs. Joins0:05
Now that you know how to create a Subquery, and how to create a Join, which one should you use?
Section SQL - Joins0:59
The SQL used in this section.
Exercise: Lesson Lab0:03
Exercises to reinforce the SQL you learned in this section of the course - Joins

Requirements

Access 2016 - 365
To get the most out of this course, you should have working knowledge of Microsoft Access databases
No programming experience needed, just a willingness to learn!

Description

Welcome to the Access Database Programmer's Bundle: SQL & VBA, a bundled course combining Microsoft Access SQL: SQL for Non-Programmers and Access VBA: The Beginner's Blueprint to Programming Access.

This course is designed to elevate your database skills and empower you to create dynamic, efficient, and user-friendly databases.

Whether you’re a beginner looking to learn the fundamentals or an experienced developer seeking to enhance your expertise, this comprehensive bundle has everything you need.

Who This Course Is For:

Aspiring database developers wanting to build a strong foundation in Access.
Business professionals looking to automate repetitive tasks and improve data management.
Anyone interested in enhancing their resume with in-demand SQL and VBA skills.

Interactive Learning: Enjoy a mix of video lectures, hands-on exercises, and quizzes that keep you engaged and reinforce your understanding.

Lifetime Access: Revisit the course materials at any time, allowing you to learn at your own pace and refresh your skills whenever needed.

Enroll Today!

Transform your approach to database programming and unlock new career opportunities with the Access Database Programmer's Bundle: SQL & VBA. Don’t miss this chance to master essential skills that will set you apart in the job market.

Who this course is for:

The Beginning Access VBA Programmer
Those New to Access SQL
Anyone who is responsible for working with Access databases
Programmers of other languages that would like a good tutorial

Access Database Programmer's Bundle: SQL & VBA

What you'll learn

Explore related topics

Course content

Welcome to this 2 Course Programmer's Bundle2 lectures • 1min

ACCESS SQL: SQL SELECT5 lectures • 17min

ACCESS SQL: SQL WHERE7 lectures • 27min

ACCESS SQL: SQL ORDER BY4 lectures • 9min

ACCESS SQL: Introduction to Aggregate Functions in SQL7 lectures • 19min

SQL: Date Functions11 lectures • 16min

ACCESS SQL: String Functions9 lectures • 13min

ACCESS SQL: Updating and Deleting Records Using SQL6 lectures • 19min

ACCESS SQL: Subqueries4 lectures • 8min

ACCESS SQL: Joining Tables Using SQL9 lectures • 31min

Requirements

Description

Who this course is for: