This one-day course builds on the skills and concepts taught in Access Basic. Participants will learn how to normalize data; work with Lookup fi elds and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use Pivot Tables and Pivot Charts.

Unit 1: Relational databases

Unit 2: Related tables

Unit 3: Complex queries

Unit 4: Advanced form design

Unit 5: Reports and printing

Unit 6: Charts

Unit 7: Pivot Tables and Pivot Charts

Learning Management System Users:  Please login into your Learning Management System account and navigate to “Now Enrolling” from the “Browse” drop-down menu.  Select the training you wish to register for and click “Enroll.” This will initiate the required approval process.   

External participants, can click here to complete the HR-1 Training Authorization Form. 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.

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

If you have any questions about the program or the registration process, you can reach a customer success representative by calling (609) 777-2225 or emailing CLIPTraining.Support@csc.nj.gov. 

A $20 administrative  fee will apply to learners who do not have Learning Management System (LMS) platform accounts.