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.
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.