Call on 1300 794 006 Advanced Search

Courses Professional Development Desktop Applications Technical Courses Microsoft Courses Design, Media and Graphics Courses Certifications Microsoft CompTIA Cisco ITIL MSP Schedules Sydney Brisbane Melbourne Perth Newcastle Hobart Cairns Canberra Learning Options Our Approach Learning Port Classroom Learning Walk-In Learning Method Online ANYTIME Enterprise Solutions Club Membership Seminars Sydney Brisbane Melbourne Perth Newcastle Vendors Microsoft Cisco CompTIA ITIL Learning Resources Practice Exams Exercise Files Testing Facilities Online Evaluation New Horizons eTips Elevate Newsletter Learning Catalogue About Us Contact Us Locations Room Rentals Mission and Values Community Involvement Business Opportunities Career Opportunities Sitemap Awards and Recognitions

Courses + Certifications Professional Development Desktop Applications Technical Your cart contains 0 courses

Home > Desktop Applications > Microsoft Access > Access 2003 - Level 1 Access 2003 - Level 1 Book a course: Choose your location: Sydney Melbourne Brisbane Perth Cairns Select a date: Choose a date... 20 Sep 10 - 21 Sep 10 -- 9:00 AM - 5:00 PM 04 Nov 10 - 05 Nov 10 -- 9:00 AM - 5:00 PM 24 Jan 11 - 25 Jan 11 -- 9:00 AM - 5:00 PM Price: $900.00 inc. GST Duration: 2 Days Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 2 Days Overview: In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. Also, you will learn how to design and create a new Access database. Target Audience: This course is designed for students who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first day addresses job responsibilities that include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. The second day addresses job responsibilities that include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces integrating Access data with other Microsoft applications. Pre-requisites: Windows XP - Level 1 At Course Completion: You will be introduced to the features of the Microsoft Office Access 2003 application. You will design and create a new Access database; improve queries, forms, and reports; and integrate Access with other applications. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003. Outline: Module 1: An Overview of Microsoft Access Relational Databases The Access Environment The Database Environment Examine an Access Table Module 2: Managing Data Examine an Access Form Add and Delete Records Sort Records Display Record Sets Update Records Run a Report Module 3: Establishing Table Relationships Identify Table Relationships Identify Primary and Foreign Keys in the Relationships Window Working with Subdatasheets Module 4: Querying the Database The Select Query Add Criteria to a Query Add a Calculated Field to a Query Perform a Calculation on a Record Grouping Module 5: Designing Forms Form Design Guidelines Create AutoForms Create a Form Using the Form Wizard Modify the Design of a Form Module 6: Producing Reports Create an AutoReport Create a Report by Using the Wizard Examine a Report in Design View Add a Calculated Field to a Report Modify the Format Properties of a Control AutoFormat a Report Adjust the Width of a Report Module 7: Planning a Database Design a Relational Database Identify Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize the Data Designate Primary and Foreign Keys Module 8: Building the Structure of a Database Create a New Database Create a Table Using a Wizard Create Tables in Design View Create Relationships between Tables Module 9: Controlling Data Entry Restrict Data Entry with Field Properties Create an Input Mask Create a Lookup Field Module 10: Finding and Joining Data Find Data with Filters Create Query Joins Join Unrelated Tables Relate Data Within a Table Module 11: Creating Flexible Queries Set Select Query Properties Create Parameter Queries Create Action Queries Module 12: Improving Your Forms Enhance the Appearance of a Form Restrict Data Entry in Forms Add Command Buttons Create a Subform Module 13: Customizing Your Reports Organize Report Information Set Report Control Properties Control Report Pagination Summarize Information Add a Subreport to an Existing Report Create Mailing Labels Module 14: Expanding the Reach of Your Data Publish Access Data as a Word Document Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Links & Resources | Career Opportunities

Copyright © 2009 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086

Developed by Globe Web Services