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  
 
 
 

< Previous: Access Expert 4

Next: Access Expert 6 >

Access Expert Level 5

Expert Microsoft Access Tutorial - 1 Hour, 17 Minutes
 
 
This Microsoft Access video tutorial picks up where Expert Level 4 left off. This class focuses on creating a letter report that you can print, export, or email to your customers directly from your database. You will learn how to edit embedded macros, customize the Ribbon, work with Hyperlink parts, and more. Topics include:
 
  - Print a Letter Report
  - Edit Embedded Macros
  - Dealing with Dirty Form Records
  - RefreshRecord Command
  - Export to Word, Excel, PDF, more
  - Email Report via Outlook
  - HyperlinkPart Function
  - EmailDatabaseObject Command
  - Customize the Ribbon

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 5
Description: Access Expert Level 5
Versions: Recorded with Access 2013. Also use with 2007 and 2010.
Pre-Requisites: Access Expert Level 4
Running Time: 1 Hour, 17 Minutes
Cost: $19.99


This class picks up where Expert Level 4 left off. We begin by taking the contact management form we've built in previous classes and upgrading it to allow us to type our correspondence in rich text directly in a memo field.

 

Next we will design a report that is formatted to look like a letter that we can then print out and send directly to our customers. This way all of our correspondence is stored right in our database. No more searching for Word documents. We'll learn how to format the letter report properly, adjust paper size, margins, add a logo, set up a page footer, page numbering, use the can grow and can shrink properties, and lots more.

 

Next we'll learn how to edit Embedded Macros. When we create a button to open the report with the Command Button Wizard, Access creates an Embedded Macro for us. Once you learn how to work with these macros, you can add all kinds of new stuff to your databases. We're just going to scratch the surface today by learning how to refresh the current record in our contact form before opening the letter report. This makes sure that any recent edits are reflected before we print. You'll learn about the OpenReport command, the RefreshRecord command, build events, dirty records, and lots more.

 

Printing the letter is nice, but this is the 21st Century. We want to be able to email our reports! In this lesson, we'll learn how we can email a report with a single click. The Command Button Wizard can create an email button for us, but with a few changes in the button's macro, we can automatically populate the email address, subject line, and more. You'll learn about the EmailDatabaseObject command, the HyperlinkPart function, and more. Plus, we'll see how to export the report in several different formats: Excel, Word, PDF, etc.

 

Finally, we'll take a few minutes to learn how to customize the Ribbon. We'll see how to navigate the Ribbon using just the keyboard, add and remove buttons from the Quick Access Toolbar, and create our own custom Ribbon tabs and groups.

 

This is the fifth class in the Access Expert series. If you need to manage any kind of customer correspondence, send email from your database, print or export reports in different formats, or any of the above topics, then this is a good 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 5

0. Intro (06:52)

1. Contact Letter Query (9:51)
Make Notes Field Rich Text
Set fields to Rich Text
Open Report to Specific Record
Query Criteria Forms!FormName!Field
Run Query Without Form Open
Enter Parameter Value Prompt

2. Contact Letter Report (15:16)
Format of a Printed Letter
Create Blank Report
Bring in Contact Query Fields
Remove Borders
Long Date Format
Create FullName Field in Report
String Concatenation in Text Box
Can Grow, Can Shrink
Text Box and Section Grow / Shrink
Label for Return Address
SHIFT-ENTER for New Line
Paper Size
Margins
Put Logo on for Letterhead
Line and Web Address in Page Footer

3. Print Letter Button (11:45)
Command Button
Print Preview Report
Dirty Records
Refresh Data Before Opening Report
Edit Embedded Macro
Build Event
OpenReport Command
Add New Action
RefreshRecord Command
Change Order of Macro Commands
Match Size of Text Box with Letter
Page Numbering
Page N of M
4. Export or Email Letter (18:15)
Export to Excel
Export as Text File TXT
Export as PDF or XPS
Send as Email Attachment w Outlook
Export as Word Document
Export as HTML Document
Email Report Command Button
EMailDatabaseObject Command
Object Type
Object Name
Output Format
Anatomy of a Hyperlink Field
HyperlinkPart Function

5. Customizing the Ribbon (9:06)
Using ALT Keys
Minimize the Ribbon
Collapsing the Ribbon
Customize Quick Access Toolbar
Add to Quick Access Toolbar
Access Options
Customize Ribbon
Popular Commands
Commands Not in the Ribbon
New Custom Tab
New Custom Group

6. Review (5:54)

 


 
Keywords: Print Letters, Edit Embedded Macros, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, rich text, letter writer, can grow, can shrink, paper size, margins, logo, hyperlink, dirty record, refresh, embedded macros, build event, openreport, refreshrecord, export to excel, export as pdf, emaildatabaseobject, hyperlinkpart, customize the ribbon
 

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