Managing Critical Business Information Using Microsoft Office Access 2003

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

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

Course Description:

'' In this course, students learn how to create solid database structures, pull in outside data, and integrate Access with other Microsoft Office System 2003 applications, leading up to creating flexible, user-friendly reports.

Pre-requisites:


Outline:

Lesson 1: Creating a Strong Foundation for Your Database
- What Is a Relational Database?
- Demonstration: Creating Tables and Using the Relationships Window
- Expert Video: Importance of Using Relationships and Referential Integrity
- Types of Files Commonly Imported or Linked to Access
- Exercise: Importing a Text File and Excel Data
- Best Practices for Creating Tables and Utilizing Outside Data

Lesson 2: Creating an Effective User Interface
- Good Form Design
- Mapping Out the Forms to Use in the Fourth Coffee Database
- Exercise 1: Creating the Necessary Input Forms
- Exercise 2: Creating the Main Switchboard and Setting Startup Properties
- Best Practices for Creating User Interfaces

Lesson 3: Organizing Data Though Queries
- Choosing the Right Type of Query for the Task at Hand
- Exercise 1: Creating Select and Totals Queries
- Retrieving Only the Information That You Want
- Exercise 2: Adding Criteria to Queries
- Exercise 3: Using Forms and Controls for Criteria
- Exercise 4: Adding Data by Using an Append Query
- Best Practices for Using Queries to Their Fullest Potential

Lesson 4: Reporting Strategic Information with Access
- Generating Reports That Display Strategic Information
- Exercise 1: Generating the Base Report
- Demonstration: Touring Report Design View
- Exercise 2: Creating a Macro to Companies Only on the Report

Lesson 5: Integrating Access with other Office Applications
- Integration with Other Office Applications
- Exercise 1: Publishing Information Using Word and Excel
- Exercise 2: Creating a Custom Toolbar for Office Links and Mail Recipient
- Exercise 3: Performing Mail Merge Between Access and Word
- Best Practices for Avoiding the Pitfalls of Integration

...''

Phone:1300 794 006

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

9 Denison Street,
Newcastle West NSW 2302


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

Search other schools for Managing Critical Business Information Using Microsoft Office Access 2003 training resources.

SharePoint 2007
QuarkXPress 6.0
Microsoft Office 2007
MS Word 2007
Windows Vista
Microsoft Expression Web 2007
Team Collaboration Using Microsoft Windows SharePoint Services
Forecasting and Trend Analysis using Microsoft Office Excel 2003
Access 2007
Lotus Notes 7
VBA ACCESS 2003
Managing Financial Information Using Microsoft Office Access 2003
Web Design with XHTML, HTML, and CSS
Time and Task Management Using Microsoft Office Outlook 2003
XML
FileMaker Pro 7.0
Presentations Using Microsoft Office PowerPoint 2003
Online Merchandising Using Microsoft Office FrontPage 2003
Adobe Photoshop CS3

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.