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.

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 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.

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.

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.