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 2007 - Level 2 - Intermediate This course has been designed exclusively for Microsoft Access 2007. For earlier versions of Access please follow this link Course start date: 03-Dec-2008, 03-Feb-2009, 02-Apr-2009, 11-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 2 days Price: $770.00 Inc GST Overview In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance. (Second Edition) Lesson 1: Structuring Existing Data Analyze Tables Create a Junction Table Improve Table Structure Lesson 2: Writing Advanced Queries Create Subqueries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart Lesson 3: Simplifying Tasks with Macros Create a Macro Attach a Macro Restrict Records Using a Condition Validate Data Using a Macro Automate Data Entry Using a Macro Lesson 4: Making Effective Use of Forms Display a Calendar on a Form Organize Information with Tab Pages Display a Summary of Data in a Form Lesson 5: Making Reports More Effective Include a Chart in a Report Print Data in Columns Cancel Printing of a Blank Report Create a Report Snapshot Lesson 6: Maintaining an Access Database Link Tables to External Data Sources Manage a Database Determine Object Dependency Document a Database Analyze the Performance of a Database 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