Access 2007 Advanced

Deploy the entire Microsoft Access database as a single file on a shared server to enable multi-user access, then weigh easy deployment against network load and performance trade-offs.

Split the Access 2007 database into a data server and a local interface file, moving tables and data to the server while keeping forms, reports, and queries locally.

Create a database project by moving data from Access to a Microsoft SQL Server enterprise solution, using Access as a conduit to gain speed, integrity, and scalable security.

Explore how Access 2007 automatically creates a subform to show one-to-many relationships between orders and order details, including naming, source, and master and child linking.

Embed a subform into a main form in Access 2007 by changing the subform's source object or dragging a form onto the main form, preserving the master/child link.

Compare dialog boxes with regular forms in Access and learn why a pop-up demands user interaction. Use dialog boxes for login forms, criteria prompts for reports, or viewing employee details.

Learn to create a modal dialog in Access 2007, understand its on-top behavior, and how a dialog box differs from a form, including fixed size and ok and cancel buttons.

Learn how to configure modal dialog and pop up forms in Access 2007 by adjusting caption, border, auto center and resize, and control anchoring.

Master Access 2007 advanced dialog events, including on current, on close, and focus, and apply modal dialogs, events, and embedded macros to control form behavior.

Learn how the option group control in Access 2007 uses a bordered set of radio buttons for a single selection, with labeled options tied to numeric values.

Learn to use the command button in Access 2007 to perform record navigation and form operations, label with text, assign meaningful name, and shortcut keys with ampersand and underscore.

Learn to use a combo box or list box to look up values from a table or query, and set unique values, column counts, and widths to tailor forms.

Learn to build a criteria dialog in Access 2007 that feeds a query and opens a report, with a form featuring a unique category combo box.

Design embedded macros in Access 2007, explore macro types and event-driven automation for forms, queries, and reports, and leverage controls’ properties, methods, and events for modular design.

Create a simple macro in Access 2007 using the macro builder. Use the on click event to open a report with arguments and display a message box.

Create a macro file containing multiple macros to bind actions to a form control, enabling printing customer or employee labels or closing the form when canceled.

Create and manage macro groups in Access 2007 advanced, building standalone macro files, naming actions, and sequencing close, print preview, and report commands for forms and reports.

Create a conditional macro in Access 2007 using an on click event, true/false conditions, and set a control's visible property to show credit cards when the group matches.

Use the stop macro command after the true side of an if statement to halt macro execution. Set visibility of groups to true and continue with a dot dot dot.

Master handling a false condition in Access 2007 Advanced by toggling credit card visibility with macro logic, using zero for false and negative one for true.

Document your access 2007 database as you finalize tables, queries, forms, reports, macros, and controls, using field and macro comments so future developers can upgrade without relearning your design.

Explore the Access 2007 advanced database documenter to generate comprehensive reports on tables, queries, forms, macros, and relationships, and learn to selectively document to control paper usage.

Configure the current database options to auto start, set a custom title and icon, display a switchboard form, and enable compact on close for large databases.

Set a database password to restrict access in Access 2007 advanced, noting the risk of forgotten passwords; document the database and use central server access rights.