This one-day course builds on the skills and concepts taught in Access Intermediate. Participants will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fi elds; and use Outlook to update data.

Unit 1: Querying with SQL

Unit 2: Advanced queries

Unit 3: Macros

Unit 4: Advanced macros

Unit 5: Importing, exporting, and linking

Unit 6: Database management

Unit 7: Internet integration

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.