Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Expert 2

Next: Access Expert 4 >

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 2010 Expert Level 3
Description: Access 2010 Expert Level 3
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Expert Level 2
Running Time: 1 Hour, 26 Minutes
Cost: $19.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 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)

 


 
Keywords: SQL, Subforms, Form Footer Totals, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 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
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP