Access 2010 - Level 3

New Horizons Singapore

Location: Bukit Merah - Central

Course details

In this course students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

What will I learn?

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

Prerequisites

Access 2010 - Level 1
Access 2010 - Level 2

Updated on 08 November, 2015

Course Location

Show map Location Bukit Merah - Central

About New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

See all New Horizons Singapore courses

View more Virtual classroom training for Microsoft Access online courses See all Microsoft Access Courses

See all current Microsoft Access jobs in Singapore

Are you from New Horizons Singapore ? Claim your course!

Courses you can instantly connect with... Do an online course on Microsoft Access starting now.