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