Microsoft Access Advanced
Cost per Person: $159
Pre- Requisite: Microsoft Access Intermediate
Length: 6 hours
Training is held at various community college locations upon request. Complete the Interest Survey below to express your preferences.
8:30 am to 4:00 pm
To be added to a waitlist for the next available class, please call CSC’s Registration Team at (609) 777-2225.
This course builds on the skills and concepts taught in Access Intermediate. Students 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 fields; and use Outlook to update data.
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls
Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries
Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects
Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer
Unit 5: Importing, exporting, and linking
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services
Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties
Unit 7: Internet integration
Topic A: Hyperlink fields
Topic B: Working with Outlook
Enrollment is secured once your agency completes, signs and returns the following form to the Civil Service Commission. Fax your form to 609-777-2336. For any questions, call the Registration Team at 609-777-2225.
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.