Microsoft Access 2010


The participant will learn different skills using Access 2010.


The public




4 days (30 hours)



Office Workspace Basics

  • Basic Window Elements
  • Exploring Microsoft Office Backstage
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Working with KeyTips
  • Using the Status Bar
  • Getting Help

Introduction to Access

  • What is an Access Database
  • Opening a Database File
  • Exploring Database Objects
  • Creating a Database
  • Changing Views
  • Printing Database Objects
  • Saving and Closing a Database File


Working with Tables

  • What is a Table?
  • Working with Datasheets
  • Moving Among Records
  • Updating Records
  • Adding Records to a Table
  • Selecting Rows and Columns
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Using the PivotChart View
  • Saving and Closing a Table


Designing Tables

  • Adding a Table to a Database
  • Adding Fields to a Table
  • Adding a Lookup Field
  • Setting a Primary Key
  • Using the Input Mask Wizard
  • Saving Design Changes
  • Importing Data
  • Exporting Data
  • Performing Database Maintenance

Creating and Running Queries

  • What is a Query?
  • Creating a Query
  • Working with Queries
  • Saving and Running a Query
  • Creating Calculated Fields
  • Using Agregate Functions
  • Understanding Query Properties
  • Creating Multi-Table Select Queries
  • Joining Tables
  • Enforcing Referential Integrity


Using Forms

  • What is a Form?
  • Using the Form Tool
  • Creating a Form with the Form Wizard
  • Working in Design View
  • Changing the Form Layout
  • Using Calculated Controls
  • Working with Records on a Form


Generating Reports 

  • What is a Report
  • What is a Report Tool
  • Previewing and Printing a Report
  • Saving a Report
  • Designing a Report
  • Changing a Report Layout
  • Understanding Controls
  • Using a Calculated Control
  • Analyzing Dependencies
  • Creating Mailing Labels