Home - Microsoft Office Training Courses - Microsoft Access 2007 Expert

In our expert Microsoft Access 2007 training course you will learn how to make effective database management calls for mastering the advanced administrative and collaborative features of Microsoft Access 2007. You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is ideal for those who wish to gain introductory level administrator skill sets and for those who may be working in a web-based environment and may need to adapt Access applications to the environment.

Modules included in this course show you how to share Access data with other applications, how to use VBA to automate a business process, how to create and modify a database switchboard, and set the startup options. You will also learn how best to secure databases and share databases using a SharePoint site.

Duration: 1 day.

Price: £220.

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 XML Format
• Export Data to the 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 the 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

Schedule your own Access 2007 Expert training course
Please tell us where and when YOU would like to attend this course. If we are able to schedule the course we will contact you.
Course	Please Select Access 2003 Advanced Access 2003 Expert Access 2003 Intermediate Access 2003 Intro Access 2007 Advanced Access 2007 Complete Access 2007 Essential Access 2007 Expert Access 2007 Intermediate Access 2007 Intro Access 2010 Advanced Access 2010 Complete Access 2010 Essential Access 2010 Expert Access 2010 Intermediate Access 2010 Intro Acrobat Adobe Air Adobe Flex Advanced CSS After Effects Alternatives: Graphics Alternatives: Publishing Alternatives: Web Design Animation Workshop Apple Motion Business Startup Business Vision Coaching Comedy Scriptwriting Complete Final Cut Pro CSS Layout Digital Video Cameras Dreamweaver DVD Studio Pro Essential Final Cut Pro Excel 2003 Advanced Excel 2003 Intermediate Excel 2003 Intro Excel 2007 Advanced Excel 2007 Complete Excel 2007 Essential Excel 2007 Expert Excel 2007 Intermediate Excel 2007 Intro Excel 2010 Advanced Excel 2010 Complete Excel 2010 Essential Excel 2010 Expert Excel 2010 Intermediate Excel 2010 Intro Film and TV Industry Intro Film and TV Scriptwriting 1 day Film and TV Scriptwriting Intro Film Making Fundamentals Final Cut Express Final Cut Pro Intro Final Cut Studio Fireworks Flash ActionScript Flash Advanced Flash Catalyst Flash Complete Flash Intro Flash Media Flash Video Google Adwords Google Adwords Advanced Green Screen Complete Green Screen Intro Green Screen Plugins Green Screen Practical HTML Emails HTML Intro Illustrator Advanced Illustrator Complete Illustrator Intro iMovie InDesign Complete Internet Marketing Internet Marketing and SEO iPhone Apps JavaScript Open Office Outlook 2000 Advanced Outlook 2000 Intro Outlook 2003 Advanced Outlook 2003 Intermediate Outlook 2003 Intro Outlook 2007 Advanced Outlook 2007 Complete Outlook 2007 Essential Outlook 2007 Intermediate Outlook 2007 Intro Outlook 2010 Advanced Outlook 2010 Complete Outlook 2010 Essential Outlook 2010 Intermediate Outlook 2010 Intro PC Networking PC Repair and Maintenance Photography Photography Intro Photoshop Advanced Photoshop Complete Photoshop Intro Photoshop Web Podcasting PowerPoint 2000 Advanced PowerPoint 2000 Intro PowerPoint 2003 Advanced PowerPoint 2003 Intro PowerPoint 2007 Advanced PowerPoint 2007 Complete PowerPoint 2007 Intro PowerPoint 2010 Advanced PowerPoint 2010 Complete PowerPoint 2010 Intro Premiere Pro Publisher 2000 Intro Publisher 2002 Intro Publisher 2003 Intro Publisher 2007 Intro Publisher 2010 Intro QuickBooks Response Forms SEO Techniques Shopping Carts Social Media Twitter Viral Video Web 2.0 Intro Web Business Web Database Techniques Web Effects Web Hosting Web Project Management Web Video Techniques Website Accessibility Word 2000 Intermediate Word 2000 Intro Word 2003 Advanced Word 2003 Intermediate Word 2003 Intro Word 2007 Advanced Word 2007 Complete Word 2007 Essential Word 2007 Intermediate Word 2007 Intro Word 2010 Advanced Word 2010 Complete Word 2010 Essential Word 2010 Intermediate Word 2010 Intro WordPress Advanced WordPress Complete WordPress Intro WordPress Theme Design  Enter a custom course
Month	June 2012 July 2012 August 2012 September 2012
Time	Please Select Weekday (Mon-Fri) Weekend Saturday only Sunday only Evening
Location	Elstree Studios At your location
First Name *
Last Name *
Telephone Number *
Email Address *
If you cannot easily read the two words above, click on the icon that has two arrows chasing each other and new words will be displayed for you.