Access 2003 Level 1

You will be introduced to the concept of the relational database by using Access 2003 relational database application & its information management tools. Then you'll consider how to design & create a new Access database, how to customize its components..

Course Outline

Day 1- (Nonconsecutive days) Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.
Day 2- 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.

Introducing the Acend Modern Classroom

Classes Guaranteed to Run

An assessment process takes place at the start of class that results in the creation of a personalized learning plan for each participant . We integrate each individual's specific project objectives with their skill gaps to create the learning prescription. The instructor assumes the role of consultant and guides each participant through the process of filling the critical gaps identified in the learning plan.

Course Content

Day 1:

Lesson 1: An Overview of Access 2003

• Topic 1A: Understand Relational Databases
• Topic 1B: Examine the Access Environment
• Topic 1C: Open the Database Environment
• Topic 1D: Examine an Access Table

Lesson 2: Managing Data

• Topic 2A: Examine an Access Form
• Topic 2B: Add and Delete Records
• Topic 2C: Sort Records
• Topic 2D: Display Record sets
• Topic 2E: Update Records
• Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships

• Topic 3A: Identify Table Relationships
• Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
• Topic 3C: Work with Subdatasheets

Lesson 4: Querying the Database

• Topic 4A: Create a Select Query
• Topic 4B: Add Criteria to a Query
• Topic 4C: Add a Calculated Field to a Query
• Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

• Topic 5A: Examine Form Design Guidelines
• Topic 5B: Create a Form Using AutoForm
• Topic 5C: Create a Form Using the Form Wizard
• Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports

• Topic 6A: Create an AutoReport
• Topic 6B: Create a Report by Using the Wizard
• Topic 6C: Examine a Report in Design View
• Topic 6D: Add a Calculated Field to a Report
• Topic 6E: Modify the Format Properties of a Control
• Topic 6F: AutoFormat a Report
• Topic 6G: Adjust the Width of a Report

Appendix A: Microsoft Office Specialist Program

Day 2:

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

Appendix A: Microsoft Office Specialist Program

Additional Details

Pre-Requisites

Certificates offered

Certificate of completion

Cancellation Policy

Cancellations or postponements received more than ten business days prior to the first day of the course will be subject to a 15% administration fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.

Map & Reviews

Acend Corporate Learning
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

The amount of material was a little much (maybe an hour) to cover in the allotted time - but otherwise good.

Reviewed by Lisa K. 2011

   

The room was too cold for me. The Instructor was very helpful.

Reviewed by Agnes S. 2011

   

A co worker of mine, did not receive the certificate of completing the course. As well, I received a website to log to after the course for 30 days (The Online Support). Although the vendor ID number does not exisit. I have gone back to my contact at Last Minute Training, and haven't received any feedback from her. The course was good, the follow up, was the greatest service.

Reviewed by Jennifer S. 2011

   

Would like to have access to the on-line training materials for this course for a period of time after course completion

Reviewed by Sandra B. 2011

   

Hi - the server crashed during my session and I would like to reschedule. Can someone contact me to do this?

Reviewed by Maura A. 2011