Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love


Microsoft Access 2010 Level 1 Data Entry and Reports

Course Details
Code: 8253
Tuition (USD): $275.00 $247.50 • Classroom (1 day)

In this course with hands-on labs, you will become familiar with introductory features and functionality relating to Microsoft Access 2010 databases.

Skills Gained

  • Components of a database and how to work with those components
  • Open a table, find information stored there, and enter data
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports, and print preview reports.
  • Preview and print database objects, and change the page setup options

Who Can Benefit

Those who are new to Microsoft Access 2010

Course Details

1. The Basics

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access 2010 Files
  • Working with Objects
  • Using Access Help
  • Review Exercise

2. Table Data

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters
  • Review Exercise

3. Queries

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries
  • Review Exercise

4. Reports

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes
  • Review Exercise

5. Printing

  • Printing Objects
  • Print Preview
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward