Call

Microsoft® Access® 2010: Level 1

< Back to Main Page

Duration:

1 Day (6.5 instructional hours)

Access 2010

Course Number: 091001


Course Objective:

You will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Target Student:

This course is intended for students who wish to establish a foundational understanding of Microsoft Office Access 2010, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Course Objective:

To ensure success, students will need to be familiar with using or have equivalent knowledge of Microsoft® Windows® 7: Level 1 and Introduction to Personal Computers Using Windows® 7.


Course Outline

Lesson 1: Getting Started with AccessTopic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access


Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Topic C: Create Lookups


Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query


Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Unmatched and Duplicate Queries

Topic D: Summarize Data


Lesson 5: Generating Reports

Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report Topic D: Prepare a Report for Print


Lesson 6: Managing Workbooks

Topic A: The Access Options Dialog Box