Access 2007 Advanced

CW-056C Access 2007 Advanced

Synopsis: This course is designed for the experienced MS-Access database designer. Skills introduced are exchanging date between applications, analyzing performance and customizing a database using macros and VBA.

Prerequisite:Successful completion of Access 2007 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.

Chapter 1 Get Connected

  1. Create a hyperlinked field
  2. Attach files and graphics to records
  3. Add and use a table attachment field
  4. Export database objects as HTML files
  5. Import or link to HTML files
  6. Share XML data
  7. Share data with Excel
  8. Collect data through e-mail messages
  9. Manage e-mail replies

Chapter 2 Bulletproofing the Database

  1. Encrypt and password-protect a database
  2. Digitally sign and publish the database
  3. Save the database as an ACCDE file
  4. Analyze database documentation
  5. Analyze database performance
  6.  Analyze database table structure and relationships
  7. Move data to new database files
  8. Analyze and optimize object relationships in an Access database
  9. Create usable switchboards

Chapter 3 Macros and Visual Basic for Applications

  • Understand the purpose of macros in Access databases
  • Create embedded macros using wizards
  • Create macros using the Macro Builder
  • Assign macros to events
  • Use SQL conditions to control macro actions
  • Understand Visual Basic for Applications (VBA)
  • Use the Visual Basic Editor
  • Create procedures
  • Declare and use variables
  • Manage data using SQL