I just finished Access Expert 6. You can order it online and watch it in the Theater or download it now.
The FULL outline will be posted shortly. This class continues with the Letter Writer from Expert 5 and adds MASS MAILING capability so you can send letters to more than just one customer at a time.
Here are the details:
00. Intro (7:10)
01. Collection Letters 1 (11:32)
Create OrderT Table
Create OrderCollectionLetterQ
02. Collection Letters 2 (12:17)
Copy current contact letter
OrderCollectionLetterR
Change record source
Detail section properties
Force New Page After Section
Turn off Alternate Background Color
Add order info fields to letter
03. Collection Letters 3 (13:29)
LetterT Table
LetterF Form
Enter multiple letters
Text on report set by form
BeginDate and EndDate for query
Can't edit with Date() in Control Source
04. Collection Letters 4 (8:55)
Put LetterF on Main Menu
Change date range based on letter
BeginDaysAgo, EndDaysAgo in LetterT
Set BeginDate and EndDate Automatically
05. Generic Letters (19:19)
Send letters by various criteria
Letter to Active customers
AllowEdits vs. Locked Field
CustomerActiveQ Query
LetterActiveR Report
Letters by Lead Source
LeadSourceCombo
LettersByLeadSourceQ
06. Review (5:21)
13 years ago
