Discover Classes. Earn Rewards.
Welcome to CourseHorse!

Valuable Rewards & Savings

40,000 Classes to Choose From

Verified Student Reviews

Prompt Customer Service

Fast & Secure Checkout

Access 2007 - Level 1

New Horizons Computer Learning »
Price:
$590
Start date:
This class has ended. Save to Wish List to find out when new dates are added.
Thu, May 08: 9:00am - 04:30pm
Fri, May 09: 9:00am - 04:30pm
Location: Murray Hill
290 Madison Ave 3rd floor
(Btwn E 40th & 41st Streets)
New York, New York 10017
(Map)

Class Information

  • Class Level: Beginner
  • Age Requirements: 18 and older
  • Average Class Size: 6

What you'll learn in this access training:

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access™ 2007 with other applications. (Second Edition)

Who Should Attend
This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first part of the course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. The second part of the course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Prerequisite(s) or equivalent knowledge

  • Windows XP (New Version) - Level 1
Outline

Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment
  • Examine Database Concepts
  • Explore the User Interface
  • Explore the Ribbon
  • Customize the Access Environment
  • Obtain Help
  • Use an Existing Access Database
Lesson 2: Designing a Database
  • Describe the Relational Database Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships
Lesson 3: Building a Database
  • Create a New Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship
  • Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
  • Modify Table Data
  • Sort Records
  • Work with Subdatasheets
Lesson 5: Querying a Database
  • Filter Records
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
  • View Data Using an Access Form
  • Create a Form
  • Modify the Design of a Form
Lesson 7: Generating Reports
  • View an Access Report
  • Create a Report
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat to a Report
  • Prepare a Report for Print
Lesson 8: Controlling Data Entry
  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field
Lesson 9: Joining Tables
  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table
Lesson 10: Creating Flexible Queries
  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries
Lesson 11: Improving Forms
  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform
Lesson 12: Customizing Reports
  • Organize Report Information
  • Format the Report
  • Set Report Control Properties
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
Lesson 13: Sharing Data Across Applications
  • Import Data into Access
  • Export Data
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document
Note: There are PC computers at location for students to use.

Refund & Cancellation Policy

Cancellation & Refund Policies

Please notify New Horizons six (6) or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes, and eleven (11) days or more business days for technical classes.  

Cancellations may be made by calling or e-mailing your Account Executive. You will receive a 100% refund if you cancel according to the terms above for applications and technical classes.  

If you are a club member, you may be assessed a late fee of $50.00 for an applications class, and $200 for a technical class if you cancel late or do not show up for class.  

If you are a coupon holder, you will be assessed one coupon for each class that you do not show up for.

Price Guarantee

We promise that our prices are the same (or less) than prices on the school's website

Comprehensive

We centralize over 40,000 classes from vetted, high quality class providers

Verified Student Reviews

CourseHorse is the only place where you can read class reviews from verified students

Incredible Service

We're dedicated to supporting your learning goals every step of the way

Fast & Secure Checkout

Single-page checkout and powerful encryption make CourseHorse the place to book

Save on Every Class with CourseHorse

We give you back 5% of every class purchase, to encourage you to keep on learning!

Start Dates (0)

Can't make these dates? Save to Wish List this class to find out first about new class dates.

Save to Wish List

Map

Google Map
New Horizons Computer Learning
Murray Hill
290 Madison Ave
3rd floor
Btwn E 40th & 41st Streets
New York, New York 10017

All classes at this location

School: 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 »

CourseHorse Approved School

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

Reviews of Classes at New Horizons Computer Learning

(3 Reviews)


Attended: Excel 2010 - Level 3

The instructor was helpful and engaging. The class was well designed and I walked out with a lot of new tricks to improve my work with excel.


Attended: Excel 2010 - Level 2

Although I already had a base of knowledge of Excel at the intermediate level, I picked up a number of new skills that will really help me on a number of projects. The course was very useful and will be beneficial to my work going forward.


Attended: Grammar Skills

Although the teacher was enthusiastic, knowledgeable and specifically asked each student what they wanted to focus on, she frequently got off track. As a result I did not get nearly as much as I had expected- definitely not $275 worth! I did however get a short list of useful resources which the teacher promptly emailed to me. Given the hefty price of this course I would not recommend it. I think you would get more by doing free grammar activities online.

Want to take this class?

Save to Wish List

Taking this class for work? Get exclusive perks & discounts for free.

Need help finding a class? Call 212-729-4088 or email [email protected]
Customer Service: 212-729-4088