Home - Microsoft Office Training Courses - Microsoft Access 2010 Expert
In our expert Microsoft Access 2010 training course you will learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is for those who are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.
Topics covered in this course include how 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 and how to share databases using a SharePoint site.
Duration: 1 day.
Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]
Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
Accommodation: Details of local accomodation can be found here.
Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.
COURSE CONTENT
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
Automating a Business Process with VBA
- Create a Standard Module
- Develop Code
- Call a Procedure from a Form
- Run a Procedure
Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
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
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
5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
