Computer Learning Zone

In part two of this Microsoft Access inventory database series, learn how to connect locations, areas, subdivisions, and items with proper one-to-many relationships and referential integrity. The focus is on keeping inventory data organized so items cannot be assigned to locations that do not exist, while avoiding the risks of cascade deletes.

Ever put something away safely, then spend six months wondering where it went? This episode introduces a practical Microsoft Access database design for tracking where books, tools, equipment, supplies, and storage boxes are located.

VB, VBA, VB.NET, VBScript, and VB6 share a family resemblance, but they are not interchangeable. The key question is not which version sounds newest, but where the code runs and which objects, libraries, and runtime it depends on.For Microsoft Access developers, the answer is VBA, or Visual Basic for Applications. Learn why Access VBA examples differ from Excel VBA, why old VB6 projects are different from modern Visual Basic on .NET, and why similar syntax can still lead you toward the wrong help or code samples.This episode also covers VBScript's aging role in Windows automation, Microsoft's plans to phase it out, and why inherited VBS files need a different maintenance plan. Whether you are writing code behind an Access form, maintaining a VB6 application, or working in Visual Studio, knowing the branch of Visual Basic you are using matters.

Can Microsoft Access hide password characters typed into a standard InputBox? This quick quiz explores why the built-in InputBox cannot display asterisks and why a custom form with a password-masked text box is the better choice when users need a more polished password prompt.Along the way, it covers practical Access macro design: keeping shared passwords in a settings table, using DLookup criteria to retrieve the correct value, and making sure OpenForm runs only after the entered password matches the expected one.It also includes an important security reality check. A password prompt can protect a menu path, but it does not secure every route into a database, especially when a plain-text password remains accessible in a table or the database design.

Learn how Microsoft Access QueryDefs let VBA create and save queries dynamically instead of forcing you to maintain a separate query for every possible field combination.