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