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 CS Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator CS 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 Microsoft Access - Level 3 - Advanced This course has not been designed for Microsoft Access 2007. For our Access 2007 course follow this link Course start date: 27-Nov-2008, 29-Jan-2009, 30-Mar-2009, 25-May-2009 Training Location 9 Denison St, Newcastle West Duration: 2 Days Price: $770.00 Inc GST Overview In this course, students will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable. Prerequisites Students should have completed Access 2002 – Level 1 and Access 2002 – Level 2 or have equivalent skills and knowledge. Lesson 1: Creating a Switchboard and Setting the Startup Options Create a Database Switchboard Modify a Database Switchboard Set the Startup Options Modify the Startup Options Lesson 2: Developing a Data Access Page and Including a PivotTable and PivotChart Create a Data Access Page in Design View Incorporate a ComboBox Control in the Data Access Page View Data Access Pages with the Browser Add Records to a Database Using the Data Access Page Plan a PivotTable Develop a PivotTable with the Office PivotTable Tool Develop a PivotChart from a PivotTable Lesson 3: Split a Database Implement Security Set Passwords Encrypt and Decrypt a Database Convert an Access Database to an MDE File Lesson 4: Integrating Access into Your Business Link Tables to External Data Sources Import XML Data into an Access Database Export Access Data to XML Format Replicate an Access Database Lesson 5: Automating a Business Process with VBA Create a Standard Module Create and Insert a Procedure Develop Procedure Code Call a Procedure from a Form Run the Procedure 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.

	2008 Forsythes IT & Training - All Rights Reserved	Privacy Policy	Terms & Conditions	Site Map	Links & Resources	Home	Website Design - Indelible Image