Home > Courses Certifications > Microsoft Office > Access 2007 Level 3 synopsis

Microsoft Access 2007 - Level 3

Access 2007 Level 1

Access 2007 Level 2

Prerequisites: Access 2007 - Level 2

Duration: 1 day

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