01. Transactions Part 1 (11:58)
Using DBFailOnError to detect errors
Workspace Object in VBA
Initializing a Workspace with DBEngine
Starting a Transaction with BeginTrans 
Committing a Transaction with CommitTrans
Rolling Back a Transaction with Rollback
Ensuring Transactions are All-or-Nothing
Execute vs RunSQL differences
Inserting a record with CurrentDB.Execute
Simple error handling with On Error
Managing Database object to reduce overhead

02. Transactions Part 2 (9:37)
Add Order
Add Multiple Items
If One Item Fails the Entire Order Fails
Preventing duplicate items in orders
Rolling back transactions on failure
Ensuring transaction integrity
Transactions with orders in VBA
Use of composite keys in tables
Setting up a composite key
Unique index with multiple fields
Using record sets with transactions
Creating an order in VBA
Inserting items into order detail table
Accessing and using order IDs
VBA SQL insert statements
Debugging transaction code
Understanding transaction rollback

03. Dynamic Temp Tables (24:25)
Problem: Slow Linked Read-Only Tables
Make Function to Create Temp Table
Pull Down Required Records
Form Loads Much Faster
Creating temporary tables for accessing read-only data
Implementing a function to handle table agnosticism
Using temporary tables to solve slow form load issues
Creating temp tables for faster combo box loading
Applying a table def to loop through field collections
Executing SQL queries for record insertion
Handling "allow zero length" attribute for text fields
Appending fields and tables to a database
Deleting and creating temp tables dynamically
Utilizing optional where clause for record filtering
Form load event to refresh temp data
Debugging and compiling VBA code for temp table

04. Drop-In Navigation Subform (24:41)
Create Custom Navigation Buttons
Record 1 of 30 Display Box
Recordset.AbsolutePosition
Move to a Drop-In Subform
Use on Any Parent Form with Ease!
Using form recordset properties
Displaying current record position
Updating record indicators with absolute position
Form load event for accurate record count
Handling record navigation errors
Switching from Me to Parent in code
Binding and linking of forms via properties
Simulating subform events with linked fields
Dynamic background color matching with parent
Handling specific VBA code for new records