Microsoft Access Expert 11

News User Comments History Notify Me

8/8/2013 9:40:45 PM
Microsoft Access Expert 11
By Richard Rost

Microsoft Access Expert Level 11 is 1 hour, 48 minutes long. In this tutorial we will learn how to use Aggregate Queries to summarize data. Topics include:

- Aggregate Queries
- Sum, Avg, Count, Max, Min
- Complex Query Criteria
- Sales Totals by Month
- Find Lowest Product Cost
- Last Customer Contact Report
- Employee Work Log, Timesheet
- Calculate Hours Worked
- DSUM Function

Click here for more information on Access Expert Level 11, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 10.

Permanent Link
Course Link: Microsoft Access Expert 11
Keywords: access expert 11 aggregate queries summary grouping dsum
Page Tag: whatsnew

Post Reply

Joined fields vs DLOOKUP Comment from Brian Farley @ 9/22/2014

Is there any benefit or penalty to use the database joins we have setup.  For instance.  The second query would have:

LowestProductPrice1Q,
VendorXProductT,
VendorT,
ProductT

All left joined by the relative IDs and MinOfUnitCost-> VendorXProductT.UnitCost.  Then you can just drop the fields you need in the query without the DLOOKUP.

Maybe that would be faster then DLOOKUP with tons of records?  Or maybe I'm jumping ahead..

Keep up the great work :)

Reply from Rick Rost:

Brian, that course is over a year old, so I don't remember EXACTLY what the lesson covered, but it is generally faster to work with linked tables than to use DLOOKUP in a query for a large set of data. I'm sure if that's the way I did it in class, however, there must have been a good reason for it. :)

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 4+4:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard