Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
I'm Back! New Access Course Finished
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   6 years ago

Hey guys. Sorry I've been gone so long. Had to go out of town for a bit, then I got sick and that took a few weeks to clear up... but I'm back in the saddle now.

I just finished Access Expert Level 29. The videos are online in the Theater, and you can order it now if you want. This class covers aggregate (Sum, Avg, etc.) and domain lookup functions (Dlookup, Dmax, Dcount, etc.) in detail. I'll post the full outline with screen shots later.

If you're a Learning Connection member or are on the Waiting List for Access, I'll try to process the auto orders later tonight or tomorrow. Thank you.

Now that I'm better, I plan to get a lot more recording done over the next couple of weeks. I started recording a Windows 8.1 class (redo Level 1, new Level 2) and I want to finish it since I've invested so much time into it already - even though Windows 10 will be coming out next month. So look for that soon.

Lots of people have asked about several different Access seminars, so I'll be picking one of those very soon as well.

The next Access class (X30) will cover financial functions, a mortgage calculator, and lots more. Cool stuff coming up.


Outline for Access Expert 29

00. Intro (6:23)

01. Aggregate Functions (12:56)
Sum, Avg, Count
Max, Min, First, Last
Will cover StDev Later
Will cover Variance Later
Use in a Form Footer
Use in an Aggregate Query
Use Aggregate as Query Criteria

02. Domain Aggregate Functions (17:53)
DLookup, DSum, DCount, DAvg
DMax, DMin, DFirst, DLast
Domains & Criteria
Number, String, Date Criteria
No Criteria
Double Double Quotes for Strings
Largest Autonumber in Table
How Many Records in Table
Criteria on the Current Form
Criteria on Another Form
Concatenation of Criteria
Multiple Criteria
Parentheses in Multiple Criteria

03. Domain Aggregate Examples (18:14)
DLookup Sales Rep Phone Number
DSum Orders From Last 30 Days
System Default Values Table
DCount Orders in Last 30 Days
DMax Show Last Order Placed
DAvg to Show Average Sales
Calculate Average Daily Sales
Forecast Future Sales

04. Create Your Own Counter (26:39)
Creating Editable Counters
Can't put DMAX or MAX in Table Default
Expression Builder List of Functions
Try Using Form Default Value Field
Order Of Evaluation
Before Insert Event
Can't use Max in Macro
Use DMax to Find Largest Current Value
Increment Counter Value
Test Referential Integrity
Cascade Updates for ProductCategoryID
Use NZ for initial seeding
Show DMax VBA Code

05. Running Balances (24:48)
Set up Bank Account Table
Check Register
Deposits are Positive Amounts
Checks are Negative Amounts
Running Sum Property in Report
Running Sum over Group: Month
No Running Sum in Forms
Use DSUM for Running Balance
DSUM Based on the ID
DSUM Based on the Transaction Date

06. Excel VLOOKUP Replacement (14:19)
Student Letter Grade Example
Assign "A" for Grade 90, etc.
DMAX and DLOOKUP Combination
Look up Customer Credit Bracket
Gold, Silver, Bronze, etc.

07. Review (6:36)

I m Back New Access Course Finished Upload Images   Link 
Cheryl H 
6 years ago
My developer son tells me that Microsoft plans to phase out Access and discontinue supporting it.  What do you know about that possibility?  Being sick sure puts a kink in future plans.  Glad to hear your better. Read More...
Add a Reply
Advanced Access 2010 Upload Images   Link 
Jeff S 
6 years ago
Hi Richard,

I enjoyed your series very much and you are by far the best instructor I have found across the web!

Do you have any ETA on Access Advanced/Developer for 2010?

I'm sure a lot has changed since 2003 and I don't want to have to relearn or re-watch to learn all the new tips and tricks.. I'd rather wait! Read More...
Add a Reply
I m Back New Access Course Finished Upload Images   Link 
Robert S 
6 years ago
Good to have you back Richard, I am itching to proceed further

Add a Reply
I m Back New Access Course Finished Upload Images   Link 
Deon R 
6 years ago
Welcome back Richard :)and I'm so looking forward to more courses and seminars - 'all things Access' :)

Alex's done a Stirling job during this time. Long may he continue to post and assist.
Add a Reply
I m Back New Access Course Finished Upload Images   Link 
Robert Balagot 
6 years ago
Welcome back Rick!  Hope you have more tutorial that you can share.  I went through all the Access Level and it's very impressive.  It was the best ever.  Thanks.
Add a Reply
I m Back New Access Course Finished Upload Images   Link 
6 years ago
Good to have you back in the saddle Richard and that all things are back to normal, what ever normal is anyway !
Add a Reply
I m Back New Access Course Finished Upload Images   Link 
John Bosko 
6 years ago
Good to see you back.  I hope it wasn't too serious. Me, I broke a bone in my right foot.  Dropped an I beam on it.  I enjoy your courses tremendously. The data base that I created is for inventory of my shop items. I need to download my classes. Have a great day. Read More...
Add a Reply
I m Back New Access Course Finished Upload Images   Link 
Chris Bezant 
6 years ago
Hello Rick
We thought you had abandoned us!!
Glad you're better, my friend.
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

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

10/10/2021Copy Text from Field
10/10/2021Access for Free
10/8/2021Label Resize
10/2/2021Criticisms of Access
10/1/2021Access Developer 32
9/28/2021Track Log On

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn