| Print Preview
| E-Mail Outline
Access 2010 - Level 3
Traditional Instructor Led Learning - 1.00 Day(s)
Online Live - 1.00 Sessions
Mentored Learning - Flexible
In this course students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Who Should Attend:
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.
At Course Completion:
Upon successful completion of this course, students will be able to:
- share Access data with other applications.
- use VBA to automate a business process.
- create and modify a database switchboard and set the startup options.
- secure and distribute databases.
- share databases using a SharePoint site.
Prerequisite(s) or equivalent knowledge:
Access 2010 - Part 1|
Access 2010 - Part 2
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
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
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
*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.