|
Access 301 is the first of our "developer
level" advanced Access courses. We will build a complete
order-entry system (sales, products, inventory, accounts receivable,
etc.) We will also learn VBA programming (Visual Basic for Application).
This is the course you've been waiting for! Don't
miss it.
In this class, we will begin by constructing the
Order Table and Order Details Table. The Order Table holds the
information about the overall order, whereas the Details contains
information about the items (products) in the order (a many-to-one
relationship... remember that?)
We will create the Order Form (with a details
subform). We'll see how to create a query to calculate our line totals,
sales tax, and more fun stuff. We'll put those totals in our form
footer.
We'll get our introduction to VBA (that's Visual
Basic for Applications) which is where the real power behind
Microsoft Access is hidden.
Access
301 - Lessons
|
Lesson |
Description |
Time |
| 00 |
Welcome |
2:07 |
| 01 |
Order Tables (OrderT,
OrderDetailT) |
9:35 |
| 02 |
OrderQ, Sales Tax, Tax
Rate |
11:21 |
| 03 |
Order Form, VBA (Visual
Basic) Programming Intro |
16:57 |
| 04 |
Order Subform |
12:51 |
| 05 |
Totals, Open Button VBA
Code |
18:41 |
| 06 |
Review |
2:31 |
| |
Total Running Time:
74 minutes |
|
Student Interaction:
Microsoft Access 301
|
Richard on 1/1/2007:
Access 301 is the first of our "developer level" advanced Access courses. We will build a complete order-entry system (sales, products, inventory, accounts receivable, etc.) We will also learn VBA programming (Visual Basic for Application).
Begin Order Entry System, Calculating Sales Tax, Order Form, Beginner VBA (Visual Basic) Programming |
|
PAUL TIBI TENDO on 7/31/2008: how can change the currency from us dollars to other currencies |
|
PAUL TIBI TENDO on 8/2/2008: how do you have multi-currency values if you have international orders for different customers in different countries. |
|
Richard Rost on 8/23/2008: This is something that you have to do in WINDOWS, not Access. Go into your Control Panel and under Regional Settings you should see an option to change your currency type. Same with Date & Time options (European vs. American formats). |
|
Richard Rost on 8/23/2008: Paul, I haven't tackled that one... multi-currency values would be tricky, but you could do it with multiple fields, I suppose. |
|
|
|
 |
Need
Help? |
| |
|
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like. |
|
|
|
|
|
