|
|
|
Access
Expert
Level 3
Expert Microsoft
Access Tutorial - 1 Hour, 26 Minutes |
|
|
|
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 |
Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first
and last lessons of
this course (free of charge), or scroll down for more information.
|
Access Expert Level 3 |
Description: |
Access
Expert Level 3 |
Versions: |
This class was recorded with Microsoft
Access 2010. The material is valid for Access 2007 up to 2021. |
Pre-Requisites: |
Access
Expert Level 2 |
Running Time: |
1 Hour,
26 Minutes |
Cost: |
$21.99 |
|
|
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
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) |
|
|
Keywords:
SQL, Subforms, Form Footer Totals, microsoft access tutorial, microsoft access tutorial, microsoft access training, select from, order by, where, combo, custom format, master, child, parent, sub form, order by desc, link master fields, link child fields, embedded macro, aggregate functions, sum, avg, max, min, count |
|
|
|