Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< Previous: Access Expert 5

Next: Access Expert 7 >

Access Expert Level 6

Expert Microsoft Access Tutorial - 1 Hour, 18 Minutes
This Microsoft Access video tutorial picks up where Expert Level 5 left off. This class focuses on sending mass mail from your Access database. We'll learn how to print collection letters (with separate letters for those who are 30, 60, or 90 days late), generic letters to all active customers, letters to customers based on what category they're in, and more. Topics include:
  - Send Mass Mail from Access
  - Collection Letters
  - Automatic Date Ranges
  - New Report Properties
  - Force New Page
  - Multiple Letter Templates
  - Letters to All Active Customers
  - Allow Edits vs. Locked Fields
  - Send To Customers by Category

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first and last lessons of this course (free of charge), or scroll down for more information.


Access Expert Level 6
Description: Access Expert Level 6
Versions: This class was recorded with Microsoft Access 2013. The material is valid for Access 2007 up to 2021. Access has not changed that much over the years.
Pre-Requisites: Access Expert Level 5 strongly recommended
Running Time: 1 Hour, 18 Minutes
Cost: $22.99

This class picks up where Expert Level 5 left off. In fact, this class could be thought of as part two of Expert Level 5. We will be sending late / collection notices to our customers, so we'll need to put some orders in the database for them. This will require setting up an order table and a query to show which orders are late.


Once we have that in place, we can create a printable letter to send to all of those customers with past-due orders. We'll learn about some new detail section properties, how to force a new page between letters, and add the order information fields (due date, amount due, etc.) to the customer's letter.


It would be nice if we could have several different collection letters - not just the one. So, we will create a letter table to store multiple letter templates. We'll create a separate letter for those customers who have orders less than 30 days old, another for those between 30 and 60 days old, and a final letter for those over 60 days old.


It's a bit of a pain to have to manually enter in the dates when we generate each of our different collection letters, so we'll see how we can store date offsets (number of days) in the letter table, and have Access automatically change the begin date and end date for the letter date range when we generate each batch of letters, automatically.


Now we'll see how we can broaden the scope of our letter writing form. We can use it to send letter to all active customers, or to customers in a specific category. So we'll add the "IsActive" field checkbox to the customer list form (for easy selection). Then we'll make a separate letter report we can send to just those customers.


Finally, we'll create another letter report that we can send to all of the customers in a specific category. Remember the "Lead Source" combo box we added a few classes ago? We'll use that for our customer category list.


This is the sixth class in the Access Expert series. If you need to be able to print mass mailings from your Access database, then this is definitely the right class to take. Of course, if you have any questions about whether or not this class is for you, please contact me.


Complete Outline - Access Expert Level 6

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
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

06. Review (5:21)


Keywords: Send Mass Mail from Access, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, collection letters, date range, report properties, record source, force new page, after section, alternate background color, letter templates


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/19/2024 8:57:22 AM. PLT: 0s