Access 2010/365 - Level 3

Duration: Instructor Led Learning - 1 Day
At Course Completion:

Upon successful completion of this course, delegates will be able to:


  • share MS Access data with other applications
  • Use Visual Basic for Applications to automate the business processes
  • Create and modify a database switchboard and set the Startup and Shutdown options
  • Secure and distribute databases with passwords and permission rights
  • Share databases using a SharePoint 2010 site


Access 2010 Level 3 Outline:


Lesson 1: Integrating Access into Your Business 

Importing XML Data into an Access Database
Exporting Access Data to the XML Format
Exporting Data to an Outlook Address Book
Collecting Data through Email Messages


Lesson 2: Automating a Business Process with VBA 

Creating a Standard Module
Developing VBA Code
Calling a Procedure from a Designed Form
Running a VBA Procedure


Lesson 3: Managing Switchboards 

Create a Database Switchboard
Modify a Database Switchboard
Add Macro Options to a Switchboard
Set the Startup Options


Lesson 4: Distributing and Securing Databases 

Splitting a Database
Implementing Database Security
Setting Passwords for All Users
Converting an Access Database to an ACCDE File
Packaging a Database with a Digital Signature


Lesson 5: Sharing Databases Using a SharePoint Site

Exporting a Table to a SharePoint List
Data from a SharePoint List
a Database to a SharePoint Site
a Database to a SharePoint Site
ing on the Database Offline



Access 2010 Level 3 Outline.pdf Access 2010 Level 3 Outline.pdf
Size : 175.783 Kb
Type : pdf