Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Courses > Access > Expert < Beginner | Advanced >
 
Access Expert Courses

This is the complete list of my Access Expert classes. These follow the Beginner series.

Expert Lessons

After you've mastered the Beginner series, move up to the Expert Lessons to learn about table relationships and lots more.

     
  Access Expert 1
 
 
 


1 hour 18 minutes

$19.99
 
Order Now
 
More Info
 
FREE Sample
Relational Database Concepts
Primary & Foreign Key Fields
Types of Relationships
Focus on One-to-Many Relationships
Ad Hoc Query Joins
Left Joins to Show All Records
Relational Combo Boxes
Fixing Lead Source & Shipping Combos
Select a Customer on the Contact Form
     
     
  Access Expert 2
 
 
 


1 hour 25 minutes

$19.99
 
Order Now
 
More Info
 
FREE Sample
Database Table Normalization
Global Relationships
Working with the Relationships Window
Referential Integrity
Preventing Orphaned Records
Cascade Update & Delete
Table Subdatasheets
Setting Values Across Different Forms
Forms ! FormName ! FieldName
     
     
  Access Expert 3
 
 
 


1 hour 26 minutes

$19.99
 
Order Now
 
More Info
 
FREE Sample
SQL Basics
Future Callbacks for Customers
Default Value to Tomorrow at 9 AM
Creating Subforms
Link Master & Child Fields
Using SQL in Form Record Source
Form Footer Totals
Sum, Avg, Max, Min, Count
Modifying Embedded Macros
     
     
  Access Expert 4
 
 
 


1 hour 48 minutes

$20.99
 
Order Now
 
More Info
 
FREE Sample
Additional Form Controls
Option Groups, Tab Control
Toggle Buttons, Enhanced Formatting
List Box, Image Control
Display Image Without Storing
One-to-One Relationships
Extended Customer Details
More One-to-Many Relationships
Track multiple family members
     
     
  Access Expert 5
 
 
 


1 hour 17 minutes

$20.99
 
Order Now
 
More Info
 
FREE Sample
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
     
     
  Access Expert 6
 
 
 


1 hour 18 minutes

$20.99
 
Order Now
 
More Info
 
FREE Sample
Send Mass Mail from Access
Collection Letters
Automatic Date Ranges
New Report Properties
Force New Page
Multiple Letter Templates
Letters to All Active Customers
Allow Edits vs. Locked Fields
Send To Customers by Category
     
     
  Access Expert 7
 
 
 


1 hour 37 minutes

$20.99
 
Order Now
 
More Info
 
FREE Sample
Many-to-Many Relationships
Table Lookup Wizard
Multi-Valued Fields
Assign Customer to Multiple Groups
Junction Tables
Prevent Duplicate Records in a Query
Format a Report for Post Cards
Products from Multiple Vendors
Track Unit Cost and Profit
     
     
  Access Expert 8
 
 
 


1 hour 55 minutes

$20.99
 
Order Now
 
More Info
 
FREE Sample
Order Entry System
Order Form and Details Subform
Calculated Query Fields
Figuring Sales Tax if Taxable
IIF Function (If/Then/Else)
Proper Rounding of Values
Bankers Rounding
Nesting Functions
Final Product and Tax Totals
     
     
  Access Expert 9
 
 
 


1 hour 45 minutes

$21.99
 
Order Now
 
More Info
 
FREE Sample
Sharing Data Between Forms
Customer & Order Discount Rates
Default System Values Table
Multiple Sales Tax Calculations
SQL ALIAS
Printable Invoice Report
Inserting Subreports
Problems with Can Shrink
Open Report to a Specific Record
     
     
  Access Expert 10
 
 
 


1 hour 27 minutes

$21.99
 
Order Now
 
More Info
 
FREE Sample
Quotation or Invoice
Paid or Unpaid
Nested IIF Functions
The DLOOKUP Function
Sales Reps & Service Techs
DLOOKUP Criteria (ID, String, Date)
Display Values Direct from Tables
Calculated Table Fields
Expressions in Queries vs Tables
     
     
  Access Expert 11
 
 
 


1 hour 48 minutes

$21.99
 
Order Now
 
More Info
 
FREE Sample
Aggregate Queries
Sum, Avg, Count, Max, Min
Complex Query Criteria
Sales Totals by Month
Find Lowest Product Cost
Last Customer Contact Report
Employee Work Log, Timesheet
Calculate Hours Worked
DSUM Function
     
     
  Access Expert 12
 
 
 


2 hours 33 minutes

$22.99
 
Order Now
 
More Info
 
