Access 2007-2013
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  
 
 
 
Access 2007-2013 Tutorials
  
These lessons are recorded with with Access 2010 or 2013. However, if you're using Access 2007, these lessons will work just fine for you. There are very few differences between these three versions.
  
Introductory Lessons

 

For people who are learning Access for the
very first time, we have 2010 and 2013 versions
of our Beginner Level 1 course available. If you
are still using Access 2007, get the 2010 edition.

     
  Access 2013 Beginner 1
 
 


3 hours 14 minutes

$5.99
 
Order Now
 
More Info
 
FREE Sample
Database Terminology & Benefits
Planning Your Database
The Access Interface & Ribbon
Building a Customer Table
Entering & Editing Data
Sorting and Filtering Records
Constructing Customer Queries
Designing a Customer Form Interface
Developing Reports & Mailing Labels
     
     
  Access 2010 Beginner 1
 
 


2 hours 22 minutes

$5.99
 
Order Now
 
More Info
 
FREE Sample
Database Terminology & Benefits
Planning Your Database
The Access Interface & Ribbon
Building a Customer Table
Entering & Editing Data
Sorting and Filtering Records
Constructing Customer Queries
Designing a Customer Form Interface
Developing Reports & Mailing Labels
     
Beginner Lessons

 

Once you're beyond the basics, Access is almost
the same from version to version. In fact, Access
2007, 2010, and 2013 are almost identical.
Each of the courses below works for all 3 versions.

     
  Access Beginner 2
 
 


1 hour 23 minutes

$9.99
 
Order Now
 
More Info
 
FREE Sample
Setup a Trusted Location
Working in Form Design View
Manually Adding Fields
Manipulating Form Objects
Lining up Objects on The Grid
Formatting Your Form
Using Themes, Fonts, & Colors
Working in Layout View
Using Overlapping Windows
     
     
  Access Beginner 3
 
 


1 hour 19 minutes

$9.99
 
Order Now
 
More Info
 
FREE Sample
What are Field Properties
Field Size
Caption & Description
Format Property
Decimal Places
Input Masks
Setting a Default Value
Validation Rule & Text
Using Inequalities
     
     
  Access Beginner 4
 
 


1 hour 19 minutes

$12.99
 
Order Now
 
More Info
 
FREE Sample
More Field Properties
Required & Allow Zero Length
Text Align & Format
HTML Encoded Rich Text
Indexing Fields
Compact & Repair
Backing Up Your Database
Find & Replace
Questions From Students
     
     
  Access Beginner 5
 
 


1 hour 14 minutes

$12.99
 
Order Now
 
More Info
 
FREE Sample
Query Criteria
Multiple AND, OR Conditions
Inequalities
Records Between Two Dates
Dealing with Null Values
Wildcards and LIKE
Parameter Queries
Top X Values
Formatting Query Field Output
     
     
  Access Beginner 6
 
 


1 hour 18 minutes

$12.99
 
Order Now
 
More Info
 
FREE Sample
Missing Address Info
Is Null and Is Not Null Scenarios
OLE Objects
Storing Pictures in a Database
Align / Size to Grid
Stretch, Clip, Zoom Images
Employee Name Badges
Adding a Company Logo
Bound v. Unbound Image Controls
     
     
  Access Beginner 7
 
 


1 hour 31 minutes

$14.99
 
Order Now
 
More Info
 
FREE Sample
Navigation Forms
Custom Main Menu Form
Sorted Customer List Form
Command Button Open Form & Report
Form Record Source Property
Creating Continuous Forms
Form Header & Footer
Open Form to a Specific Record
Allow Edits, Deletions, Additions
     
     
  Access Beginner 8
 
 


1 hour 12 minutes

$14.99
 
Order Now
 
More Info
 
FREE Sample
Value List Combo Box
Table-Based Combo Box
Multi-Column Combo Box
Combo Box to Search Records
List Boxes
Limit to List, Edit List Items Properties
Add, Edit the Combo Box Items
Tab Order, Tab Stop
Form Cycle Property
     
     
  Access Beginner 9
 
 


1 hour 24 minutes

$14.99
 
Order Now
 
More Info
 
FREE Sample
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
     
Expert Lessons

 

After you've mastered the Beginner series, move
up to the Expert Lessons to learn about table
relationships and lots more. Again, these courses
work for Access 2007, 2010, and 2013.

     
  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

$19.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

$19.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

$19.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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

$24.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 Coming Very Soon!

 
Pre-order your copy now to lock in a guaranteed price.

Click Here for Details on Advanced Access Lessons

Make sure to get on our Mailing List, or purchase one of our previous lessons and we'll notify you as soon as it's released (check our Production Schedule for details). We expect to release at least one new Access course per week for the next several months... until we have released upgraded versions for all of our Access 2003 lessons. If you buy any of these 2003 lessons, you will get a FREE UPGRADE to the 2010 editions as they're released. Click Here for Details.

 
More Expert & Advanced Lessons
 
 
 
 Expert
 Advanced
 Developer
 VBA
 
We are currently in the process of developing new Expert, Advanced, and Developer-level courses for Microsoft Access. If you would like to be notified when they are available, sign up for our Mailing List. You can check our Production Schedule for a timeline.
 
We do already have many Expert and Advanced classes available for Microsoft Access 2003. If you are interested in learning about more advanced Access, you might want to take a look at them. Once you get beyond the menu interface, the core functionality of Access is still pretty much the same.
 
Plus, if you purchase any of our older Access 2003 tutorials, you will get a FREE UPGRADE once the 2010 version is released.
 
 

Click here if you are looking for Access 2003 tutorials.

 

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
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