Discover Classes. Earn 10% Rewards.

Access 2007 - Level 2 is unfortunately unavailable

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

Microsoft Outlook Level II

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

Push your Microsoft Outlook skills further with advanced mail configuration, spam control, task automation, and calendar/contact management. Customize your communication system to match your workflow.

(452) Intermediate 18 and older

Microsoft Office Intermediate Bootcamp

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

Take your Microsoft Office skills further with this immersive bootcamp. Get fluent in Excel, PowerPoint, Word, and Outlook to lift productivity and streamline your workflow. Strengthen your skills in the essential Microsoft Office programs at Noble Desktop.

(452) Intermediate 18 and older
$949

5 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!

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!

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.

(452) Beginner 18 and older
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...