Access 2010 Expert

Your participants will learn how to use the advanced features of Access 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of Access 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database among other things. By the time your participants finish this course, they will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!

Course Outline:

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

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

Module Three: Working with Access Options (I)
• Setting General Options
• Setting Application Options
• Setting Navigation Options
• Setting Other Database Options
• Setting Datasheet Options
• Module Three: Review Questions

Module Four: Working with Access Options (II)
• Setting Object Designers Options
• Setting Proofing and Language Options
• Setting Client Settings Options
• Customizing the Ribbon
• Customizing the Quick Access Toolbar
• Module Four: Review Questions

Module Five: Tables
• Hiding and Un-hiding Fields
• Freezing and Unfreezing Fields
• Modifying Data types
• Modifying Field Description
• Modifying Field Properties
• Module Five: Review Questions

Module Six: Importing Table Data
• Appending Records to an Existing Table
• Importing Data as a Linked table
• Module Six: Review Questions

Module Seven: Forms
• Creating a Blank Form
• Using Themes
• Using the Form Controls
• Creating a Header and Footer
• Creating a Navigation Form
• Using the Form Design Arrange Tools
• Using a Background Image
• Using Conditional Formatting
• Module Seven: Review Questions

Module Eight: Queries (I)
• Creating a Select Query
• Creating a Make Table Query
• Creating an Append Query
• Creating a Cross tab Query
• Module Eight: Review Questions

Module Nine: Queries (II)
• Using the Show Table Command
• Using the Remove Table Command
• Creating Ad Hoc Relationships
• Using the total Row
• Using Group By
• Performing Calculations
• Using the Expression Builder
• Module Nine: Review Questions

Module Ten: Reports
• Creating a Blank Report
• Creating a Header and Footer
• Using the Property Sheet
• Using the Arrange Tab
• Using the Format Tab
• Using the Page Setup Tab
• Module Ten: Review Questions

Module Eleven: Macros and Code
• Creating a Macro
• Working with the Macro Tools Design Tab
• Working with the Action Catalog
• Creating a Module
• Creating a Class Module
• About Visual Basic
• Module Eleven: Review Questions

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