Microsoft Access 301
Advanced Access Development
Order-Entry System, Orders & Line Items,
Calculate Sales Tax, Form/Subform, Subform Totals, Beginner VBA, Lots
More. 74 Minutes.
- Create Order
- Line Item
- Sales Tax Rate
- Order Form /
- Beginner VBA
- Continuous Forms
- Subform Totals
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
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
Next we'll set a default Sales Rep and Tax Rate for each
...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.