Discover Classes. Earn 10% Rewards.

Access 2007 - Level 2 is unfortunately unavailable

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

Microsoft Outlook Level I

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Learn to manage emails, appointments, and tasks efficiently in Microsoft Outlook. Stay ahead of the curve through this industry-standard training program.

(453) Beginner 18 and older

Complete Microsoft Office Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Get fluent in the Microsoft Office suite through in-depth classes in Excel, PowerPoint, Word, and Outlook at Noble Desktop. Build the skills you need to thrive at work and stand out from peers. Lift your productivity through this comprehensive bootcamp.

(453) All levels 18 and older
$1,725

9 sessions

Gift it!

Microsoft Office Fundamentals Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Get fluent in the essential Microsoft Office programs through this beginner-friendly program. Build proficiency in Excel, PowerPoint, Word, and Outlook in just 4 days. Lift your productivity and efficiency on the job.

(453) All levels 18 and older
$749

4 sessions

Gift it!

Microsoft Master Certification Program with Access

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Get certified in Microsoft Excel, PowerPoint, Word, and Access with this comprehensive program offering group classes, private training, exams, free retakes, study guides, and flexible scheduling. Earn digital and physical certificates in just weeks.

(453) All levels 18 and older
$2,799

9 sessions

Gift it!

Microsoft Outlook Level I

NYC Career Centers See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Build the essential features of Microsoft Outlook through this comprehensive course. Learn how to manage your email, calendar, tasks, and contacts effectively. Lift your productivity and take control of your inbox with Outlook Level I.

(686) Beginner 18 and older
See all Microsoft Office classes NYC
  • Intermediate
  • 18 and older
  • Earn 10% back in points
  • Price Lock

    If you find the same class on the same dates for less within 48 hours of booking, send us the link. We match the price as credit or the difference.

  • 462 Seventh Ave, New York, NY
  • over 2 sessions

Start Dates (0) $590/person

  • These classes sell out faster than we update our systems. Enroll and we'll confirm your spot.

No upcoming dates are currently available.

Book a Private Group Event

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

Or see all Professional Group Events

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

Class Description

Description

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)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • No booking fees. You pay the school's price, with nothing added at checkout.
  • Price Lock. If you find the same class on the same dates for less within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 5900 points. Earn 10% back in points. 100 points = $1 off a later class.

New Horizons Computer Learning

New Horizons Computer Learning Center, part of the world’s largest independent IT training provider, offers flexible learning options from instructor-led and online courses to customized corporate training. With programs ranging from Microsoft Office to advanced Cisco and Citrix certifications, New Horizons equips individuals, businesses, and government agencies with the skills to succeed in today’s technology-driven world.

View school profile
New Horizons Computer Learning
Vetted by CourseHorse

A verified NYC educator.

Loading...