Module: Microsoft Office Access Level 4 (Application)
Lesson 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.
Lesson 2: Automating a Business Process with VBA
Create a standard module.
Develop code for a procedure.
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 of a database.
Lesson 4: Distributing and Securing Databases
Split a database into a front-end and a back-end database.
Implement security for an Access database.
Set passwords for an Access database.
Convert an Access database to an ACCDE file.
Package a database with a digital signature.
Lesson 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 with an Access database that was moved to a SharePoint site.