|
||||||||||||||||||||||
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. Our goal is to create a full-featured order-entry system with printable invoices.
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'll enter some sample order data so you can see how the relationship between OrderT and OrderDetailT is going to work.
We'll see how to create a query to calculate our line totals, sales tax rate, actual sales tax due, and more calculations.
Next we will create an Order Form. We'll start out by adding Sales Rep and Tech Rep combo boxes to our form - but these are both basically Employees, so we'll bind two different fields to our Employee table.
We'll get our introduction to VBA (that's Visual Basic for Applications) which is where the real power behind Microsoft Access is hidden.
Next we will create the Order Subform to show the line item details for each order:
You will learn how to put Totals in your subform's footer.
Next we'll set a default Sales Rep and Tax Rate for each Customer...
...and have that information automatically carry over to any new orders that are created for that customer:
This course is just the first in our series of creating an order entry system. By the time we're finished, you'll have a fully-functional database that you can use to run any business.
|
||||||||||||||||||||||
| Access 301 Outline |
||||||||||||||||||||||
1. Create Order Tables |
||||||||||||||||||||||
|
|
||||||||||||||||||||||
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
||||||||||||||||||||||
