Access 2007 Essentials

This workshop is designed to teach you a basic understanding of Access 2007 in a practical way. The participants will learn how to use the features of Access to help them better manage a database. 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.
This workshop is meant to provide a safe learning environment where they can practice and learn Access 2007 Essentials functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn about the features of Access 2007 will increase their knowledge on how databases work and make creating and managing an Access 2007 database easier for everyone.

Course Outline:

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

Module Two: Opening Access
• Common Database Terms
• Opening Access
• Understanding the Getting Started Window
• Creating a Blank Database from a Template

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

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

Module Five: Creating Tables
• Creating a Blank Table in Datasheet View
• Creating a Blank Table from a Template
• Understanding Data Types
• 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

Module Eight: Working with Forms
• Common Formatting Tasks
• Using AutoFormat
• 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
• Query Views
• Key Features on the Query Tools Tab

Module Eleven: Managing Your Database
• Understanding Access File Formats
• Printing an Object
• Backing Up Your Database
• Emailing Your Database

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