Access 2010 - Level 3

Course details

In this course students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Course Outline

1 - Integrating Access into Your Business

• Import XML Data into an Access Database 
• Export Access Data to the XML Format 
• Export Data to an Outlook Address Book 
• Collect Data Through Email Messages

2 - Automating a Business Process with VBA

• Create a Standard Module 
• Develop Code 
• Call a Procedure from a Form 
• Run a Procedure

3 - Managing Switchboards

• Create a Database Switchboard 
• Modify a Database Switchboard 
• Set the Startup Options

4 - Distributing and Securing Databases

• Split a Database 
• Implement Security 
• Set Passwords 
• Convert an Access Database to an ACCDE File 
• Package a Database with a Digital Signature

5 - Sharing Databases Using a SharePoint Site

• Export a Table to a SharePoint List 
• Import Data from a SharePoint List 
• Publish a Database to a SharePoint Site 
• Move a Database to a SharePoint Site 
• Work Offline

Target Audience: This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.