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?
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.
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.
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.
Test your Microsoft Access VBA fundamentals with a quick developer-level quiz on variables, duplicate record checks, DLookup, and message box responses.