Access 2000: Introduction

Course Specifications:

Courseware: Access 2000: Level 1

Software: Microsoft Access 2000

Course length: 1 day

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

Course Description:

Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Course Objective:

Students will learn how to create and use database objects, including tables, queries, forms, and reports.

Target Student:

Students enrolling in this course should understand the basic concepts involved in working with a personal computer. For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

Prerequisites:

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

  1. Windows 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: Overview of Access 2000

  1. Topic 1A: Introduction to database concepts and terminology
  2. Topic 1B: An introduction to Access 2000
  3. Topic 1C: Database planning and design

Lesson 2: Creating tables

  1. Topic 2A: Examining a table
  2. Topic 2B: Creating a table with the Table Wizard
  3. Topic 2C: Creating a table in Design View
  4. Topic 2D: Types of primary keys

Lesson 3: Working with tables

  1. Topic 3A: Adding records
  2. Topic 3B: Modifying the table design
  3. Topic 3C: Finding and editing records
  4. Topic 3D: Deleting, adding, and copying records and values
  5. Topic 3E: Filtering and sorting records

Lesson 4: Using select queries

  1. Topic 4A: Selecting fields and sorting records
  2. Topic 4B: Refining the results of a query
  3. Topic 4C: Using queries to perform calculations
  4. Topic 4D: Joining tables in a query

Lesson 5: Creating and using forms

  1. Topic 5A: Creating a form
  2. Topic 5B: Modifying the form design
  3. Topic 5C: Using a form to locate and organize information
  4. Topic 5D: Multiple-table forms

Lesson 6: Creating and using reports

  1. Topic 6A: Creating a report
  2. Topic 6B: Creating a report that contains totals

Lesson 7: Creating and maintaining a database

  1. Topic 7A: Creating a database
  2. Topic 7B: Managing a database and its objects
  3. Topic 7C: Database maintenance