Here's $10 towards your first class. Join for free

Discover Classes. Earn Rewards.

Microsoft Access 2010 Level 2

The Career Center »
4 seats left
Start date: Tue, Dec 08 9:00am - 5:00pm
Next start dates (5)
Location: Murray Hill, Manhattan
185 Madison Ave Ste 1104
Btwn E 34th & 35th Streets
New York, New York 10016 (Map)

No Booking Fees!

Saved 1 Time

Benefits of Booking through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 2290 points. Points give you money off your next class!

Class Information

  • Class Level: Intermediate
  • Age Requirements: 18 and older
  • Average Class Size: 7

What you'll learn in this access training:

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.

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:
  • Microsoft Access Level 1 2010
The Course Curriculum for Microsoft Access 2010 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

Refund & Cancellation Policy

  • No charge for substituting students at any time.
  • Students are eligible for a free retake within 12 months, contingent on class running and available seating
  • No refund or rescheduling permitted within 2 business days of start of class.

Start Dates (6)

Start Date # of Sessions Price
1 $229 Book
1 $229 Book
1 $229 Book
1 $229 Book
1 $229 Book
1 $229 Book

Tue, Dec 08 9:00am - 5:00pm

Murray Hill, Manhattan
185 Madison Ave Ste 1104
Btwn E 34th & 35th Streets
New York, New York 10016



Google Map
The Career Center
Murray Hill, Manhattan
185 Madison Ave Ste 1104
Btwn E 34th & 35th Streets
New York, New York 10016

All classes at this location
We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square.

Questions about this class?

Get help now from a knowledgeable expert!

School: The Career Center

The Career Center has been advancing computer skills for individuals in the heart of New York City since 1988. With the latest technology, a bonded T5 Internet connection and digital projection systems, our clients have the tools to create the ultimate training experience.

Our quality instructors are...

Read more about The Career Center »

CourseHorse Approved School

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?

Book Online

Taking this class for work? Get exclusive perks & discounts for free.

Need help finding a class? Contact us!
Need help? Contact us!