Access 97: Level 1

Code:

 ZD52-440

Series:

 Office Productivity

Duration:

 1 day
Overview of Access 97
Introduction to database concepts and terminology
An introduction to Access 97
Database planning and design

Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys

Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records

Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query 		Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms

Creating and using reports
Creating a report
Creating a report that contains totals

Database maintenance
Creating a database
Copying objects
Using Windows Explorer
Compacting a database

Access 97: Level 1
Course specifications
Course number: 52-440
Software version number: 97
Course length: 1 day

Certification
The combined content of the Access 97: Level 1, Access 97: Level 2, and Access 97: Advanced courses satisfies the requirements for the Certified Microsoft Office User for Access 97 at the Expert level.

Course description

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

Prerequisites:
Windows 95: Introduction or Windows 95: Transition or equivalent knowledge.

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

Benefits:
Students 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 (PC). 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 familiar with Windows 95, and be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

What's next:
Access 97: Level 1  is the first course in this series. Access 97: Level 2 , the next course in this series, teaches student 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.
Students who want to learn advanced features can take the third course in this series, Access 97: Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros.
The final course in this series, Access 97: Introduction to Application Design, teaches students to create custom applications.


Access 97: Level 1

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
  • Understand database concepts and terminology in Access 97.
  • Design and create tables.
  • Enter and manipulate data in tables.
  • Use Access queries to select and analyze information in a table.
  • Create data forms for viewing and inputting data.
  • Create reports that summarize and group data.
  • Perform database maintenance procedures.