185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Access Level 2 2010
Microsoft Access Level 2 2010

Course Code: GK | Hours: 8

Our public class schedule has upgraded. Please contact us at (212) 684-5151 or Info@CareerCenters.com to inquire about private tutoring or corporate classes. To view the offerings for current versions, see the links below.

Microsoft Access Level 2 2010 Training Overview

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft Access.

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

  • streamline data entry and maintain data integrity
  • join tables to retrieve data from unrelated tables
  • create flexible queries to display specified records, allow for user-determined query criteria
  • modify data using queries and improve forms
  • customize reports to organize the displayed information and produce specific print layouts
  • share data between Access and other applications

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Microsoft Access Training Outline - Level 2

Lesson 1: Controlling Data Entry

• Topic 1A: Constrain Data Entry Using Field Properties
• Topic 1B: Establish Data Entry Formats for Entering Field Values
• Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

• Topic 2A: Create Query Joins
• Topic 2B: Join Tables with No Common Fields
• Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

• Topic 3A: Set the Select Query Properties
• Topic 3B: Retrieve Records Based on Input Criteria
• Topic 3C: Create Action Queries

Lesson 4: Improving Forms

• Topic 4A: Create a PivotTable Report
• Topic 4B: Filter Data Using Slicers
• Topic 4C: Analyze Data Using PivotCharts

Lesson 5: Customizing Reports

• Topic 5A: Organize Report Information
• Topic 5B: Format Reports
• Topic 5C: Control Report Pagination
• Topic 5D: Summarize Report Information
• Topic 5E: Add a Subreport to an Existing Report
• Topic 5F: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

• Topic 6A: Import Data into Access
• Topic 6B: Export Data to Text File Formats
• Topic 6C: Export Access Data to Excel
• Topic 6D: Create a Mail Merge