Access 2003 Advanced, 2nd Edition + CertBlaster Study Guide

1-4188-8928-8 © 2007 Publish date: February 10, 2006 174 pages

Buy Now: $25.99

Course ID: access-2003-adv-2nd-sg

CBT Planet offers a selection of MS Access computer training books designed to teach you how to get the most out of this relational database. The Access 2003 Advanced study guide is a must for the serious MS Access student, particularly those who are seeking Microsoft Office Specialist certification as this course is approved courseware for that certification.

In addition to being approved curriculum, the Access 2003 Advanced courseware is extremely highly rated having achieved a 4.9/5.0 rating for overall quality from ProCert Labs. This study guide will teach you about the advanced-level functions and features of Access 2003 and build upon your existing intermediate skills.

You will learn advanced techniques including how to query with SQL, how to use crosstab, parameter, and action queries, how to create and run macros, how to import, export, and link various database objects, how to optimize, replicate, and synchronize your databases, and steps to take in order to maintain database security.

By choosing the Access 2003 Advanced courseware as your training tool on your way towards certification, you are choosing a high-quality, approved course that teaches you how to harness the power of Access and use it to its fullest capabilities. After taking this course, the manual continues to deliver by doubling as a useful reference guide whenever you are working in Access.

Course Objectives

This course will teach you about using SQL statements and examining them in MS Access, writing SQL statements for the creation of queries, and attaching SQL statements to command buttons. It also teaches you about crosstab queries, parameter queries, action queries, macros, data validation, automating tasks, importing and exporting database objects, working with objects from Excel and XML, linking objects, and importing and exporting tables and queries to Windows SharePoint Services.

Other topics cover using the built-in utilities for optimizing resources, replicating and synchronizing databases, using passwords for securing database files, encrypting and decrypting databases, and setting permissions in order to secure database objects.

Course Contents

Unit 1 introduces using SQL for querying

• 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 discusses working with macros

• How to create, run, and modify macros
• How to attach macros to events of database objects

Unit 4 covers advanced macros

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

Unit 5 discusses importing, exporting, and linking objects

• Importing objects
• Exporting objects
• Interacting with XML documents
• How to link MS Access objects
• Using Windows SharePoint Services

Unit 6 covers database management

• How to optimize resources
• Replicating and synchronizing databases

Unit 7 talks about the fundamentals of Security

• Protecting your databases
• Encrypting and decrypting your databases
• Setting user-level security

Appendix A details the Microsoft Office Specialist exam objectives map