Microsoft Access Advanced
Scheduled Date: Email CLIPTraining.Support@csc.nj.gov or contact the Registration Team at 609-777-2225 to be added to the waitlist.
|
Location: Mercer County Community College 1200 Old Trenton Rd West Windsor, NJ 08550
|
Cost per Person: $159
Includes Course Material
Length: 6 hours
Time: 8:30am - 4:00pm
Pre-Requisite: Microsoft Access Intermediate
|
Course Description
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.
Course Topics
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
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