Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 
Courses - Microsoft Access 204
Description: Intermediate Microsoft Access 4
Running Time: 65 minutes
Pre-Requisites: Access 203 very strongly recommended
Previous Lesson: Access 203
Next Lesson: Access 205
Main Topics: Letter Writer, Macro Basics, On Double Click Event, Refresh Macro, Report Formatting
Versions: This course is valid for Access 2000 through 2003. If you are using Access 2007 or 2010, you will still benefit from this course. You will find that the concepts are the same, but there are cosmetic differences between the versions.

    

Order before 11/24/2019 to get a FREE upgrade to our Access 2010 version!
Click here for details

 
Microsoft Access 204
Intermediate Access 4

Designing a Letter Writer, Access Macros, Events, OnDblClick Event, Refresh Macro, Much More. 65 Minutes.
 

AC204 Major Topics

  • Letter Writer
  • Macro Basics
  • On Double Click Event
  • Refresh Macro
  • Report Formatting

In this class we will begin designing our Letter Writer system. With our letter writer, we'll be able to actually type letters and other correspondence into our contact management system and print them out in a letter or memo format to mail or fax to our customers.

 

We'll begin by developing a query that only shows the current contact record. We'll use this query to feed our report that lets us print out the letter. We'll use the technique we learned in a previous class to get the Contact ID value from the open contact form.

 

Now that we have the query built, we can build the Contact Letter Report. We'll format this report to look like a normal letter, with the customer's name and address and the body of the letter ready to mail.

 

Next we'll place a Print As Letter button on our form so that we can print the letter right up.

 

We'll learn about what it means when records are Dirty - or in the process of being edited, and how this hurts our database... we can't directly print a letter now until we manually save the data to the table. We'll need something more powerful.

 

In lesson three, we'll begin to learn about Macros. We'll make a couple of real simple macros just to teach you how they work - and how we can make them repeat automated tasks. We'll make a simple macro just to beep at you.

 

Then we'll make a macro that's a little more complicated. It will open a form, beep, open a table, and then tell you "I'm done now, Master!"

 

Next, we'll make a macro that will allow us to open up the current customer record from the contact form. We will assign this macro to the On Dbl Click event (on double-click) in our customer combo box. This means the user just has to double-click on the combo box to open up that customer. Real powerful stuff!

 

Now that we've learned about macros, we can actually make a macro to refresh the current contact record before printing it - assuring us that the data is saved in the table before printing. We'll learn how to make a command button that runs a macro.

 

Once we're done with the macros, we'll actually get into making our letter report look good. We'll start by making some new fields to concatenate our name fields and address fields together.

 

We'll learn how to automatically adjust the vertical spacing of fields on our forms and reports.

 

We'll talk about the margins of the page, and making sure you set the report at it's optimal width.

 

We'll put the company logo and our return address in the page header...

 

This class begins to take our contact management system and use it for correspondence as well. We'll do more with this in coming classes - including a mass-mailing form and letter as well. We also begin to learn about Macros, which are the stepping stone to Visual Basic programming. Don't miss this course!

 

Access 204 Outline
 
0. Introduction 

1. Contact Letter Query
Build a query that shows only the current contact
Getting the ContactID from the form into our query

2. Contact Letter Report
Designing our Contact Letter Report
Placing the Print As Letter button
Dirty records - data needs to be saved

3. Macro Basics
Constructing basic macros
Beep macro action
OpenForm macro action
OpenTable macro action
MsgBox macro action
On Dbl Click event
OpenForm WHERE condition

4. Refresh Macro
RunCommand, Refresh macro action
OpenReport macro action
Creating a new button using the macro

5. Formatting the Letter
Creating new name and address fields
String concatenation in a new text box
Formatting as a long date
Format > Vertical Spacing > Increase
Report width, page width, margins
Placing a logo in the page header
Making a multi-line label

 


Try a FREE Demo Lesson

 
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP