Access 2007 - 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. (Second Edition)

What will I learn?

Lesson 1: Integrating Access into Your Business

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

Lesson 2: Automating a Business Process with VBA

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

Lesson 3: Managing Switchboards

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

Lesson 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

Lesson 5: Sharing a Database 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

Prerequisites

• Access 2007 - Level 1
• Access 2007 - Level 2