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 2 - Intermediate This course has not been designed for Microsoft Access 2007. For our Access 2007 course follow this link Course start date: 24-Nov-2008, 18-Dec-2008, 26-Feb-2009, 28-Apr-2009, 29-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 2 Days Price: $770.00 Inc GST Overview Students will learn how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms. Prerequisites Students should have completed Access – Level 1 or have equivalent skills and knowledge. Lesson 1: Structuring Existing Data Use the Table Analyser Wizard for Help Decide on Your Own Design Create a Junction Table Modify the Original Tables and Completing the Design Compact and Repair a Database Lesson 2: Summarising Data Group and Summarise Records in Different Ways Summarise with a Crosstab Query Pivot Query Results Display a Graphical Summary on a Form Lesson 3: Simplifying Tasks with Macros Create a Macro Attach a Macro to a Command Button Restrict Records Lesson 4:Adding Interaction and Automation with Macros Require Data Entry with a Macro Display a Message Box with a Macro Automate Data Entry Lesson 5:Making Forms More Usable Change the Display of Data Under Certain Conditions Display a Calendar on a Form Organize Information with Tab Pages Lesson 6:Making Reports More Powerful Cancel Printing of a blank Report Include a chart Arrange Data in Columns Distribute Reports as a Snapshot Lesson 7: Expanding the Reach of Your Data Merge Access Data with a Word Document Publish Access Data as a Word Document Analyse Access Data in Excel 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