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, July 11, 2018
  

                             

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

Cost: $159pp        ***View Summer Special rates***

Includes Course Material

Length: 6 hours

Time: 8:30am - 4:00pm

Pre-Requisite: Microsoft Access Basic

Course Description

This course builds on the skills and concepts taught in Access Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.

 
 
Course Outline

Unit 1: Relational databases
Topic A: Database normalization
Topic B: Relating tables
Topic C: Implementing referential integrity

Unit 2: Related tables
Topic A: Lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Adding Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Customized headers and footers
Topic B: Adding calculated values
Topic C: Printing
Topic D: Labels

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports

Unit 7: PivotTables and PivotCharts
Topic A: PivotTables
Topic B: Modifying PivotTables
Topic C: PivotCharts
Topic D: PivotTable forms

 

 
 
Interest Survey

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