Discover Classes. Earn 10% Rewards.

Access 2007 - Level 2 is unfortunately unavailable

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

Microsoft Excel Bootcamp

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

Achieve a comprehensive command of Microsoft Excel in this focused, three-day bootcamp. Working from foundational skills through advanced spreadsheet techniques and macro-based automation, you'll develop the depth and fluency needed to handle virtually any data task. An intensive and effective path to becoming a confident, capable Excel user.

(686) All levels 18 and older
$599

6 sessions

Gift it!

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.

(452) 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.

(452) All levels 18 and older
$749

4 sessions

Gift it!

Outlook Bootcamp

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

Build expertise across Microsoft Outlook, from contact creation to calendar management, through this comprehensive course. Lift your productivity and streamline your email and scheduling tasks with personalized customization and efficient automation. Push your Outlook skills further and become a pro at managing your inbox and staying organized.

(452) All levels 18 and older
$549

2 sessions

Gift it!

Microsoft Master Certification Program with Outlook

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

Earn certified expert status across the Microsoft Office suite through comprehensive training and exams in Excel, PowerPoint, Word, and Outlook. Strengthen your skills through group classes, private training, and exams. Lift your career through the Microsoft Master Certification Program.

(452) All levels 18 and older
$2,599

8 sessions

Gift it!
See all Microsoft Office classes NYC
  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 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.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 5900 points. Earn 10% back in reward points!

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...