Skills Training in Microsoft Access 2010

This training provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.

Topics

Topics covered in this training include:

• Database Basics

• Creating a Database

• Defining a Primary Key

• Creating Datasheet Relationships

• Creating a Complex Query

• Using Lookup Fields

• Creating and Editing a Query in SQL View

• Creating a Report

• Creating Pivot Objects

• Creating and Editing a Macro

• Handling Errors in a Macro

• Creating and Editing a Module

• Packaging a Database

• Sharing a Database

Program

Module 1: Course 10382: Beginner Skills in Microsoft Access 2010

Students will be able to:

1) Create and edit a database.

2) Create and use a query.

3) Create and edit a report.

4) Create and edit a form.

1) Creating and Editing a Database

Introduction

Exploring the Access 2010 Interface

Database Basics

Reviewing Access 2010 Fundamentals

Creating a Database

Viewing a Database

Importing and Exporting Data

Editing and Formatting Table Data

Creating and Managing Indexes

Creating an Events Database

Self Test

2)Creating and Using a Query

Introduction

Creating a Query by Using Query Wizard

Creating an Expression by Using Expression Builder

Creating a Criteria-Based Query

Performing Calculations by Using a Query

Creating a Query

Self Test

3)Working with a Report

Introduction

Creating a Report

Creating a Label

Grouping and Sorting Data in a Report

Performing Calculations in a Report

Creating and Editing a Report

Self Test

4)Creating and Editing a Form

Introduction

Creating a Form by Using Form Wizard

Creating a Form by Using the Form Tool

Editing a Form in Design View

Creating a Form

Self Test

Module 2: Course 10383: Intermediate Skills in Microsoft Access 2010

Students will be able to:

1)Modify a database

2)Create complex queries to extract and process specific information

1)Modifying a Database

Introduction

Creating a Table

Modifying a Table

Defining a Primary Key

Reviewing Table Fundamentals

Creating Datasheet Relationships

Validating Data in a Table

Using Lookup Fields

Creating a Default Database Template

Compacting a Database

Editing a Database

Self Test

2)Working with Complex Queries

Introduction

Creating a Complex Query

Creating a Totals Query

Creating and Editing a Query in SQL View

Creating Pivot Objects

Creating and Editing Complex Queries

Self Test

Module 3: Course 10384: Advanced Skills in Microsoft Access 2010

Students will be able to:

1)Create programmed elements to automate tasks and add functionality to database objects and controls.

2)Share and distribute database information.

1)Creating Programmed Elements

Introduction

Exploring the Macro Environment

Creating and Editing a Macro

Creating an Embedded Macro

Handling Errors in a Macro

Creating and Editing a Module

Creating a Macro

Self Test

2)Sharing Database Information

Introduction

Creating an Execute-Only Database

Encrypting a Database

Using the Access 2010 Runtime Program

Packaging a Database

Synchronizing a Database with a SharePoint List

Importing Data from and Exporting Data to SharePoint Lists

Sharing a Database

Self Test