Access 97 Introduction

Course Description
Course Outline

Course 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 Introduction or equivalent knowledge.

Benefits

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

Target student

Students should understand the basic concepts involved in working with a personal computer. For example, they should be familiar with terms such as computer memory, data files, and program files. Students should also be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

What's next

Access 97 Introduction is the first course in this series. Access 97 Intermediate, the next course in this series, teaches students 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 VBA Programming, teaches students to create custom applications.

We offer a range of Access training courses

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 organise 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

Publisher:	Microsoft
Version:	97
Length:	1 Day
Course-ID:	052440

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The trainer is always very knowledgeable, not only about the subject being taught, but other related topics ... having the all round knowledge sets you apart. Thanks again

- Heart of England TEC