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
Import
ing
Data from a SharePoint List
Publish
ing
a Database to a SharePoint Site
Moving
a Database to a SharePoint Site
Work
ing on the Database Offline

 

 

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