Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon  
Home > Courses > Access > Developer >
Access Developer Courses

After you've finished the Beginner, Expert, and Advanced series, move up to the Developer Lessons to learn how to super-charge your databases with programming in Visual Basic for Applications. Most of these courses work with every version from Access 2007 thru 2019.


Developer 1
1 hour 5 minutes

Introduction to Access VBA
Statements, Procedures, Parameters
Multiple Command Arguments
SetWarnings, OpenQuery
If / Then / Else Statements
GoToControl, GoToRecord
Add New Customer Button
AfterUpdate Events in VBA

Developer 2
1 hour 22 minutes

Building a Calculator Form
Basic Debug, On Error Resume Next
Creating Subs with Parameters
Select Case Statements
Creating Functions
Returning Values from Functions
Comments, Line Continuation
More MsgBox Options
RunSQL, Insert Into

Developer 3
1 hour 23 minutes

Variables, Dim, Initializing
MsgBox as a Function
Random Numbers, Rnd, Randomize
Constants, Const Keyword
InputBox Function
Math Quiz Form
For Next Loops
Data Types in VBA
Quick Add Sales Rep

Developer 4
1 hour 35 minutes

Notes on Order Details
DLOOKUP from Product Table
Change Size of Field in OnGotFocus
Constants, Const Keyword
OnDblClick Event
Sales Commissions by Order Amt
Commission Range Brackets
DMAX and DLOOKUP together
Use SQL to Load Order List

Developer 5
1 hour 40 minutes

Pay Employee Commissions
Commission Check Form
Move Between Two List Boxes

Drag and Drop Alternative
Printing Checks
Convert Currency to English Text
Find Largest Check Number
Format Laser Printable Checks
Processing Commission Checks

Developer 6
1 hour 38 minutes

Converting Macros to VBA Code
Quote or Invoice Button & Report
Enhanced Timer Form
One Second Timer with Countdown
OnTimer and TimerInterval
Cascading Combo Boxes
Select Category, Limit Product
Automated Backups
Backup Specific Tables, Database

Developer 7
1 hour 12 minutes

Partial Payments on Invoices
Refreshing Subforms in VBA
Form ! Subform Notation
vbExclamation, vbCritical
Don't Allow Payments if PAID
NZ Function to Handle Null Payments
Hide Fields on Invoice by Criteria
Can Shrink Issue for Hidden Fields
Adding Missing Fields to Subforms

Developer 8
1 hour 20 minutes

More Partial Payments Invoices
Combo DropDown Method
On Unload Event
Locking Invoices if Paid
Creating a Public Global Function
Globally Search VBA Code
Allow Additions, Edits, Deletions VBA
Search As You Type
On Key Press, On Change Events

Developer 9
2 hours 32 minutes

Add Search Form to Main Menu
Fixing Delete a Payment Problem
Lock or Unlock if Invoice Paid
Test Taker Database, Part 1
Table Setup, Relationships, Ref Integrity
Dept, Class, Test, Question, Answer
Multiple Choice v. Fill in the Blank
Continuous Form with Subform
Begin Taking Test, Save All Results

Developer 10
1 hour 30 minutes

Test Taker Database, Part 2
Determine Which Question to Ask
Display List Box for Multiple Choice
Display Text Box for Fill-in-the-Blank
Check Answer for Correctness
Store Results in Session Answer Table
Calculate Student's Grade
Store Results in Answer Table
NZ, StrComp, Round Functions

Developer 11
1 hour 44 minutes

Test Taker Database, Part 3
Display Question 1 of X
Close Child Forms if Parent Closed
Tracking Start and End Times
Display Timer on Form, Timeout
RGB Function and Colors
Calculate Elapsed Time
Universal Dialog Box, Part 1
Customized uDialog Box with Options

Developer 12
1 hour 50 minutes

Universal Dialog Box, Parts 2 & 3
Add OK, Cancel Buttons
DoEvents in Timer Loops
Global Variables, While Loops
Custom Form Positioning
Move, Resize Form Windows VBA
Twips, InsideHeight, InsideWidth
External String Manager
Dynamic Labels on Forms and Reports

Developer 13
1 hour 52 minutes

Search Between Dates
Before, After, Between Date Search
Select Case Control Structure
Tuition With Multiple Options
Billing on Grade Level
Variable Discounts Applicable
Same as Products w Different Features
Multi Field Index / Composite Keys
Pricing Wizard Form

Developer 14
2 hours 40 minutes

Easy Access POS Part 1
Planning the Point of Sale System
Advanced Design Preparation
Detailed List of Features
Building the Tables, Relationships
Barcode Scanner Considerations
Main Order Entry Form
Category, Product List Boxes
Group, Person Forms

Developer 15
1 hour 45 minutes

Move Between Two List Boxes
Passing a Control as a Parameter
Advanced Debugging
Custom Error Handler
Immediate, Watches, Breakpoints
Multi-Select List Boxes
ListCount, ItemData, ItemsSelected
For Each Loops
db.Execute vs. DoCmd.RunSQL

Developer 16
1 hour 58 minutes

More Multi-Select List Boxes
Visual Glitch in List Box Selection
Formatting, Colors in a List Box
On Mouse Move Event
Recordsets, Part 1
Looping Thru Records in a Recordset
Adding Records to Unbound List Box
RemoveItem from Single List Box
Dealing with No Records: EOF, BOF

Developer 17
1 hour ?? minutes

Developer 17 is currently under
development. Enroll now and you can
join in, ask questions, and provide
feedback while the class is underway!
Interactive student participation is
the best way to learn. Sign up today!
Coming Soon!


Post a New Comment or Question
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.

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

10/21/2020Consolidate Tables with Helper Data
10/20/2020Is Microsoft Access Going Away?
10/12/2020Store Multiple Phone Numbers
10/10/2020ABCD Part 1: Core Database
10/10/2020Create Your Own Custom Function
10/8/2020Update Query from Another Table
10/5/2020Access Business & Contact Database
10/5/2020How and Why to Split Your Database
10/2/2020Multiple Nested Continuous Subforms
9/28/2020Access Developer 18

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access developer courses  PermaLink