Microsoft Access Expert Level 3 - Introduction

PLEASE NOTE: This video says "Access 2010" but it's perfectly valid for every version of Access after 2007. Microsoft Access hasn't changed that much, even up to 2019. So please enjoy!

This is the introduction video only. The full course is 1 hour and 26 minutes long and can be found on my web site at http://599CD.com/XTM3C4

This Microsoft Access video tutorial picks up where Expert Level 2 left off. This class teaches you the basics of SQL (the language behind all of the queries in your database), form footer totals, subforms, and lots more. You will learn:

- SQL Basics
- Future Callbacks for Customers
- Default Value to Tomorrow at 9 AM
- Creating Subforms
- Link Master & Child Fields
- Using SQL in Form Record Source
- Form Footer Totals
- Sum, Avg, Max, Min, Count
- Modifying Embedded Macros

This class picks up where Expert Level 2 left off. We'll begin by learning about SQL (Structured Query Language) which is the code behind all of the queries, forms, and combo boxes in your database. You'll learn about the basic components of an SQL statement. You don't have to learn how to write your own SQL at this point, but I want to teach you enough so you can modify the SQL that Access provides for you. It adds a lot of power and flexibility to your database.

In the last two classes, we built a Contacts form to track the previous contact history with our customers. In today's class we'll modify it a bit so we can track callbacks for those customers. Need to call Joe Smith tomorrow at 9am? We'll put that into the callback form and tomorrow you can quickly generate a list of everyone you need to call. It's a way to reuse a single table with similar data for multiple purposes.

Next we'll learn about something that's VERY powerful in Access: the subform. This is a way for you to show related records inside another form. For example, wouldn't it be nice if you could see the last couple of contacts for a customer right on the customer form without having to open another form up? That's what a subform does for you.

Finally, we'll learn how to calculate totals in a form footer. We'll create a products form, a product category form, embed products as a subform, and then create some footer totals to show inventory levels.

This is the third class in the Access Expert series. If you want to take your database skills to the next level, this is the class for you. Understanding subforms and form footer totals are important tools to the success of your projects. Of course, if you have any questions about whether or not this class is for you, please contact me.

Complete Outline - Access 2010 Expert Level 3

00. Introduction (7:38)

01. SQL Primer (11:39)
Combo Box Row Source
SELECT FROM
ORDER BY
WHERE
Change Combo Sort
Change Combo Field Order
Record Source for Form

02. Callbacks (19:26)
Modify ContactT
Default Value for Dates
Today's Date
Tomorrow's Date
Tomorrow at Noon
Tomorrow at 9 AM
Modify Contact Form
Custom Date Format
ddd mm/dd/yyyy hh:nn am/pm
Callback Query
Sort by Date
Callback Form
Add button to Main Menu
Add customer name to list
Button to open Customer Form

03. Contact Subform (16:27)
What is a Subform
Master and Sub Forms
Parent and Child Forms
Copy and modify Contact Subform
SQL Statement as Record Source
Sort by Date Reverse Order
SELECT ORDER BY DESC
Subform Object Control
Click and Drag to create Subform
Subform Object Properties
Subform Form Properties
Access Autoform with Subform
Link Master Fields
Link Child Fields

04. Form Footer Totals (23:59)
Product Category Table
Product Table
ProductSubformF
ProductCategoryF
Aggregate Functions
SUM AVG MAX MIN COUNT
Modify Embedded Macro
Change Form Name in Macro
Moving to Access 2013

05. Review (6:41)

Learn more about Microsoft Access here:

https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://www.microsoft.com/en-us/microsoft-365/blog/access/