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

< Previous: Access Expert 18

Next: Access Expert 20 >

Access Expert Level 19

Expert Microsoft Access Tutorial - 1 Hour, 40 Minutes
This Microsoft Access video tutorial picks up where Expert Level 18 left off. In this class we will focus on Conditional Formatting and Exporting our data into other formats. Topics include:
  - Conditional Formatting
  - Advanced Conditional Expressions
  - Exporting to Microsoft Excel
  - Exporting to Microsoft Word
  - Microsoft Word Mail Merge
  - Exporting Text Files
  - Fixed Width vs. Delimited Text
  - Exporting to Other Databases
  - Exporting HTML Files for the Web

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 19
Description: Access Expert Level 19
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 18 strongly recommended
Running Time: 1 Hour, 40 Minutes
Cost: $26.99

Today we will begin by learning all about Conditional Formatting. This is where you can change the format (font, color, etc.) of data based on the value of the data. We'll start by learning how you can create simple rules, such as "change this field red if the value is greater than or equal to 500."

conditional formatting


Then we'll learn about more complex rules involving multiple formats. For example, show the value in red if it's under $20 and yellow if it's over $500.

conditional formatting


Next we'll learn about the very powerful Conditional Formatting Expressions. This is where you can set a format based on any formula or function you want, such as changing the color of the customer's name to yellow if it includes the string "Inc" within it.

expression is


You can even use expressions to change different fields. For example, set the color of the entire row to yellow if the order total is over $500.

expression is


You can use conditional formatting to disable changes to a record if a particular value is set. For example, don't let the user make any changes to an order once the "Is Paid" checkbox is set to yes. In this example we just locked the customer selection combo box, but you can apply it to all of the text fields if you'd like.

disable changes


You can use the Field Has Focus rule to set the format of the field that the user is currently on (clicked or tabbed to). This is nice for highlighting which field "has focus."

 field has focus


You can use Data Bars to visually indicate the highest and lowest values in a range of values. For example, here we've used Data Bars to show the highest sales and lowest sales. The higher the order total, the more "red" the field appears.

data bars


Next we'll learn how to export data from our database into different formats. We'll begin by learning how to export to Excel.

export to excel


We'll discuss the different types of Excel file formats, and see how to get our data into an Excel spreadsheet.

export to excel


You might not want to export ALL of the records from a table, so next we'll make a Customer Export Query so we can go through our list of customers and pick which ones we want to export to Excel.

customer export query


Next up, exporting to Microsoft Word. We'll see how you can take those mailing labels we created in an earlier class and send them straight to Word. This way you can edit them individually before printing them, or you can send them to someone else to be printed.

export mailing labels to word


We will learn how to use a powerful feature called Mail Merge in Microsoft Word. This will allow us to use data from our Access database and merge it into document (such as letter or envelopes) in Word to send mass mailings.

mail merge


We'll learn how to use Merge Fields to format the document exactly as we want it, by putting the data fields from our database exactly where we want them in the document.

mail merge


Next we will learn about Exporting Text Files in various formats. We'll learn about Fixed Width and Delimited Text, field delimiters, text qualifiers, formats for dates, and much more. We'll learn how to save our export specifications to be used later.

export text


Finally, we'll learn how to export to other databases. We'll export our tables to another Access database, export to XML, and we'll discuss exporting to Sharepoint and other ODBC sources, such as SQL Server.

export to xml


Finally, we'll learn how to export our data in standard HTML files that can be uploaded and used directly in your web sites.

export to html


This is the 19th class in the Access Expert series. There is a lot of great material in this class. Conditional Formatting will add a look of professionalism to your database, and knowing how to export data into various other formats will help you share your data with the world. Of course, if you have any questions about whether or not this class is for you, please contact me.


Complete Outline - Access Expert Level 19

00. Intro (6:15)

01. Conditional Formatting (28:13)
Format large orders green
Conditional Formatting Rules Manager
New Formatting Rule
Check values in the current record or use an expression
Field Value Is
Greater than, Less than, etc.
Highlight orders over $500 in green
Add Views to Quick Access Toolbar
Conflicting Rules
Order of Applied Rules
Using Functions like Date() in Conditions
Formatting Date Values
Formatting Text Values Exact
Find Text Inside of Field
Expression Is
InStr Function
Format Customers with "Inc" in name
Apply to Multiple Fields at Once
Format Entire Row
Format if Field Has Focus
Disable Changes if Order Marked Paid
Conditional Format Subform Value
Disable Editing Products on Order if Paid
Compare to Other Records
Data Bars
Lowest, Highest value
Numbers, Percentages
Max 50 Conditions

02. Exporting to Excel (16:37)
Reasons to Export Data
Export Table to Excel
Different Versions of Excel Data
Export data with formatting and layout
Open the destination file after the export
Export selected records
Copy and Paste from Access to Excel
Copy Without Column Headers (Field Names)
Add an Export Checkbox to Table
Export Specific Records Query
Hide the Export Field
Save Export Steps
Create an Outlook Task with Reminder
Saved Exports
Manage Data Tasks
Run Saved Export Routine
03. Exporting to Word (15:05)
Export Mailing Labels
Export RTF File to Word
Mail Merge Access Data to Word Document
Word Merge
Microsoft Word Mail Merge Wizard
Link your data to an existing Microsoft Word document
Create a new document and then link the data to it
Mail Merge Wizard
Edit Recipient List in Word
Insert Address Block
Insert Merge Field
Preview Your Letters
Word Doc Automatically Updates from Table
Copy and Paste Table Data to Word

04. Exporting Text Files (10:14)
Export Text File
Export Windows Text
Notepad Application
Basic Access Text Export is Garbage
Export Without Formatting
Export Text Wizard
Fixed Width vs. Delimited Text
Changing Width of Field
Field Delimiter
Text Qualifier
Date Order
Date Delimiter
Time Delimiter
Four Digit Years
Leading Zeros in Dates
Decimal Symbol
Save Export Specification
Include Field Names in First Row

05. Export Misc (18:23)
Export to XML
Export to Another Access Database
Database must be closed
Access needs exclusive read/write
Queries Export as Queries NOT Tables
Copy Multiple Tables
Export to Sharepoint, Brief Discussion
Export to ODBC, Brief Discussion
Export to SQL Server, Brief Discussion
Export to HTML Document
Formatted v. Unformatted HTML
Coming Up

06. Review (5:32)


Keywords: Crosstab Query, Find Duplicates, Find Unmatched, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, conditional formatting, expression is, instr, export to excel, create an outlook task, export to word, word merge, microsoft word mail merge wizard, export text files, fixed width, delimited text, export to access, export html


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: 2/24/2024 11:20:17 PM. PLT: 0s