| |
| |
|
Courses - Microsoft
Access 303 |
| Description: |
Advanced Access |
| Running Time: |
77 minutes |
| Pre-Requisites: |
Access 302 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 303 continues our advanced Access
database development with VBA programming. We continue work on our sales
and order-entry system.
Topics Include:
1. Order List. Create an Order List Query
and Form so you can see a list of orders, double-click on one to open
the order, or a customer.
2. On Dbl Click Event and more with DoCmd.OpenForm -
additional parameters, etc.
3. Duplicate Address Data - adding ShipTo and BillTo
fields to the order, the AfterUpdate Event. Why you would want
duplicate data in your tables.
4. Address Fields on Order Form - Creating your own subroutines,
public v. private subs, calling subs on other forms, opening
forms in add-data mode.
5. Get the Sales Tax Rate, missing orders on our Order List due
to Join Types.
Access
303 - Lessons
|
Lesson |
Description |
Time |
| 00 |
Welcome |
2:52 |
| 01 |
Creating the OrderListQ,
OrderListF |
17:42 |
| 02 |
On Dbl Click Event,
DoCmd.OpenForm |
13:20 |
| 03 |
Adding BillTo, ShipTo
Addresses to Orders |
14:59 |
| 04 |
Address Fields, Creating
Your Own Subroutines, Public v. Private Subs |
18:54 |
| 05 |
Missing Records due to
Join Types, Get Sales Tax Rate |
5:39 |
| 06 |
Review |
3:53 |
| |
Total Running Time:
77 minutes |
|
| |
| |
|
Try a FREE Demo Lesson |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together - up to 50% off! |
|
| |
Student Interaction:
Microsoft Access 303
|
Richard on 1/1/2007:
Creating an Order List Form, On Dbl Click, ShipTo, BillTo, Creating Subroutines, Public v. Private, Get Sales Tax |
|
J Finley on 6/6/2008: Hi,
Firstly may i just say how helpful these tutorials are! Thanks to these unique learning opportunities, i have made some great progress with access.
I was just wondering if it was possible to automatically populate and update database field with data from the internet? For example, if i want to check the progress of a share price or an order?
Thanks for your help
Jay |
|
Richard Rost on 6/13/2008: Jay, YES it's possible - ANYTHING is possible with Access - but it will involve some programming and use of the Internet Explorer object. I do have databases myself that use this (in fact, the very program that pulls down 599CD orders from my web site into my Access database uses this technique) but it's not a quick or simple solution. I do plan on covering this in a future lesson - I'll get to it quicker if more people are intereste [more...] |
|
|
| |
| |
|
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!
|
|
|
|
|
|
| |
|
|
|
|