FREE Sample
Sorting & Grouping Levels
Build an Order List Form
Refresh vs. Requery
Employee Work Log Entry Form
Group Headers & Footers
Customers Grouped by State
Employee Hours by Week of Year
Sales Grouped in $500 Increments
Fix Collection Letter Reports
     
     
  Access Expert 13
 
 
 


1 hour 22 minutes

$22.99
 
Order Now
 
More Info
 
FREE Sample
Update Queries
Types of Action Queries
Report Where Conditions
Datasheet View vs Run Query
UCase, LCase, Proper Case
Deleting Tables with Relationships
Assign Sales Rep by State
Add 5% to all Product Prices
Update Paid Orders with Ship Date
     
     
  Access Expert 14
 
 
 


1 hour 34 minutes

$22.99
 
Order Now
 
More Info
 
FREE Sample
More Update Queries
Scrubbing (Cleaning) Data
Data with Inconsistent Formatting
Use Replace Function to Change Text
CStr, Nz, InStr, Left, Right Functions
Separate First & Last Names
Fix Non-Relational Tables
Append Queries
Daily Student Attendence Table
     
     
  Access Expert 15
 
 
 


1 hour 57 minutes

$23.99
 
Order Now
 
More Info
 
FREE Sample
Track Student Attendance
Put Customers / Students in Classes
Create a Daily Attendance Form
Use a Macro to Run Append Query
Disable System Warnings
Enable All Macro Actions
Attendance Reports by Student / Date
Delete Queries
Archive Old Customer Contacts
     
     
  Access Expert 16
 
 
 


1 hour 19 minutes

$23.99
 
Order Now
 
More Info
 
FREE Sample
Macro to Run Multiple Queries
Delete Query on Multiple Tables
Referential Integrity with Delete Queries
Make Table Queries
Backup Table to Another Database
Multiple Parent Student Mailings
Include Multiple Parents in Mailings
UNION Queries
Merge New Contacts with Archive
     
     
  Access Expert 17   
 

crosstab queries
1 hour 37 minutes

$23.99
 
Order Now
 
More Info
 
FREE Sample
Archive Old Unpaid Orders
Select & Mark Orders w Update Query
Create a Form to Review Orders
Append to Archive Table w Macro
Backup Customers, Orders, Details
Add "Write-Off" Notice to Customer Rec
Union Query for Reporting on Both
More with Embedded Button Macros
CrossTab Queries (PivotTables)
     
     
  Access Expert 18   
 

crosstab queries
1 hour 15 minutes

$24.99
 
Order Now
 
More Info
 
FREE Sample
Crosstab Query
Parameters & Criteria in Crosstabs
Fixed Column Headings
Find Duplicates Query
Partition Function, Create Tiers
Find Unmatched Query
Advanced Query Properties
Unique Values, Records
Cartesian Products
     
     
  Access Expert 19   
 


1 hour 40 minutes

$24.99
 
Order Now
 
More Info
 
FREE Sample
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
     
     
  Access Expert 20   
 

access expert 20
1 hour 49 minutes

$24.99
 
Order Now
 
More Info
 
FREE Sample
Sending Mass Email from Access
Importing Data from Microsoft Excel
Linking Live to Excel Spreadsheet Data
Importing Text Files
Importing Data from HTML Pages
Importing and Exporting XML Data
Saving XML Schema Data (Table Info)
Linking to Outlook Folders
Reading/Editing Inbox, Contacts
     
     
  Access Expert 21   
 

access expert 21
1 hour 54 minutes

$25.99
 
Order Now
 
More Info
 
FREE Sample
Import Access Database Objects
Linking to Other Access Databases
Splitting Your Database
Custom Front-End and Back-End DBs
Database Splitter Wizard
Shared Folder Permissions
Creating an Encrypted Front-End File
Preventing Design Changes
Record Locking in a Shared Environment
     
     
  Access Expert 22   
 

fix non relational data
2 hours 3 minutes

$25.99
 
Order Now
 
More Info
 
FREE Sample
Fixing Non-Relational Data
Split a Spreadsheet into Multiple Tables
Update Vendor Price Changes
Create Macro for One-Click Operation
Fix Our Order-Entry System
Product Change Don't Affect Orders
Build New Button Macro From Scratch
IF, GotoControl, GotoRecord
Manually Add Products Not In Database
     
     
  Access Expert 23   
 

remote data entry
1 hour 40 minutes

$25.99
 
Order Now
 
More Info
 
FREE Sample
Remote Data Entry Database
View Info, Add Contacts Remotely
Synchronize With Main Server
Import Bank Transactions
Prevent or View Duplicates
Multi Field Composite Keys
Prevent Duplicate Sales Reports
Transfer Relational XML Data
Exporting Customers With Orders
Maintain Relationships via XML Files
     
     
  Access Expert 24   
 

access 24 sql server rss
1 hour 33 minutes

