Access 2007 - Level 2
- Intermediate
- 18 and older
- $590
- Earn 10% Rewards
- Price Lock
- 462 Seventh Ave, New York, NY
- over 2 sessions
Jul 21st
10am–5pm EDT
Discover Classes. Earn 10% Rewards.
Access 2007 - Level 2 is unfortunately unavailable
Thankfully we have 110 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.
Excel Level I: Fundamentals
Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online
Master the essentials of Microsoft Excel in this practical hands-on workshop. Learn calculations, functions, graphs, formatting, and printing, and gain the skills you need to excel in data management. Expand your proficiency with Noble Desktop.
$249
20 Seats Left
Jul 29th
10am–5pm EDT
$249
20 Seats Left
Aug 6th
10am–5pm EDT
$249
20 Seats Left
Aug 12th
10am–5pm EDT
$249
20 Seats Left
Aug 18th
10am–5pm EDT
$249
20 Seats Left
This class has 15 more dates.
Tap here to see more
Mon, Jul 21st, 10am–5pm EDT
(7 hours)
All Day Private Digital Photography for 1-6 People (New York)
Digital Photo Academy See all classes by this school @ Location customized to student goals, New York, NY
Master the art of digital photography with personalized instruction tailored to your specific needs and interests. Capture stunning images in various categories like landscape, portrait, and architecture, and learn post-capture techniques to enhance your photos. Schedule a private session with Digital Photo Academy and discover the endless possibilities of photography.
Jul 23rd
10am–5pm EDT
$675
1 Seat Left
Jul 24th
10am–5pm EDT
$675
1 Seat Left
Jul 25th
10am–5pm EDT
$675
1 Seat Left
Jul 26th
10am–5pm EDT
$675
1 Seat Left
Jul 27th
10am–5pm EDT
$675
1 Seat Left
This class has 126 more dates.
Tap here to see more
Wed, Jul 23rd, 10am–5pm EDT
(7 hours)
Beginners 1: Guitar for Absolute Beginners
New York City Guitar School See all classes by this school @ 251 W 30th St, New York, NY
Unlock your musical potential with a guitar course designed for absolute beginners. Students will learn basic chords, practice with real songs, and connect with classmates at the New York City Guitar School. Guitars are provided, so all you need to bring is your desire to rock!
Jul 23rd
6–7pm EDT
Meets 12 Times
$357
30 Seats Left
Jul 26th
2–3pm EDT
Meets 12 Times
$357
30 Seats Left
Jul 29th
6–7pm EDT
Meets 12 Times
$357
30 Seats Left
Jul 29th
7–8pm EDT
Meets 12 Times
$357
30 Seats Left
Jul 30th
6–7pm EDT
Meets 12 Times
$357
30 Seats Left
This class has 21 more dates.
Tap here to see more
Wed, Jul 23rd, 6–7pm EDT
(12 hours over 12 sessions)
Cell Phone Photography Masterclass for 1-6 People (NYC)
Digital Photo Academy See all classes by this school @ Location customized to student goals, New York, NY
Unlock the full potential of your cell phone camera and capture stunning images anywhere. Learn expert composition techniques, master dynamic shot framing, and explore powerful editing apps to transform your photos into works of art. With hands-on guidance from a seasoned photographer, you'll gain the skills to elevate your mobile photography to the next level.
Jul 23rd
10am–3pm EDT
$550
1 Seat Left
Jul 24th
10am–3pm EDT
$550
1 Seat Left
Jul 25th
10am–3pm EDT
$550
1 Seat Left
Jul 26th
10am–3pm EDT
$550
1 Seat Left
Jul 27th
10am–3pm EDT
$550
1 Seat Left
This class has 96 more dates.
Tap here to see more
Wed, Jul 23rd, 10am–3pm EDT
(5 hours)
Half Day Private Digital Photography for 1-6 People (New York)
Digital Photo Academy See all classes by this school @ Location customized to student goals, New York, NY
Discover the secrets of professional digital photography with personalized instruction tailored to your specific camera and interests. Unleash your creativity and capture stunning images as you explore landscapes, portraits, architecture, and more. Enhance your skills with expert guidance on post-capture techniques and image organization.
Jul 23rd
10am–1pm EDT
$375
1 Seat Left
Jul 24th
10am–1pm EDT
$375
1 Seat Left
Jul 25th
10am–1pm EDT
$375
1 Seat Left
Jul 26th
10am–1pm EDT
$375
1 Seat Left
Jul 27th
10am–1pm EDT
$375
1 Seat Left
This class has 126 more dates.
Tap here to see more
Wed, Jul 23rd, 10am–1pm EDT
(3 hours)
Sold Out
Start Dates (0)
- $590/person
- 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
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.
Lesson 1: Structuring Existing Data
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.
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
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
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
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™
Book this Class as a 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.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
Loading...