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 1 - Introductory This course has not been designed for Microsoft Access 2007. For our Access 2007 course follow this link Course start date: 04-Dec-2008, 27-Jan-2009, 23-Feb-2009, 23-Mar-2009, 20-Apr-2009, 18-May-2009, 22-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 2 Days Price: $770.00 Inc GST Overview This course is for the new user of Access and assumes no experience with relational databases. Prerequisites This course requires a basic understanding of computers, such as basic mouse and keyboard operations, point and click and double click operations. Course Outline Lesson 1: Working with a Relational Database Identify Uses of a Relational Database Define Database Terminology Create a New Database Based on a Template Examine the New Database Lesson 2: Planning a Database Identify Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize the Data Designate Primary and Foreign Keys Identify Table Relationships Lesson 3: Building the Basic Structure Create a Blank Database Create a Table using a Wizard Compare Relationships between Tables Lesson 4: Working with Tables Modify a Table Design Work in Datasheet View Work with Subdatasheets Lesson 5: Creating and Working with Select Queries Examine a Query Create a Query using a Wizard Work in Query Design View Select Records Edit Values in a Query Datasheet Add a Calculated field to a Query Perform a Calculation for a Group of Records Lesson 6: Creating and Using Forms Create AutoForms Create a Form Using a Wizard Modify the Design of the Form Use forms to work with Data Lesson 7: Creating and Using Reports Create an AutoReport Create a Report Using a Wizard Examine a Report in Design View Create a Calculated Field Change the Format of a Control Change the Style of a Report Adjust Report Width Lesson 8: Import Data Maintain Record Integrity Exporting Data Documenting Table Relationships 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