Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


In this one-day course, students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, and many more.


 
Course Outline
This course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2010.

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 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: Hyperlink fields
Unit 6: Database management
  • Topic A: Optimizing resources
  • Topic B: Protecting databases
  • Topic C: Setting options and properties

Prerequisites & Certificates
Pre-Requisites

Access 2010 Level 2 or equivalent knowledge

Certificates offered

Certificate of Completion


Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course will be fully refunded less a $75 processing fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
Map & Reviews
Acend Corporate Learning
[ View Provider's Profile ]

Reviews
 
re Instructor assessment. ques. are N/A as it was independant mentored study. Flash based training module had 1 hiccup where ctrl-b key was captured by OS and I had to hunt for alt-b to complete the module. Class mentor was unaware of flaw. I felt that the design of the module would have prevented me from completing the section if I was unable to locate alternative keystroke. Worthwhile day.
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 6285 times.