Access 2003 Training (Advanced)

Description:

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches advanced-level functions and features of Access 2003. Students will learn how to: query with SQL; use crosstab, parameter, and action queries; create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security. This course is approved courseware for Microsoft Office Specialist certification.

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 objects
  • Topic A: Importing objects
  • Topic B: Exporting objects
  • Topic C: Interacting with the XML documents
  • Topic D: Linking Access objects
  • Topic E: Working with Windows SharePoint Services

• Unit 6: Database management
  • Topic A: Optimizing resources
  • Topic B: Replicating and synchronizing databases

• Unit 7: Security fundamentals
  • Topic A: Protecting databases
  • Topic B: Encrypting and decrypting databases
  • Topic C: User-level security

• Appendix A: Microsoft Office Specialist exam objectives map
  • Topic A: Comprehensive exam objectives

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.