Access 2007 - Level 2 [Class in NYC] @ New Horizons Computer Learning

Access 2007 - Level 2 is unfortunately unavailable

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

Access Introduction

ONLC Training Centers @ 626 Reckson/RexCorp Plaza, Uniondale, NY & Virtually Online

Unlock the power of data management with Access. Learn to create databases, design forms and reports, and generate queries in Microsoft Office Access. Gain the skills to efficiently collect and manage large amounts of data for your organization.

Beginner 18 and older

May 6th

10am–4:45pm EDT

Meets 2 Times

$695

2 Seats Left

Don't see any dates that work for you?

Add to Wishlist

Mon, May 6th, 10am–4:45pm EDT (13 hours & 30 minutes over 2 sessions)

$695

2 sessions

Attend

+6950 pts

Gift it!

Access Advanced

ONLC Training Centers @ 626 Reckson/RexCorp Plaza, Uniondale, NY

Explore advanced techniques and features to optimize your data organization and reporting capabilities. Elevate your expertise in database management with this specialized training.

Advanced 18 and older

May 8th

10am–4:45pm EDT

Meets 2 Times

$695

2 Seats Left

Don't see any dates that work for you?

Add to Wishlist

Wed, May 8th, 10am–4:45pm EDT (13 hours & 30 minutes over 2 sessions)

$695

2 sessions

Attend

+6950 pts

Gift it!

See all Access classes NYC

Start Dates (0)

$590
over 2 sessions
These classes sell out faster than we update our systems. Enroll and we'll confirm your spot.

Showing 1 – 0 of 0

Save to WishList Give as a Gift

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)

(3.5-star rating across 8 reviews)

See reviews for other classes at New Horizons Computer Learning

Hide Reviews

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. Earn 10% back in reward points!

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

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

New Horizons Computer Learning
Midtown, Manhattan
462 Seventh Ave 6th Flr
Btwn W 36th & W 37th Streets
New York, New York 10018 Midtown, Manhattan
462 Seventh Ave 6th Flr
Btwn W 36th & W 37th Streets
New York, New York 10018

All classes at this location

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