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 > Developer > < Advanced
 
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
DoCmd.OpenForm
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 24 minutes

Remove from Multi-Select Listbox
Single-column, Multiple-column boxes
Export Single Customer PDF Files
DoCmd.OutputTo, acFormatPDF
DLookupPlus Function
Example: Sales Reps and States Covered
    Joe: NY, TX, FL
    Sue: PA, CA
       

Developer 18
2 hours 46 minutes

Progress Bars
What's Faster: SQL or Recordset
Calculate Elapsed Time
Show Time Remaining
Navigating Recordsets: Move First
   Previous, Next, Last
Edit, AddNew, Update, Delete, Sort
       
Developer 19
2 hours 24 minutes
Bound Multi-Select List Boxes
Nested Recordset Loops
Chef's Kitchen Helper
What Dishes Can I Make w Ingredients
Remove Ingredients from Pantry Inventory
       
Developer 20
2 hours 26 minutes
OpenDatabase Command
Recordsets to External Database
Multiple Nested Loops
TreeView Control
Self Joins
       
Developer 21
1 hours 57 minutes
Scrubbing Data
Nested Continuous Subforms
Side-by-Side Subforms
Arrays
Parent Breadcrumbs
       
Developer 22
2 hours 51 minutes
Tag Property
For Each Loops
Apply Payments to Multiple Orders
Numbering Rows with Counter
Manual Order, Auto Renumber
Me.SelHeight Property
       
Developer 23
4 hours 38 minutes
Rental History Tracking
Scan Items Out by Customer
Batch Scan Items Back In
Order Entry, Printable Invoicing
Inventory Tracking, Ship Products
Lock Order, Remove on Hand
       
Developer 24
1 hour 54 minutes
Reservation System
Rules For Reserving (dates, length, etc.)
Conflict Resolution
Copy Record with Children
Recordset Copy
Loop through Fields Collection
       
Developer 25
2 hours 14 minutes
ByRef v ByVal
Return Multiple Values from Function
ActiveForm, ActiveControl
Product Groups
Add Packages / Bundles to Orders
Hide $0.00 on Invoice
       
Developer 26
2 hours 20 minutes
Two Search Forms
Dynamic SQL Statements
Filter Boxes, Sort by Column Header
Criteria Table: Unlimited Conditions
TableDefs, Fields Collection
Field Properties, Data Type
       

Developer 27
1 hour ?? minutes

Developer 27 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!
       
       

 

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:

2/24/2021Access Developer Forum
2/24/2021Widows & Orphans
2/23/2021Access Runtime
2/22/2021Table-Level Validation
2/21/2021Images
2/20/2021Not Updateable
2/20/2021Troubleshooter
2/19/2021Filter Records
2/18/2021Access Developer 26
2/17/2021Access Developer 27
 

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 developer courses  PermaLink