Search Courses
Course Details    [choose new course]     [printable version]
Access 2003: Advanced
Course Number: AP0010
Category: Business & Office Applications
Duration: 1.00 day
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