Processing your application. Please be patient while we make sure we receive every piece of it.
Office 2010 Applications
Access 2010 Advanced
1 Day
Guaranteed To Run
Wednesday
Oct 25
Toronto
  $295
Thursday
Oct 26
Toronto
  $295
Thursday
Nov 02
Toronto
  $295
Tuesday
Nov 14
Toronto
  $295
Wednesday
Nov 15
Toronto
  $295
Wednesday
Nov 29
Toronto
  $295
Thursday
Nov 30
Toronto
  $295
Wednesday
Dec 06
Toronto
  $295
Thursday
Dec 07
Toronto
  $295
Tuesday
Dec 19
Toronto
  $295
Wednesday
Dec 20
Toronto
  $295
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
This course 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.
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
To find out more available information
about this course, please contact us:

416-929-1599
info@acend.com
Table Of Contents:
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



SITE MAP