Access 2003

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.
Outline:
Lesson 1: An Overview of Microsoft Access
- Relational Databases
- The Access Environment
- The Database Environment
- Examine an Access Table
-
Lesson 2: Managing Data
- Examine an Access Form
- Add and Delete Records
- Sort Records
- Display Record Sets
- Update Records
- Run a Report
-
Lesson 3: Establishing Table Relationships
- Identify Table Relationships
- Identify Primary and Foreign Keys in the Relationships Window
- Working with Subdatasheets
-
Lesson 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
-
Lesson 5: Designing Forms
- Form Design Guidelines
- Create AutoForms
- Create a Form Using the Form Wizard
- Modify the Design of a Form
-
Lesson 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
-
Lesson 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
-
Lesson 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
-
Lesson 9: Controlling Data Entry
- Restrict Data Entry with Field Properties
- Create an Input Mask
- Create a Lookup Field
-
Lesson 10: Finding and Joining Data
- Find Data with Filters
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
-
Lesson 11: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
-
Lesson 12: Improving Your Forms
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add Command Buttons
- Create a Subform
-
Lesson 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
-
Lesson 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
- ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Project Management Practicalities
Quality Management
Lotus Notes 6 - Level 1
Lotus Notes 6.5 - Level 2 Databases
Outlook 2003
Filemaker Pro 7.0
PowerPoint 2003
Adobe PageMaker 7
Publisher 2003
QuarkXPress 6.0
Adobe Acrobat 7.0
Adobe Illustrator 10
Adobe Illustrator CS2
Adobe InDesign 2.0 - Level 1 (Macintosh)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.