Computer Learning Zone

Richard Rost is a Microsoft MVP and President/CEO of Computer Learning Zone. He creates video tutorials to teach you how to use your computer, specializing in Microsoft Access.

Can Your Microsoft Access Database Run Without You?

What happens when the person who built the database is unavailable for a week? Can employees still enter data, run reports, recover from common mistakes, and keep routine processes moving without calling the developer for help?

11-17
09:36

Microsoft Access Form Totals and Inventory Value Quiz

Test your Microsoft Access form calculation skills with a quick expert-level quiz on totals, aggregate functions, and inventory value. This episode covers where footer totals belong in continuous forms and subforms, along with the practical differences between Sum, Count, and Max.

11-16
03:01

Fixing Wrong Combo Box Selections in Microsoft Access UNION Queries

When a Microsoft Access combo box is populated by a UNION query, it can appear to work perfectly until selecting one item suddenly displays another. The usual culprit is a duplicate numeric ID coming from different tables, such as Employee ID 15 and Customer ID 15.This episode explains why AutoNumber values are unique only within their own tables, not across a combined query result. When a combo box binds to the shared number alone, Access cannot tell which source record was actually selected.Learn how a simple prefixed selector value, such as E15 and C15, prevents these ID collisions without changing the underlying tables. The discussion also covers a real example involving foods and meals, plus what to consider when VBA code needs to determine which source table the selected item belongs to.

11-15
11:06

Why Computers Get Decimal Math Wrong: Floating Point Explained

Why can 0.1 plus 0.2 sometimes produce 0.30000000000000004? Computers are not forgetting basic arithmetic. They are working with finite binary approximations of decimal values that cannot always be represented exactly.

11-15
14:52

Microsoft Access VBA Quiz: DLookup Nulls, Long Variables, and Duplicate Checks

Test your Microsoft Access VBA fundamentals with a quick developer-level quiz on variables, duplicate record checks, DLookup, and message box responses.

11-15
03:17

Recommend Channels