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