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.

Explore four access architectures, including web databases with SharePoint 2010 and integrated multi-user deployment. Compare single-file, split-database, and SQL Server–backed designs, and understand when to choose web database solutions.

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.

Discover how to create a crosstab query in Access to rotate long data into a wide, summarized pivot view by product and by month or quarter using the wizard.

Learn to use access functions inside queries to format text with left, concatenate fields, and handle missing data with immediate if and is null.

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.

Learn to create calculated controls in Access 2010 Advanced, including grand totals and item counts, using unbound text boxes, the sum and count functions, and subform references.

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.

Document and organize an Access database with the database document tool, selecting object types and options; then split to back-end data and front-end interface, reconnect data via linked table manager.

Set a password to encrypt your Access database and learn how to open it in exclusive mode to apply or remove the password, ensuring data remains inaccessible without it.

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.

Explore advanced features in Microsoft Access, design your data architecture, use table data macros, run crosstab queries and charts in reports, and automate with macros toward a secure, shareable application.