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: Microsoft Access Basic

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

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.

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

 

 
 
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