Access 2000: Intermediate

  • The page you requested does not exist. A search for Application OR Development OR ELearning resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR ELearning OR Resources OR tabid OR 142 OR Blog OR Date OR 2008 OR 02 OR 29 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR ELearning OR Resources OR tabid OR 142 OR Entry OR ID OR 56 OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Government OR Solutions OR Government OR Clients resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Learning OR Center OR Tips OR Traps OR tabid OR 137 OR Blog OR Date OR 2010 OR 06 OR 30 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Learning OR Center OR Tips OR Traps OR tabid OR 137 OR Blog OR Date OR 2008 OR 06 OR 30 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Learning OR Center OR Tips OR Traps OR tabid OR 137 OR Blog OR Date OR 2010 OR 03 OR 31 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Link OR Click OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR ELearning OR Resources OR tabid OR 142 OR Blog OR Date OR 2008 OR 04 OR 30 OR Date OR Type OR month OR Default OR aspx resulted in this page.

Course Specifications:

Courseware: Access 2000: Level 2

Software: Microsoft Access 2000

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet.

Course Objective:

Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks.

Target Student:

Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports.

Prerequisites:

To ensure the successful completion of Access 200: Intermediate, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2000: Introduction

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Principles of table design

  1. Topic 1A: Normalizing data
  2. Topic 1B: Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

  1. Topic 2A: Analyzing table relationships
  2. Topic 2B: Establishing and testing referential integrity

Lesson 3: Table design techniques

  1. Topic 3A: Data validation techniques
  2. Topic 3B: Indexing techniques

Lesson 4: Designing select queries

  1. Topic 4A: Using calculated fields in queries
  2. Topic 4B: Creating multiple-table queries

Lesson 5: Customizing form designs

  1. Topic 5A: Customizing the form design
  2. Topic 5B: Performing calculations on a form
  3. Topic 5C: Adding combo boxes to a form
  4. Topic 5D: Adding unbound controls

Lesson 6: Working with data access pages

  1. Topic 6A: Creating data access pages

Lesson 7: Customizing reports

  1. Topic 7A: Customizing a report created by the Report Wizard
  2. Topic 7B: Working with subreports