Access 2010 Fundamentals - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Navigate within the Access environment and create a simple database
  • Organize and manage data stored within Access tables
  • Use queries to join, sort, and filter data from different tables
  • Create advanced queries
  • Create and format custom reports
  • Customize Access configuration options

Course Content

Lesson 1: Getting Started with Access 

  1. Orientation to Microsoft Access
  2. Create a simple Access Database
  3. Get help in Microsoft Access

Lesson 2: Working with Table Data

  1. Modify Table Data
  2. Sort and Filter Records
  3. Create Lookups

Lesson 3: Querying a Database

  1. Join Data from Different Tables in a Query
  2. Sort and Filter Data in a Query
  3. Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  1. Create Parameter Queries
  2. Create Action Queries
  3. Create Unmatched and Duplicate Queries
  4. Summarize Data

Lesson 5: Generating Reports

  1. Create a Report
  2. Add Controls to a Report
  3. Enhance the Appearance of a Report
  4. Prepare a Report for Print

Lesson 6: Customizing the Access Environment

  1. The Access Options Dialog Box

Appendix A: Microsoft Office Access 2010 Exam 77–885
Appendix B: Microsoft Office Access 2010 Common Keyboard Shortcuts 

If you would like to customize this class, please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!