CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APAC104 - Microsoft Access 2010 Level 4

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Click here for a printer-friendly version of this page

Upcoming classes

Number	Class Date	Location	Length	Cost	Sign up
APAC104	Jul 06, 2012 - Jul 06, 2012	Springfield	1 day	$140.00	Register
APAC104	Sep 13, 2012 - Sep 13, 2012	Bloomington	1 day	$140.00	Register

Prerequisites

To ensure the successful completion of Microsoft® Office Access® 2010: Level 4, the following Element K courses or equivalent knowledge is recommended:

Microsoft® Office Access® 2010: Level 1

Microsoft® Office Access® 2010: Level 2

Microsoft® Office Access® 2010: Level 3

Detailed Class Syllabus

Lesson 1: Integrating Access into Your Business
Topic 1A: Import XML Data into an Access Database
Topic 1B: Export Access Data to the XML Format
Topic 1C: Export Data to an Outlook Address Book
Topic 1D: Collect Data Through Email Messages

Lesson 2: Automating a Business Process with VBA
Topic 2A: Create a Standard Module
Topic 2B: Develop Code
Topic 2C: Call a Procedure from a Form
Topic 2D: Run a Procedure

Lesson 3: Managing Switchboards
Topic 3A: Create a Database Switchboard
Topic 3B: Modify a Database Switchboard
Topic 3C: Set the Startup Options

Lesson 4: Distributing and Securing Databases
Topic 4A: Split a Database
Topic 4B: Implement Security
Topic 4C: Set Passwords
Topic 4D: Convert an Access Database to an ACCDE File
Topic 4E: Package a Database with a Digital Signature

Lesson 5: Sharing Databases Using a SharePoint Site
Topic 5A: Export a Table to a SharePoint List
Topic 5B: Import Data from a SharePoint List
Topic 5C: Publish a Database to a SharePoint Site
Topic 5D: Move a Database to a SharePoint Site
Topic 5E: Work Offline