Access 2007 Advanced Study Guide

1-4239-1807-X © 2008 Publish date: March 22, 2007 176 pages

Buy Now: $25.99

Course ID: access-2007-adv-sg

The Access 2007 Advanced study guide is the third and final in our series of Access 2007 computer training books. This course has earned a 4.9/5.0 score for overall quality from ProCert Labs.

By choosing this Microsoft Access training course, you will build on the techniques, skills, and concepts you leraned by taking the basic and intermediate courses. The Access 2007 Advanced courseware teaches you about creating queries with SQL, creating crosstab, parameter, and action queries, creating macros, and importing, exporting, and linking database objects.

You will also learn how to work with XML documents, Windows SharePoint Services, and optimize, password-protect, and encrypt databases. Other topics include setting Access options and properties, creating hyperlink fields, and using Outlook 2007 for updating data.

Like the other books in this series, this Access 2007 Advanced courseware is approved curriculum for the Microsoft Certified Application Specialist program. By following these three guides, you will be ready for the Access 2007 exam (70-605).

Seven full units cover a wide variety of topics and get you ready for success using the advanced features and functions. You can learn at your own pace and follow a schedule that makes the most sense for your objectives. Whether you complete the course in a day, a week, or a month is up to you.

Course Objectives

By choosing this course, you will learn about using SQL statements in Access, creating aliases for fields, writing SQL statements for creating queries, and attaching SQL statements to command buttons. You will be able to summarize your grouped data by using crosstab queries as well as know how to view specific results using parameter queries. In addition, you will be able to add, delete, or modify data in tables (and make new tables) by creating action queries.

Other topics include creating and running macros for automating tasks, attaching macros to events of objects, creating data validation and data-entry macros, and creating AutoKeys, AutoExec, and import/export macros. You will learn how to save to previous versions of Access, how to split, compact, repair, or back up your databases, and how to encrypt and password-protect your database files.

Finally, you will learn about configuring Access Options, populating database file properties, working with hyperlink fields, and collecting data from email using MS Outlook 2007.

Course Contents

Unit 1 covers querying with SQL

• SQL and Access
• How to write SQL statements
• How to attach SQL queries to controls

Unit 2 covers advanced queries

• How to create crosstab queries
• How to create parameter queries
• Working with action queries

Unit 3 goes over macros

• Working with macros
• How to attach macros to the events of database objects

Unit 4 covers advanced macros

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

Unit 5 goes over importing, exporting, and linking

• Importing objects
• Exporting objects
• How to interact with XML documents
• How to link Access objects
• Integrating with Windows SharePoint Services

Unit 6 covers database management

• How to optimize resources
• How to protect databases
• How to set options and properties

Unit 7 discusses Internet integration

• Hyperlink fields
• Using Access and Outlook 2007