This self-study online course focuses on Access 2007 database administration

Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007.

This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in SharePoint. Another feature of Access 2007 is its programmability. Using Access macros and Visual Basic for Applications (VBA) code you can easily add functionality to a database to suit your business needs.

In addition to SharePoint integration, this course provides an introduction to programming in Access and explores when to use macros or VBA code to automate processes. It also demonstrates how to create, launch, and modify macros and explains the use of the Visual Basic Editor to create event handlers and set control property values.

Target Audience
Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Prerequisites
The Skillsoft Microsoft Office 2007: Beginning Access learning path; Microsoft Office 2007: Advanced Access learning path; familiarity with a Windows user environment

Lesson Objectives
Personalize Access 2007
- customize datasheets in Access 2007
Access 2007 Maintenance and Management
- recognize how to compact and repair a database
- illustrate how to convert earlier Access database formats to Access 2007
- specify how to back up databases and restore database files
Personalizing and maintaining a database in Access 2007
Optimize Access 2007 Database performance
- outline how to view and change object dependencies in Access 2007
- illustrate how to analyze objects for performance
- outline how to use the database documenter and the Table Analyzer wizard to optimize database performance
Optimizing a Database in Access 2007
Secure Database Information in Access 2007
- identify how to enable content for an Access 2007 database
- recognize how to hide a database object
Set a password and secure VB code in Access 2007
- summarize how to encrypt a database by setting a database password
- restate how to protect VB code in Access 2007
Share a Database in Access 2007
- determine how to split a database and repair database links
- use an Office Access 2007 database in a trusted location
- restate how to package, sign, and distribute an Office Access 2007 database
Securing and Sharing an Access 2007 Database
Create a Switchboard in Access 2007
- outline how to work with switchboards and the Navigation Pane
- outline how to create a custom group and add objects to it