| |
| |
|
Courses - Microsoft
Access 306 |
| Description: |
Advanced Access |
| Running Time: |
83 minutes |
| Pre-Requisites: |
Access 305 very strongly recommended |
| Versions: |
|
We use Access XP in this course,
but the lessons are valid for all versions of Access from 95 to 2003.
There are cosmetic changes in Access 2007. Order before 3/15/2010 to
get a FREE upgrade to our 2007 version when released!
|
|
|
|
|
| |
|
Access 306 continues our advanced Access
database development with VBA programming.
This lesson focuses calculating employee
commission rates and pay rates. Sounds easy? Well we will learn about
all kinds of new concepts like DMax, Me.Requery,
InputBox, nested IIF functions, and much more.
The full outline will be posted here soon. Here's
the outline:
|
Lesson |
Description |
Time |
| 00 |
Welcome |
3:43 |
| 01 |
Employee Commission
Rates based on single rate, based on different rate per employee,
based on order amount. Nested IIF Functions. |
19:42 |
| 02 |
CommissionLookupT,
paying employees commission based on order amount and separate rates
for each employee. DMax. Using DMax with DLookup to pull a
commission rate based on employee and largest order amount. (Note
DMin is same as DMax but looks up the smallest value) |
13:18 |
| 03 |
Commission Form.
Me.Requery on opening a form (getting no records because
underlying query is based on a checkbox on the form). |
8:31 |
| 04 |
Commission Report to
group commission amounts by employee. Update query to mark all
commissions paid and track date paid. Using InputBox to ask
for a password when a button is clicked. |
18:39 |
| 05 |
Employee PayRateT.
Calculating employee pay rates based on employee and dates worked.
Another DMax, DLookup example. Calculating regular and overtime
hours and total pay rates. |
15:23 |
| 07 |
Review |
3:05 |
| |
Total Running Time:
83 minutes |
|
| |
| |
|
Try a FREE Demo Lesson |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now. |
|
| |
Student Interaction:
Microsoft Access 306
|
Richard on 1/1/2007:
Employee Commission & Pay Rates, Nested IIF functions, DMAX, Me.Requery, InputBox, Passwords, Overtime Hours |
|
BRYAN binkerd on 5/14/2009: I think the showings of the mistakes and how to correct them are great, however, I might recommend that if you added that portion to a troubleshooting chapter, it would allow the user to learn the "perfect world" scenario and to recap the user's knowledge and awareness of the troubleshooting techniques.
PLEASE do not take it this the wrong way. If it is a pain, then leave it as is. I find the mistakes very useful and have caught some of the mistakes on my own. (Standing up and bowing for the loud applause) sad thing is it was only 2 out of the entire series. Keep up the great work
(Chanting "Go Rick, Go Rick, it's your birthday"
Thanks
Bryan |
|
BRYAN binkerd on 5/14/2009: Help for the dummy,
I used names rather than IDs to store values. Is there a parameter value such as LIKE "*dummy*" for text rather than ID references.
Bryan |
|
Richard Rost on 5/19/2009: Bryan, yes, you can use the LIKE keyword in a query just as you have it there. I cover it way back in Access 102: http://599cd.com/site/courselist/access/access102 |
|
Ruth Spohr on 11/21/2009: I agree with Bryan about a trouble shooting chapter so the lessons are clearer. It also becomes difficult to refer back to the handbooks when you must wade through incorrect methods to find the correct information. |
|
Richard Rost on 11/25/2009: I actually get a lot of compliments on the fact that I do cover several wrong methods showing how to arrive at the right ones. I like to show people the common mistakes that they're likely to make because I know I've spent many hours being frustrated by just such mistakes. Don't you feel this is valuable? |
|
|
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
| |
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like.
Click here
for assistance. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
| |
|
|
|
|
