Microsoft Access Inventory Tracking with Flexible One-to-Many Relationships

The Expression Builder can look intimidating at first, especially when Access presents a long list of functions, fields, operators, and database objects. This episode explains what an expression is, what the Builder is designed to do, and when it is helpful to use instead of typing everything by ha…

Test your Microsoft Access form knowledge with five beginner-friendly questions about labels, bound forms, Form View, sensitive fields, and continuous forms. One key issue is what happens after you edit a record and see the pencil icon. In most bound Access forms, moving to another record commits t…

Test your Microsoft Access form and macro knowledge with five advanced questions about preventing edits to paid orders while keeping the rest of the order form usable.

Need one VBA routine to retrieve several related pieces of information, such as a customer's address, city, state, ZIP code, and country? This episode explores a clean Access VBA pattern for doing exactly that without scattering repeated DLookup code throughout your database. Using a Boolean functi…