Access 2010 Advanced

Learn to design rock-solid Access tables, implement macros for business rules, and convert macros to VBA as you navigate three development phases.

Explore four access 2010 architectures: the entire database on the server, a split database, a database project with Microsoft SQL Server, and a web database with SharePoint.

Put your entire access database on a server by sharing a network location, enabling updates and access control, but increase network load and risk data conflicts when updating copies.

Split the access database to separate data from the interface, moving data to a server with linked tables to speed access and maintain security, while noting deployment challenges.

Discover how a database project upgrades Access to sit on SQL Server, turning your interface into an enterprise database solution with fast stored procedures and wizards for forms.

Use data macros in access 2010 to fire on table events and automate quantity-based discounts. Learn to create event-driven macros and inspect the event log on the orders details table.

Explore event-driven data macros in Access 2010 advanced, using before change and after insert, update, and delete events to automate discount logic based on quantity.

Access 2010 data macros track old and new values on record changes and post to the application log after updates, enabling before and after actions with validation.

Master left and right outer joins in Access to include all records from a table with related data, compare to inner joins, and resolve ambiguous outer joins, plus crosstab basics.

Create an auto fill form in access 2010 advanced to automatically populate related customer details when selecting a customer, without coding, and allow edits that sync back to the tables.

Learn how to use forms and subforms in Access 2010 advanced, driven by related tables, and configure link master and link child fields to display accurate detail data.

Use the tab control to organize a long order form into customer detail, shipping, and payment tabs, so most information fits on one screen and tab order guides navigation.

Explore the option group control in Access 2010 Advanced: configure borders with radio buttons, set a default, and return numeric values to drive form behavior.

Explore the three macro types in Access 2010 advanced—embedded, standalone with sub macros, and associated macros—along with events and the macro editor to build reusable automation for forms.

Explore how Access form events drive behavior, from On Current and On Load to On Close and Timer, including focus, dirty state, and testing with macros.

Learn to design Microsoft Access forms with embedded and standalone macros that control credit card visibility and validate credit card number and expiration date using on click and set property.

Learn how to wrap up and distribute an Access database by setting auto start options, startup forms, login screens, securing with a password, and converting to an A.S.C. e-file.

Convert your Access 2010 database to an accde file using save as, advanced, and make accde. Package and sign the file, use the compatibility checker for SharePoint, and enable backup.

Learn how to package a database with the package and deployment option, including runtime downloads and desktop icon creation. Document changes, set startup options, save and publish for distribution.