|
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 |
|
|
 |
| |
| 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. |
|
|
|
|
|
