| |
| |
|
Courses - Microsoft
Access 304 |
| Description: |
Advanced Access |
| Running Time: |
82 minutes |
| Pre-Requisites: |
Access 303 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 304 continues our advanced Access
database development with VBA programming. We continue work on our sales
and order-entry system. This lesson will focus on creating a printable
report.
Topics Include:
1. Distinguishing between a quote and an invoice.
Changing form properties with VB code (captions, colors, etc.)
2. OnCurrent Event, running code when you move from record to
record.
3. Creating a printable invoice - InvoiceQ, InvoiceR
4. Printable invoice part 2 - tidy up the report, force new page
5. Printable invoice part 3 - report setup, margins, VB section
build events, image sizing
6. Printable invoice part 4 - is paid label, can grow/shrink,
page footer, VB docmd.OpenReport
Access
304 - Lessons
|
Lesson |
Description |
Time |
| 00 |
Welcome |
2:08 |
| 01 |
Quote or Invoice?
Changing form properties on the fly. |
12:28 |
| 02 |
OnCurrent event, running
code moving from record to record |
9:30 |
| 03 |
Invoice 1. Invoice
Query, Report |
14:46 |
| 04 |
Invoice 2. Force New
Page, tidy up report |
13:30 |
| 05 |
Invoice 3. Report Setup,
margins, VB section build events, image sizing |
12:01 |
| 06 |
Invoice 4. IsPaid Label,
can grow/shrink, page footer, docmd.openreport |
14:43 |
| 07 |
Review |
3:24 |
| |
Total Running Time:
82 minutes |
|
| |
| |
|
Try a FREE Demo Lesson |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together - up to 50% off! |
|
| |
Student Interaction:
Microsoft Access 304
|
Richard on 1/1/2007:
Creating a printable quote / invoice. Changing properties with VB code, OnCurrent, CanGrow/Shrink, OpenReport |
|
leroy diaz on 3/11/2008: I was wondering you made a invoice for all the orders but what if you wanted to show all paid orders in an invoice and unpaid with the grand total in the footer how would you do that? i think you should put this in a lesson. |
|
Richard Rost on 3/13/2008: That's coming up in the next class. In Access 305 we make the Accounts Receivable report. Now if you want to take that data and stick it in the footer of the customer's invoice, you could DLOOKUP (Access 302) the total unpaid orders and stick it in there, or use a subreport (something I haven't shown you yet because I don't like to use them - they're like subforms only very messy). |
|
Walter Pohle on 5/26/2008: On invoice report is there
any way to Shrink and Grow
city,state & zip so that they are closer together
time stamp 5:27 on 304 vide
6 |
|
Richard Rost on 6/13/2008: Walter, I believe I cover this in a subsequent lesson. You just need to combine them together into one field using simple STRING CONCATENATION. I do it in a query, but you can do it right in the report:
CityStateZIP: City & ", " & State & " " & ZIP |
|
|
| |
| |
|
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!
|
|
|
|
|
|
| |
|
|
|
|
