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

< 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 Beginner Level 9
Description: Access Beginner Level 9
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access 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 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()
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
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 tutorial, microsoft access 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


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 12:46:22 AM. PLT: 0s