Access 2007-2016
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 Beginner 8

Next: Access Expert 1 >

Access Beginner Level 9

Beginner Microsoft Access Tutorial - 1 Hour, 24 Minutes
 
 
This Microsoft Access video tutorial picks up where Level 8 left off. This class covers tracking a contact history for your customers. We will also spend a lot of time on designing reports from scratch.
 
  - Tracking Contact History
  - Data Integrity
  - Report Design From Scratch
  - String Concatenation
  - Report vs. Page Header & Footer
  - Can Grow / Can Shrink Properties
  - Records from a Specific Date
  - Explicit Query Parameters
  - Report Formatting

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 2010 Beginner Level 9
Description: Access 2010 Beginner Level 9
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Beginner Level 8
Running Time: 1 Hour, 24 Minutes
Cost: $14.99


This class picks up where Level 8 left off. We will focus primarily on tracking a contact history for your customers and designing reports from scratch. We begin by setting up a contact table and a simple contact form for data entry. We will discuss data integrity and how poorly entered data will make a mess of your database.

 

Next we'll create a contact query. You'll see how to hide duplicate fields with the Show Box. We'll generate a list of contacts from one specific date using an inequality, and we'll discuss how the BETWEEN keyword isn't always the best thing to use. You will learn how to declare explicit query paramters.

 

Next we'll begin building a contact report from scratch. The built-in report wizards and quick-report creators will only get you so far. You'll learn about the page header and page footer, the detail section, print preview, problems with the layout view, and how to remove the borders from around a text box. You'll learn how to set your report in portrait or landscape view, set the margins and paper size, add horizontal lines, and how to print your report.

 

Continuing on with our contact report, you'll learn how to use the Can Grow and Can Shrink properties to make sure the proper amount of space is reserved for your fields. You'll learn about String Concatenation to take two fields (such as First Name and Last Name) and put them together into one. You'll learn what the Trim function does.

 

Finally, you'll learn a ton of different report formatting techniques, including changing the alternate row background color (or removing it), HTML color codes, line thickness, line type, section background colors, the difference between the page header/footer and the report header/footer, how to set up page numbering, and more.

 

Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access 2010 Beginner Level 9

00. Intro (6:26)

01. Contact Table & Form (12:48)
What is a Contact
Why not use a Memo field?
Create Contact Table
Review of Now() Function
Create Contact Form
Enter Data into Contact Form
Notice Poor Data Integrity

02. Contact Query (11:39)
Bring in All Fields "ContactT.*"
Duplicate Fields
Show Box to Hide Column
Records from a Single Date
=#11/24/12# doesn't work
Between Keyword doesn't work
Inequality works
Today's Contacts with Date()
Date()+1
Yesterdays Contacts Date()-1
[Enter Date] in multiple places
Explicit Query Parameters

03. Contact Report 1 (14:54)
Building a Report from Scratch
Page Header, Footer
Detail Section
Print Preview
Problems with Layout View
Remove Box Borders
Transparent Shape Outline
Portrait vs. Landscape View
Margins
Horizontal Line
SHIFT to keep line strait
Printing Reports
04. Contact Report 2 (13:44)
Switch back to Portrait
Can Grow, Can Shrink
Force exact size for reports
String Concatenation
FirstName & LastName in Query
Trim Function
Concatenation in Report Fields
LastName, FirstName in Report

05. Miscellaneous (17:11)
Alternate Back Color
HTML Color Codes
Light Gray Line
Line Thickness
Line Type
Section Background Colors
Page Header vs. Report Header
Page Numbering
Page [Page] [Pages]
Report Footer
Confidentiality Notice
Add Buttons to Main Menu

06. Review (6:50)
 

 


 
Keywords: Contact History, Explicit Query Parameters, Report Design, Can Grow, Can Shrink, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 training, data integrity, show box, hide fields, records from specific date, page header, page footer, print preview, transparent, shape outline, portrait, landscape, margins, horizontal line, printing reports, string concatenation, trim function, alternate back color, html color codes, line thickness, line type, background color, report header, report footer
 

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