Certificate In Access 2010 Essentials Online Course

Module One: Getting Started

• Course Objectives

Module Two: Getting Started With Access

• Lesson One: Common Database Terms
• Lesson Two: Opening Access
• Lesson Three: Understanding the Access New File Screen
• Lesson Four: Creating a Blank Access Database
• Lesson Five: Creating a Blank Database from a Template

Module Three: Using the Access Interface

• Lesson One: Understanding Security Warnings
• Lesson Two: Interface Overview
• Lesson Three: Overview of the Ribbon Interface
• Lesson Four: Working With the Backstage View
• Lesson Five: Using the Navigation Pane

Module Four: Working with Database Objects

• Lesson One: Viewing Database Objects
• Lesson Two: Exporting an Object
• Lesson Three: Renaming an Object
• Lesson Four: Sorting and Filtering Your View
• Lesson Five: Understanding Application Parts

Module Five: Creating Tables

• Lesson One: Understanding Data Types
• Lesson Two: Creating a Blank Table in Datasheet View
• Lesson Three: Understanding Lookup Columns
• Lesson Four: Creating a Blank Table Using Design View
• Lesson Five: Saving Your Table
• Lesson Six: Key Table Tools

Module Six: Working with Tables

• Lesson One: Adding Information to a Table
• Lesson Two: Editing Records
• Lesson Three: Deleting Records
• Lesson Four: Searching for Records

Module Seven: Creating Forms

• Lesson One: Types of Controls
• Lesson Two: Creating a Form with the Wizard
• Lesson Three: Creating a Form in Layout View
• Lesson Four: Modifying Your Form in Design View
• Lesson Five: Key Features on the Form Tools Tab
• Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

• Lesson One: Common Formatting Tasks
• Lesson Two: Using Themes
• Lesson Three: Adding Controls
• Lesson Four: Moving Controls
• Lesson Five: Deleting Records

Module Nine: Creating Reports

• Lesson One: Using The Report Wizard
• Lesson Two: Using Design View
• Lesson Three: Adding a Logo
• Lesson Four: Working with Controls
• Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

• Lesson One: Types of Queries
• Lesson Two: Creating a Query with the Wizard
• Lesson Three: Executing a Query
• Lesson Four: Viewing the Query
• Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

• Lesson One: Using Alternate File Formats
• Lesson Two: Printing an Object
• Lesson Three: Backing Up Your Database
• Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up
Words from the Wise

• Store your data using Access tables.
• Use forms to easily manage data collection tasks of adding, changing or deleting data one record at a time.
• Create queries to see subsets of your data or to perform actions to your data.
• Use reports to view table or query data in a polished format.