Access 2010 Essentials

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. The participants will learn how to use the basic features of Access 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
Access is the world’s premier database software. You can use Access 2010 to create and edit databases — just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

Course Outline:

Module One: Getting Started
• Icebreaker
• Housekeeping Items
• The Parking Lot
• Workshop Objectives

Module Two: Getting Started With Access
• Common Database Terms
• Opening Access
• Understanding the Access New File Screen
• Creating a Blank Access Database
• Creating a Blank Database from a Template

Module Three: Using the Access Interface
• Understanding Security Warnings
• Interface Overview
• Overview of the Ribbon Interface
• Working With the Backstage View
• Using the Navigation Pane

Module Four: Working with Database Objects
• Viewing Database Objects
• Exporting an Object
• Renaming an Object
• Sorting and Filtering Your View
• Understanding Application Parts

Module Five: Creating Tables
• Understanding Data Types
• Creating a Blank Table in Datasheet View
• Understanding Lookup Columns
• Creating a Blank Table using Design View
• Saving Your Table
• Key Table Tools

Module Six: Working with Tables
• Adding Information to a Table
• Editing Records
• Deleting Records
• Searching for Records

Module Seven: Creating Forms
• Types of Controls
• Creating a Form with the Wizard
• Creating a Form in Layout View
• Modifying Your Form in Design View
• Key Features on the Form Tools Tab
• Creating a Navigation Form

Module Eight: Working with Forms
• Common Formatting Tasks
• Using Themes
• Adding Controls
• Moving Controls
• Deleting Records

Module Nine: Creating Reports
• Using the Report Wizard
• Using Design View
• Adding a Logo
• Working with Controls
• Key Features on the Report Tools Tab

Module Ten: Creating Queries
• Types of Queries
• Creating a Query with the Wizard
• Executing a Query
• Viewing the Query
• Key Features on the Query Tools Tab

Module Eleven: Managing Your Database
• Using Alternate File Formats
• Printing an Object
• Backing Up Your Database
• Emailing Database Objects

Module Twelve: Wrapping Up
• Words from the Wise
• Review of Parking Lot
• Lessons Learned
• Completion of Action Plans and Evaluations