Course 10384: Advanced Skills in Microsoft Access 2010

Introduction This one-hour online course explains how to create programmable elements in Microsoft Access 2010 and how to share and distribute database information by using Access 2010.

Topics covered in this course include:

• Creating and Editing a Macro
• Handling Errors in a Macro
• Creating and Editing a Module
• Creating an Execute-Only Database
• Encrypting a Database
• Importing Data from and Exporting Data to SharePoint Lists
• Packaging a Database
• Using the Microsoft Access Runtime Program

Student prerequisites:
Learners taking this course must have a good working knowledge of databases. They should be familiar with Microsoft Office Access 2003 or Microsoft Office Access 2007. They should also complete Course 10383AE: Intermediate Skills in Microsoft® Access® 2010 before taking this course. Objectives At the end of the course, students will be able to:

• Create programmed elements to automate tasks and add functionality to database objects and controls.
• Share and distribute database information.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Advanced Skills in Access 2010 Module Overview Creating Programmed Elements Introduction Exploring the Macro Environment Creating and Editing a Macro Creating an Embedded Macro Handling Errors in a Macro Creating and Editing a Module Creating a Macro Self Test Sharing Database Information Introduction Creating an Execute-Only Database Encrypting a Database Using the Access 2010 Runtime Program Packaging a Database Synchronizing a Database with a SharePoint List Importing Data from and Exporting Data to SharePoint Lists Sharing a Database Self Test Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled