-
Microsoft Access 2010: Level 4 - Power User
-
Course length:
1.0 day
Course Objective:
You will exchange data with other applications, automate business processes
by using VBA code, and secure and share databases.
Target Student:
This course is designed for students who have a thorough understanding
of the basic and advanced user features of the Microsoft® Office Access
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.
Course Objectives:
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
-
Course Content
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
- 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 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