$26.99
 
Order Now
 
More Info
 
FREE Sample
Import RSS Feed Data
Download Latest News from Web Sites
Display Weather Conditions
Use the WebBrowser Control
Display Images from a Web Page
Program Timer Events
Launch a Macro at Timed Intervals
Setup Online SQL Server Database
Create ODBC Connections & DSN Files
Share Access Data via the Internet
     
     
  Access Expert 25   
 

access expert 25
1 hour 33 minutes

$26.99
 
Order Now
 
More Info
 
FREE Sample
String Functions
Left, Right, Mid, InStr, InStrRev, Len
LCase, UCase, Trim, RTrim, LTrim
Replace, Str, CStr, StrComp, ASC, CHR
Space, String
Logical Functions
IsDate, IsNull, IsNumeric, IsError
NZ, VarType, TypeName
And, Or, Not, Xor, IIF, Nested IIF
Switch, Choose
     
     
  Access Expert 26   
 

access math functions trig
1 hour 41 minutes

$26.99
 
Order Now
 
More Info
 
FREE Sample
Math Functions
Abs, Sgn, Round, Int, Fix, Val
Sqr, Exp, Log, Natural Logarithms
Calculate Pi, Degrees to Radians
Trig Functions: Sin, Cos, Tan, Atn
Mod, Integer Division, Is Divisible
Random Numbers: Dice Roller
Display Random X Records
Type Conversion Functions
CInt, CLng, CStr, CDate, CCur, etc.
     
     
  Access Expert 27   
 

access expert 27
1 hour 39 minutes

$27.99
 
Order Now
 
More Info
 
FREE Sample
Date/Time Functions Part 1
More with Now, Date, Time Functions
Query Data in a Variety of Date Ranges
Date & Time Mathematics
Two Digit Year "2030" Problem
List of Upcoming Birthdays
Aged Accounts Receivable Report
Display Times as 8:30, 8.5, 8h 30m
Timesheets Spanning Midnight
Calculating Someone's Approximate Age
     
     
  Access Expert 28   
 

acx28
2 hours 18 minutes

$27.99
 
Order Now
 
More Info
 
FREE Sample
Date/Time Functions Part 2
Break Apart with Day, Month, Year
Get Day of the Week with WeekDay
DateAdd - 2 months from today?
DateDiff - How long until loan paid?
DatePart - Is order from last quarter?
DateSerial - Find last day of month
Display Ordinals: 1st, 2nd, 3rd, etc.
Calculate someone's exact age
List of birthdays for next month
     
     
  Access Expert 29   
 

access expert 29
2 hours 7 minutes

$27.99
 
Order Now
 
More Info
 
FREE Sample
Aggregate Functions
Sum, Avg, Count, Max, Min, First, Last
Domain Aggregate Functions
Lookup Functions
DLookup, DSum, DCount, DAvg
DMax, DMin, DFirst, DLast
Calculate Average Daily Sales
Create Your Own Custom Counter
Display Running Sums (Balances)
Excel VLOOKUP Replacement
     
     
  Access Expert 30   
 

access 30 financial functions
1 hour 44 minutes

$28.99
 
Order Now
 
More Info
 
FREE Sample
Financial Functions
Simple v. Compound Interest
Loan Payment Calculator: PMT
Find Future Value of Investment: FV
Calculate Return On Investment: RATE
Years Until I'm a Millionaire: NPER
How Much Home Can I Afford: PV
Saving For Kids College Fund Calculator
Loan Amortization Basics
Calculating Principal and Interest Parts
     
     
  Access Expert 31   
 

charts
1 hour 15 minutes

$28.99
 
Order Now
 
More Info
 
FREE Sample
Charting Basics
Chart Components
Formatting Charts
Multiple Data Series Charts
3D Charts
Forecasting with Trendlines
Pie Charts
Creating a Chart Dashboard
Chart Reports
Lots more
     
     
  Access Expert 32   
 

access expert 32
1 hour 46 minutes

$28.99
 
Order Now
 
More Info
 
FREE Sample
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
Intro to Macro Programming
GoToRecord, SetValue Commands
InputBox, RunMenuCommand
Lots more
 

Next up... the Advanced Series...

Become a Member. Save 50%

Join my Learning Connection program. Get the next class in the series each week at a 50% discount. Cancel any time. The most effective way to learn Access. Also, don't forget to check out my Access TechHelp videos! New lessons released almost every day.

 

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/28/2021Random
11/22/2021Currency Symbols
11/13/2021Access Developer 36
11/13/2021Access Developer 36 Lessons
11/13/2021Access Developer 36
11/13/2021Control Tip Text
11/11/2021Link to Excel
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access expert series  PermaLink