Access 2010: Level 4 - Application Development & VBA
COURSE OUTLINE:
Prerequisites
Completion of Access 2010: Level 3 or quivalent knowledge is recommended.
Learning 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
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