Access 2013 Expert

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed to for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Course Outline:

Module One: Getting Started
• Housekeeping Items
• The Parking Lot
• Pre-Assignment Review
• Parking Lot
• Workshop Objectives
• Action Plans

Module Two: Customizing Apps (I)
• Creating a Custom App from Scratch
• Adding a Template Table
• Adding a Blank Table
• Importing Access 2010 Tables
• Module Two: Review Questions

Module Three: Customizing Apps (II)
• About Custom Actions
• Adding a Custom Actin
• Editing a Custom Action
• Deleting a Custom Action
• Module Three: Review Questions

Module Four: Customizing Apps (III)
• About User Interface Macros
• Creating an Embedded Macro
• Creating a Standalone macro
• Saving Your App as a Package
• Module Four: Review Questions

Module Five: Working with Validation Rules and Messages
• Creating a Field Validation Rule
• Creating a Field Validation Message
• Creating a Validation Rule
• Creating a Validation Message
• Testing Validation Rules
• Module Five: Review Questions

Module Six: Working with Macros
• Creating a Before Change Event
• Working with the Macro Tools Design Tab
• Working with the Action Catalog
• Creating an After Event
• Creating a Named Macro
• Renaming or Deleting Macros
• Module Six: Review Questions

Module Seven: Advanced Query Tasks
• Using Query Design View
• Creating Ad Hoc Relationships
• Creating an Update Query
• Creating a Parameter Query
• Comparing Two Tables by Using a Join
• Module Seven: Review Questions

Module Eight: Designing Forms
• Common Formatting Tasks
• Using Themes
• Working with Controls
• Adding Header and Footer Elements
• Arranging Form Elements
• Formatting Forms
• Module Eight: Review Questions

Module Nine: Advanced Reporting Tasks
• Using Report Sections
• Using Conditional Formatting
• Grouping and Sorting Data
• Adding Calculated Controls
• Creating Labels
• Module Nine: Review questions


Module Ten: Advanced Database Tools
• Using the Database Documenter
• Analyzing Table Performance
• Analyzing Database Performance
• Repairing a Database
• Compacting a Database
• Module Ten: Review Questions

Module Eleven: Working with the Access Environment
• Working with Database Properties
• Encrypting a Database with a Password
• Using Save Object As
• Setting Access Options
• Module Eleven: Review Questions

Module Twelve: Wrapping Up
• Words from the Wise
• Review of Parking Lot

Previous

Next