Microsoft Office Access 2003 Level 3
Start Date: December 3 2009
End Date: December 4 2009
Time: 9:00am -
Fee:
Venue:
 
Course Overview:

Microsoft® Office Access 2003 Level 3

Why you should attend: You will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, you will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Suggested Prerequisites:  Access: Level 1 and Access: Level 2 or equivalent knowledge.

Attend and You Will Learn

Lesson 1: Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Lesson 2: Advanced Queries

  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries

Lesson 3: Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Lesson 4: Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Lesson 5: Importing, Exporting, and Linking Objects

  • Importing objects
  • Exporting objects
  • Interacting with the XML documents
  • Linking Access objects
  • Working with Windows SharePoint services

Lesson 6: Database Management

  • Optimizing resources
  • Replicating and synchronizing databases

Lesson 7: Security Fundamentals

  • Protecting databases
  • Encrypting and decrypting databases
  • User-level security
Schedule: