| |
|
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/7/2008 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 |
| |
| |
Student Interaction:
Microsoft Access 306
|
Richard on 1/1/2007:
Employee Commission & Pay Rates, Nested IIF functions, DMAX, Me.Requery, InputBox, Passwords, Overtime Hours |
|
|
| |
| |
|
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!
|
|
|
|
|
|
| |
|
|
