Forsythes IT & Training Newcastle
About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
 Training Information Technology Forsythes Group
Courses & Certifications

Desktop Applications
Microsoft Product Courses
Microsoft Word Courses
Microsoft Excel Courses
Microsoft Access Courses
Microsoft Outlook Courses
Microsoft Project Courses
MS PowerPoint Courses
Updating to Office 2007
InfoPath 2003
Microsoft Visio
Microsoft Publisher
Microsoft Frontpage
Windows XP
Adobe Product Courses
Adobe Acrobat 8
Adobe InDesign Courses
Photoshop CS Courses
Adobe Photoshop CS-3
Adobe Illustrator Courses
Adobe Flash CS3
Dreamweaver 8
Dreamweaver MX
MYOB Accounting
Corel Draw v12
Crystal Reports Level 1
Crystal Reports Level 2
Technical
Professional Development

Need further information on Access Courses?
Click here
Enrollment form PDF Document

Microsoft Access 2007 - Level 3 - Advanced
This course has been designed exclusively for Microsoft Access 2007.
For earlier versions of Access please follow this link

Dates for next course: Call 02 4969-0690 for the next course date
Training Format: Classroom
Price: Call 02 4969-0690 for pricing

Overview

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

Lesson 1: Integrating Access into Your Business
  • Import XML Data into an Access Database
  • Export Access Data to XML Format
  • Export Data to the 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 a Database 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

Print this course

Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia. With our mobile training room we can provide a range of courses on-site at your premises.

Privacy Policy Terms & Conditions Site Map Links & Resources Home Website Design - Indelible Image