text only siteskip to main contentskip to main navigation
 
State of New Jersey, Civil Service Commission
Governor Phil Murphy • Lt.Governor Sheila Oliver
 
 

Scheduled Date:
Wednesday, June 6, 2018
 
                       

Location:
Mercer County Community College
1200 Old Trenton Rd
West Windsor, NJ 08550

Cost per Person: $159   ***View Summer Special rates*** 

Pre- Requisite: None

Length: 6 hours

Time: 8:30am - 4:00pm

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.

 
 
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

 

 
 
Registration

Please complete the HR-1 Training Authorization Form to request classroom training. Your direct supervisor, departmental training coordinator and fiscal officer must approve the form. HR-1's received without proper approval will be returned to the Department's Training Coordinator.

You are not scheduled for the requested classroom training until you receive an official email confirmation from CLIP.

Fax your form to 609-777-2336. For any questions, please call the Registration Team at 609-777-2225.

 

Training Authorization Form

 

 

 

 
 
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