Byron Employment

Byron Employment. Over 71,905 Jobs Australia Wide.

Delivery Method

  • Classroom

Overview

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.

Learning Method

Instructor Led

Schedule

Group Bookings Only - All States and Territories of Australia

Duration

½ Day

Pre-requisites

A working familiarity with standard Microsoft Office applications (such as Outlook, Word and Excel), as well as a general awareness of Web navigation tools, such as Microsoft Internet Explorer.
A basic understanding of relational databases.
An understanding of Access tables, queries, forms and reports and a base knowledge of how they are used within an Access database.
Experience creating Access macros and using them in forms.

Outline

Lesson 1: Creating a Strong Foundation for Your Database
- What Is a Relational Database?
- Demonstration: Creating Tables and Using the Relationships Window
- Expert Vide 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

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search