Discover Classes. Earn Rewards.

Access 2007 - Level 2 is unfortunately unavailable

Thankfully we have 13 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.

Microsoft Access Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY

Elevate your proficiency in Microsoft Access and boost your productivity in organizing and analyzing data effectively with this comprehensive course.

(372) All levels 18 and older
$499

2 sessions

Gift it!

Microsoft Access Level I

Noble Desktop @ 185 Madison Ave, New York, NY

Master the basics of relational database management with this course at Noble Desktop. Learn to create databases, build tables, design forms, generate reports, and more in Microsoft Access.

(372) Beginner 18 and older

Microsoft Access Level II

Noble Desktop @ 185 Madison Ave, New York, NY

Take your Microsoft Access skills to the next level with advanced lessons on data validation, relational databases, and advanced reporting techniques in this course at Noble Desktop. Increase your efficiency and workflow by learning how to code advanced queries and improve table structure.

(372) Intermediate 18 and older

Microsoft Access Bootcamp

NYIM Training @ 185 Madison Ave, New York, NY & Virtually Online

Master the ins and outs of Microsoft Access and take your skills to the next level with this intensive 2-day course. From navigating the Access environment to creating custom reports, this bootcamp will equip you with the knowledge and techniques needed to excel in this powerful database management system.

(742) Beginner 18 and older
$499

2 sessions

Gift it!

Microsoft Access Level I

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Master the fundamentals of managing large datasets, creating databases, designing forms, and generating reports with Microsoft Access at NYC Career Centers.

(680) Beginner 18 and older
See all Access classes NYC

Access 2007 - Level 2

  • Intermediate
  • 18 and older
  • $590
  • 462 Seventh Ave, New York, NY
  • over 2 sessions

Start Dates (0)

  • $590
  • New Horizons Computer Learning Center @ 462 Seventh Ave 6th Flr, New York, NY 10018
  • over 2 sessions
  • These classes sell out faster than we update our systems. Enroll and we'll confirm your spot.
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, maiking effective use of forms and reports, and also by performing maintenance.

Who Should Attend
This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access™ 2007, and it is a prerequisite to take more advanced courses in Microsoft® Office Access™ 2007.

Prerequisite(s) or equivalent knowledge
Access 2007 - Level 1

Outline

Lesson 1: Structuring Existing Data 
  •   Analyze Tables 
  •   Create a Junction Table 
  •   Improve Table Structure 
Lesson 2: Writing Advanced Queries 
  •   Create Subqueries 
  •   Create Unmatched and Duplicate Queries 
  •   Group and Summarize Records Using Criteria 
  •   Summarize Data Using a Crosstab Query 
  •   Create a PivotTable and a PivotChart 
Lesson 3: Simplifying Tasks with Macros 
  •   Create a Macro 
  •   Attach a Macro 
  •   Restrict Records Using a Condition 
  •   Validate Data Using a Macro 
  •   Automate Data Entry Using a Macro 
Lesson 4: Making Effective Use of Forms 
  •   Display a Calendar on a Form 
  •   Organize Information with Tab Pages 
  •   Display a Summary of Data in a Form 
Lesson 5: Making Reports More Effective 
  •   Include a Chart in a Report 
  •   Print Data in Columns 
  •   Cancel Printing of a Blank Report 
  •   Create a Report Snapshot 
Lesson 6: Maintaining an Access Database 
  •   Link Tables to External Data Sources
  •   Manage a Database
  •   Determine Object Dependency
  •   Document a Database
  • Analyze the Performance of a Database

Note: There are PC computers at location for students to use.

Refund Policy

Please notify us at [email protected]

  • 7 or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes.
  • 12 or more business days for technical classes.
You will receive a 95% refund if you cancel according to the terms above for applications and technical classes.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at New Horizons Computer Learning (8)

Similar Classes

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 5900 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Computer Learning

As part of the largest independent IT Training Provider, New Horizons Computer Learning Center delivers more courses than any other IT training company.

Innovative and Flexible Learning Methods

New Horizons New York City understands that not everyone is the same, and we have developed a variety of innovative...

Read more about New Horizons Computer Learning

CourseHorse Approved

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

New Horizons Computer Learning

New Horizons Computer Learning

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...