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 31

Next: Access Advanced 1 >

Access Expert Level 32

Expert Microsoft Access Tutorial - 1 Hour, 46 Minutes
 
 
Access Expert 32 focuses on Reports, Statistics, and an Intro to Macros. Topics include:
 
access cd   - Report Grouping Headers
  - Display a List of All Reports in Database
  -
Generate a Custom List of Reports

  - Report List Form, Click to Open
  - Subqueries, Rank, Median, Mode
  - Insert Blank Mailing Labels at Top
  - Introduction to Macro Programming
  - GoToRecord, SetValue Commands
  - InputBox, RunMenuCommand
  -
Lots more

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 32
Description: Access Expert Level 32
Versions: Recorded with Access 2016. Most of the material should work with all versions of Access from 2007 on.
Pre-Requisites: Access Expert Level 31 strongly recommended, as you should watch all of my classes in order. However, if you're skipping around, you should have at least completed the Beginner series and the first 3 or 4 levels of the Expert series where I start to cover functions.
Running Time: 1 Hour, 46 Minutes
Cost: $26.99


This class covers a wide variety of topics that we didn't get to in any of the other Expert series classes. We will begin by working with report grouping headers. I will show you how to make a single letter header for your reports.

single letter report header

 

Next we will see how to generate a list of all of the reports in the database. We will use this list to create a custom form where the user can browse the list and then click a button to open that report. We will use a system-generated list first, and then I will show you a technique to create your own custom list so you can control what appears there.

report list msysobjects

 

Next we will spend some time with statistics. The RANK, MEDIAN, and MODE functions are easy to implement in Excel, but Access is surprisingly missing them. You need to learn how to work with something called SubQueries in order to generate these values. So, that's what we'll do in this lesson. We'll also learn how to calculate percentiles.

rank median mode

 

The upcoming Advanced series of Access lessons will focus on Macro Programming, so in today's class we're going to take a little preview so you can see what's to come. In this lesson, we're going to tackle one of the most commonly asked questions that I get: how to insert blank mailing labels on top of a label sheet. We'll learn a whole bunch of macro commands like GoToRecord, SetValue, InputBox, RunMenuCommand, and more.

macro programming mailing labels

 

This is the 32nd class in the Access Expert series. If you're serious about building quality databases with Access, and you have any interest in charts, don't miss out on this course. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access Expert Level 32

00. Intro (4:10)

01. Single Letter Report Header (18:05)
Contact Report
Creating Group for Single Letter
Group by First Character
Display LEFT 1 Character
Group by Contact Name
IsNull to Show No Company Name

02. Report List Form (17:19)
List of All Reports in Database
MSysObjects Table
List of Type Values
Custom Report List Table
Report List Form and Listbox
Macro to Open Report
Build Event
On Click Event

03. Rank, Median, Mode (25:04)
SubQueries, SubQuery
Query Customers Less Than Average Employees
Rank Formula
Alias for a Table
Median Value "Good Enough"
Mode Value
Totals Query, Top 1 Value
Percentile Ranking
04. Intro to Macros (36:18)
Customer Mailing Labels
Create LabelT Table
Create LabelR Report
Insert Blank Records at Top
Cut and Paste
Create LabelF Form
Create View Labels Button
Print Preview Report
Macro to Insert Blank Records
Command Button Macro
GoToRecord New Record
SetValue
Show All Actions
Unsafe Actions
Form Macros v External Macros
Button to Run External Macro
Prompt For Loop Count Value
InputBox Function
Insert Blanks on Top of Label Sheet
RunMenuCommand
SelectRecord, SelectAllRecords
Cut, Paste
Button on Customer Form to Add Label
OpenForm

05. Review (5:12)

 


 
Keywords: Reports, Median, Mode, Intro Macros, microsoft access tutorial, microsoft access tutorial, microsoft access training, report header group, report list, on click event, rank, subquery, percentile, gotorecord, runmenucommand
 

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