Workshop 8: Access VBA, Design and Advanced Methods

Create an add or go combo box on customer form, with row source from customer table, showing company, contact, and city state zip, and prompting to add a new record.

Use the after update event in VBA to add a missing company. Enable event procedures, prompt with a message box, and place the cursor at the end for quick entry.

Add the go part to the VBA subroutine by using a do command to search the record where const id equals the selected company in column three. Adjust navigation.

Master cascading combo boxes in Access using two techniques, build state, city, and zip filters with query builder, unique values, and after update events to refresh dependent controls.

Implement cascading combos in Access to filter data by state, city, and zip using VBA. Learn to reset filters with after update events and dynamic query building.

Explore how to integrate Excel's network days function into Access forms, handling holidays with arrays and date pickers, and learn the VBA code behind calling worksheet functions.

Explore the remaining date functions, including end of month, work days, and year fraction, and learn to reuse these VBA utilities by moving them into a module.

Learn to create and customize buttons in Access forms using quick steps: set background color, add a gradient, bevels, shadows, and shape effects, then save a reusable menu design.

Learn to build lightweight forms in Access VBA to speed up opening menus, using hyperlink addresses to open the customer and orders forms.

Fix tabbing in Access forms by setting tab order, disabling tab stops on subforms and buttons, and using keydown VBA to move focus with tab and shift tab.

demonstrates a finished access database design by building a quantity price system within an orders form and subform, emphasizing planning table structures and a simple, scalable unit pricing approach.

Demonstrate automatic total updates by editing quantities in a subform linked to a quantity list, with locked unit prices and immediate subtotal and order total refresh.

Build an Access query that emulates Excel's Vlookup by finding the closest lower quantity using less than or equal to criteria, sorting descending, and returning the corresponding unit price.

Learn to implement an afterupdate subroutine in access vba. Create and test a query with real values, then update the order unit price from a subform using a recordset.

Learn to make delete and exit buttons work in Access forms by confirming deletions, recalculating and removing records, refreshing the form, and properly naming controls.

Recap building an ad or go box to view customer records and cascading combo boxes to filter data, plus integrating Excel data functions in Access.