Access 2002 Introduction

Course Description
Course Outline

Course Overview

This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to start creating databases in Access and working with data using tables, queries, forms, and reports.

Prerequisites

Windows Introduction or equivalent knowledge.

Benefits

Access, like other relational database management systems, is not easy to learn on your own. There are concepts and theories about relational databases that are essential to working with these data repositories. Even if you will only be using a database created by someone else, understanding how a database is designed and structured will make your work easier and help you troubleshoot any data problems you might encounter. Almost all users of Access need to create queries, forms, or reports, and this course will get you started.

Target student

People who want to use Access to create a database to hold information on a subject, and/or want to learn the basic skills needed to maintain and report on data in an Access database.

What's next

Access 2002 Introduction is the first course in this series. Access 2002 Intermediate, the next course in this series, teaches students how to enhance their database designs. Students who want to learn advanced features can take the third course in this series, Access 2002 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 2002 VBA Programming, teaches students to create custom applications.

We offer a range of Access training courses

Working with a Relational Database
Identify Uses of a Relational Database Define Database Terminology Create a New Database Based on a Template Examine the New Database
Planning a Database
Identify Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize the Data Designate Primary and Foreign Keys Identify Table Relationships
Building the Basic Structure
Create a Blank Database Create a Table using a Wizard Compare Datasheet and Design Views Create Tables in Design View Create Relationships between Tables
Working with Tables
Modify a Table Design Work in Datasheet View Work with Subdatasheets
Creating and Working with Select Queries
Examine a Query Create a Query using a Wizard Work in Query Design View Select Records Edit Values in a Query Datasheet Add a Calculated Field to a Query Perform a Calculation for a Group of Records
Creating and Using Forms
Create AutoForms Create a Form Using a Wizard Modify the Design of the Form Use Forms to Work with Data
Creating and Using Reports
Create an AutoReport Create a Report Using a Wizard Examine a Report in Design View Create a Calculated Field Change the Format of a Control Change the Style of a Report Adjust Report Width

Publisher:	Microsoft
Version:	2002 (XP)
Length:	1 day
Course-ID:	084400

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Small group, relaxed and open atmosphere. Felt comfortable admitting being lost or confused

- British Gas