| |
|
Courses - Microsoft
Access 302 |
| Description: |
Advanced Access |
| Running Time: |
67 minutes |
| Pre-Requisites: |
Access 301 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 8/30/2008 to
get a FREE upgrade to our 2007 version when released!
|
|
|
|
|
| |
|
Access 302 continues our advanced Access
database development with VBA programming. We continue work on our sales
and order-entry system.
We will construct a Product Table and Form, build
a combo box on our order form so that we can choose a product from the
list and then add it to our order with some VBA code. We'll also learn
how to use the DLOOKUP function to pull values out of a table.
Topics Include:
1. ProductT. Creating a product table and form to
store product details.
2. Product Combo. Building a combo box on our order subform to
list all products.
3. Getting the data from our product combo box into our order form
when a product is selected.
4. DLOOKUP. Getting information from a table or query. Lots of
other VB concepts too: comments, dim, IF / Then, on error, etc.
Access
302 - Lessons
|
Lesson |
Description |
Time |
| 00 |
Welcome |
3:31 |
| 01 |
ProductT, ProductF |
12:51 |
| 02 |
Product Combo |
13:56 |
| 03 |
Data From Combo to Order
Form |
9:56 |
| 04 |
DLOOKUP, VB Concepts |
22:55 |
| 05 |
Review |
3:38 |
| |
Total Running Time:
67 minutes |
|
| |
| |
|
Try a FREE Demo Lesson |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together - up to 50% off! |
|
| |
Student Interaction:
Microsoft Access 302
|
Richard on 1/1/2007:
Continue Order Entry, Build Product Table & Form, Combo Box to Select Products, DLOOKUP, More VBA Functions |
|
|
| |
| |
|
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!
|
|
|
|
|
|
| |
|
|
