| |
| |
|
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 7/8/2009 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 [more...] |
|
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 |
|
|
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
Need
Help? |
| |
|
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
| |
|
|
|
|
