Access Advanced

Oct 16, 2017 09:00am -
Oct 16, 2017 04:30pm
(GMT-6)

 

Event Description

This ILT Series course builds on the skills and concepts taught in Access Basic and Access Intermediate.

This course will help students prepare for the Microsoft Office Specialist exam for Access (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access.

Course Outline

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 AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Working with XML documents
Topic D: Linking Access objects
Topic E: Using hyperlink fields

Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties

Prerequisites: There are no prerequisites for this course.

Advanced Preparation: There is no advanced preparation for this course.

Competencies: Computer Science

Delivery Method: Group-Live

Program Level: Advanced

CPE Credits: 7

Fields of Study: Computer Science

Duration: Full-day – 9:00 am - 4:30 pm

Member Cost:  $175; NonMember Cost: $189

Computer Training Cancellation/Reschedule Policy: If cancellation/reschedule is received 15 or more business days prior to the start of the class, there will be no penalty. If cancellation/reschedule is received 10-14 business days prior to the start of the class, there will be 50% penalty billed. Anything less than 10 business days the full fee for the class will be billed.

For more information regarding refund, complaint and/or program cancelation policies, please contact AAIM’s Research and Solutions Team at 314-968-3600.​


Event Type:Computer Training
Category:Computer Training
Early registration ends on Jun 13, 2017.
Regular registration starts on Jun 14, 2017 and ends on Oct 15, 2017.
Late registration starts on Oct 16, 2017.
(GMT-06:00) Central Time (US & Canada)

Register for this event