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 Courses Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator Courses 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 1 - Introductory This course has been designed exclusively for Microsoft Access 2007. For earlier versions of Access please follow this link Course start date: 12-Jan-2009, 16-Feb-2009, 16-Mar-2009, 20-Apr-2009, 18-May-2009, 15-Jun-2009 Training Location 9 Denison St, Newcastle West Training Format: Classroom Duration: 2 Days Price: $770.00 Inc GST Overview In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access 2007 with other applications. (Second Edition) Lesson 1: Exploring the Microsoft® Office Access 2007 Environment Examine Database Concepts Explore the User Interface Explore the Ribbon Customize the Access Environment Obtain Help Use an Existing Access Database Lesson 2: Designing a Database Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships Lesson 3: Building a Database Create a New Database Create a Table Manage Tables Create a Table Relationship Save a Database as a Previous Version Lesson 4: Managing Data in a Table Modify Table Data Sort Records Work with Subdatasheets Lesson 5: Querying a Database Filter Records Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping Lesson 6: Designing Forms View Data Using an Access Form Create a Form Modify the Design of a Form Lesson 7: Generating Reports View an Access Report Create a Report Add a Custom Calculated Field to a Report Format the Controls in a Report Apply an AutoFormat to a Report Prepare a Report for Print Lesson 8: Controlling Data Entry Restrict Data Entry Using Field Properties Establish a Pattern for Entering Field Values Create a List of Values for a Field Lesson 9: Joining Tables Create Query Joins Join Unrelated Tables Relate Data Within a Table Lesson 10: Creating Flexible Queries Set Select Query Properties Create Parameter Queries Create Action Queries Lesson 11: Improving Forms Design a Form Layout Enhance the Appearance of a Form Restrict Data Entry in Forms Add a Command Button to a Form Create a Subform Lesson 12: Customizing Reports Organize Report Information Format the Report Set Report Control Properties Control Report Pagination Summarize Report Information Add a Subreport to an Existing Report Create a Mailing Label Report Lesson 13: Sharing Data Across Applications Import Data into Access Export Data Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document 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