Access 2003 Advanced

CW-056C Access 2003 Advanced

Synopsis: Created for the student whose goal is to become proficient in PivotTables and PivotCharts; creating advanced forms and macros; Internet integration; database management and security fundamentals; and explore Access SQL.

Prerequisite: Successful completion of Access 2003 Intermediate class or equivalent experience.

Length of Course: Self-paced, average 12-18 hours per course

Required Text: Clackamas Community College custom courseware will be provided at the first class.

  1. Querying with SQL
    1. SQL and Access.
    2. Writing SQL statements .
    3. Attaching SQL queries to controls.
  2. Advanced queries
    1. Creating crosstab queries.
    2. Creating parameter queries.
    3. Using action queries.
  3. Macros
    1. Creating, running, and modifying macros.
    2. Attaching macros to the events of database objects.
  4. Advanced macros
    1. Creating macros to provide user interaction.
    2. Creating macros that require user input.
    3. Creating the AutoKeys and AutoExec macros.
    4. Creating macros for data transfer.
  5. Importing, exporting, and linking objects
    1. Importing objects.
    2. Exporting objects.
    3. Interacting with the XML documents.
    4. Linking Access objects.
    5. Working with Windows SharePoint Services.
  6. Database management
    1. Optimize resources.
    2. Replicating and synchronizing databases.
  7. Security fundamentals
    1. Protecting databases.
    2. Encrypting and decrypting databases.
    3. User-level security.