Access Advanced Training Course

Smarter Forms

When you design a form based on joined tables, imagine a scenario where you want to see both customer details and their orders in one place. You can create a query that joins the Customers and Orders tables, then build a form on that query. The top section of the form might show the customer’s name, phone, and address, while the lower section lists all orders they’ve placed. This makes navigation intuitive and avoids switching between multiple forms.

Automating data entry can be achieved by setting default values or using combo boxes that pull data from related tables. For example, when entering a new order, selecting a customer ID from a combo box can automatically fill in their address and contact details. This reduces typing errors and speeds up entry.

Grouped controls are useful when you want to visually separate related information. For instance, you can place all shipping-related fields inside a frame labeled “Shipping Information.” This not only organizes the form but also allows you to apply formatting to the entire group at once.

Macro Power

Macros in Access are like small programs that automate tasks. You can create a macro to open a form automatically when the database starts, such as opening the “Orders” form. Macros can also be attached to events. For example, a button labeled “Add Order” can have an OnClick macro that opens the order entry form. This makes the database interactive without requiring VBA code.

Creating Advanced Macros

Advanced macros allow for user interaction. A macro can display a message box asking “Do you want to save changes?” before closing a form. Depending on the user’s choice, the macro either saves the record or cancels the action.

AutoKeys macros let you assign keyboard shortcuts. For example, pressing Ctrl+M could open the main menu form. AutoExec macros run automatically when the database opens, such as loading a startup dashboard or checking for updates. These features make the database feel like a custom application.