Learn: in:
» back to Search Results

Course rating of 3 Vendor rating of 4

In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Course Outline
As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Course Objective:
You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft Office Access 2003 with other applications.

Target Student:
Microsoft Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. 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.

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

follow the steps required to properly design a simple database.
create a new database with related tables.
control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
find and retrieve desired data by using filters and joins between tables and within a single table.
create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
enhance the appearance, data entry, and data access capabilities of your forms.
customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
use Access data in other applications, including Microsoft Word and Excel.
Course Content
Lesson 1: Planning a Database

  • Topic 1A: Design a Relational Database
  • Topic 1B: Identify Database Purpose
  • Topic 1C: Review Existing Data
  • Topic 1D: Determine Fields
  • Topic 1E: Group Fields into Tables
  • Topic 1F: Normalize the Data
  • Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
  • Topic 2A: Create a New Database
  • Topic 2B: Create a Table Using a Wizard
  • Topic 2C: Create Tables in Design View
  • Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
  • Topic 3A: Restrict Data Entry with Field Properties
  • Topic 3B: Create an Input Mask
  • Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
  • Topic 4A: Find Data with Filters
  • Topic 4B: Create Query Joins
  • Topic 4C: Join Unrelated Tables
  • Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
  • Topic 5A: Set Select Query Properties
  • Topic 5B: Create Parameter Queries
  • Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
  • Topic 6A: Enhance the Appearance of a Form
  • Topic 6B: Restrict Data Entry in Forms
  • Topic 6C: Add Command Buttons
  • Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
  • Topic 7A: Organize Report Information
  • Topic 7B: Set Report Control Properties
  • Topic 7C: Control Report Pagination
  • Topic 7D: Summarize Information
  • Topic 7E: Add a Subreport to an Existing Report
  • Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
  • Topic 8A: Publish Access Data as a Word Document
  • Topic 8B: Analyze Access Data in Excel
  • Topic 8C: Export Data to a Text File
  • Topic 8D: Merge Access Data with a Word Document 

Prerequisites & Certificates

To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source:
Microsoft Access 2003: Level 1 A basic understanding of Microsoft Excel and Microsoft Word would also be helpful, but is not required.

Certificates offered

Certificate of completion

Cancellation Policy
Cancellation Policy & Satisfaction Guarantee
You may cancel or reschedule your registration without penalty up to 5 business days before your class date.

Training Details
ASAP Training Ltd. is located at 950 - 167 Lombard Avenue, in Exchange District. A training manual is provided. We encourage all students to bring in a USB stick for student files as we no longer hand out course files on a CD.

Finding Us
ASAP Training Ltd. is located in the picturesque downtown Exchange District at 950-167 Lombard Avenue, in the Grain Exchange Building, you can access the building from Rorie Street and Lombard Avenue.

Class Times and Other Details
ASAP Training Ltd. classes begin promptly at 8:30 am and end around 4:00 pm. Our doors open at 8:00 am. Coffee and tea are provided for students. We have a kitchen with a microwave and refrigerator available for student use if they wish to bring their own lunch. Lunch break is one hour from approximately 11:30 to 12:30. A telephone and sitting area are available for student use. Our office is a non-smoking facility and is wheelchair accessible.

There are many restaurants available within walking distance of the school.

For your convenience, we have also provided a map of the available Parking Lots in proximity to the Grain Exchange Building, indoor and outdoor parking.
Map & Reviews
ASAP Training.ca
[ View Provider's Profile ]

The Instructor read the lessons straight from the book. I could have done that on my own. He made quite a few mistakes that were corrected by the students. Did not know how to troubleshoot and provided limited answers to questions. It was obvious he did not know this subject well enough.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 2317 times.