Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Beginner > < Access | Expert >
Access Beginner Courses

Welcome to the Access Beginner Series. I'm still upgrading all of my courses for 2024. All of my older classes for Access 2013 are still perfectly valid for Access 365, 2016, 2019, 2021, and beyond. Access hasn't changed that much. 99% of the material is the same once you're past Beginner 1.


Beginner 1
4 hours 16 minutes - FREE

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 2
1 hours 45 minutes - $1.00

Setup Trusted Location
Continue With Form Design
Align, Size Objects
Form Formatting, Grid Lines & Dots
Colors & Themes
Introduction to Relationships
Appointment Table & Form
Command Button to Open Form
Combo Box to Select a Customer

Beginner Lessons

Once you're beyond the basics, Access is almost the same from version to version. In fact, Access 2007 to 2019 are almost identical.

  Access Beginner 3

1 hour 19 minutes

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

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

Query Criteria
Multiple AND, OR Conditions
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

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

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

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

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

Next up... the Expert 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. Also, don't forget to check out my TechHelp videos! New lessons released almost every day.


Comments for Access Beginner Courses
Age Subject From
6 monthsCourse Completion CertificatMichael Olsen
8 monthsInput MasksMatthew Redekop
16 monthsVersion of AccessStamatios Papoutsis


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Beginner Courses
Get notifications when this page is updated

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: 5/21/2024 9:49:14 PM. PLT: 1s
Keywords: access beginner courses  PermaLink  Microsoft Access Beginner Courses