text only siteskip to main contentskip to main navigation
 
State of New Jersey, Civil Service Commission
Governor Chris Christie • Lt.Governor Kim Guadagno
 
 

Cost per Person: $159

Pre- Requisite: None

Length: 6 hours

Location:
Training is held at various community college locations upon request.  Complete the Interest Survey below to express your preferences.

 

Class Time:
8:30 am to 4:00 pm

 

Scheduled Sessions:

 Wednesday, August 27, 2014

Course Description

This course covers the basic functions and features of Access. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports.

 
 
Interest Survey

Please click the link below to let us know the Microsoft classes you are interested in attending and your preferred class location. A representative will contact you for the next available class in your area.

Questions with regard to the Microsoft Office training may be referred to the registration team at 609-777-2225.

 
 
Course Outline

Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help

Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables

Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records

Unit 4: Data entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules

Unit 5: Basic queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries

Unit 6: Using forms
Topic A: Creating forms
Topic B: Using Design view
Topic C: Sorting and filtering records Topic

Unit 7: Working with reports
Topic A: Reports
Topic B: Modifying and printing reports

 

 
 
OPRA - Open Public Records Act NJ Home Logo
Department: CSC Home  |  Job Seekers  |  Current Employees  |  Appointing Authorities and Employers  |  About Us
Statewide: NJHome  |  Services A to Z  |  Departments/Agencies  |  FAQs
 
Copyright © State of New Jersey, 1996 - 2011