Access 2003: Introduction

Learning Outcomes:

• Accurately define database theory given a set of questions.

• The learner will demonstrate mastery in creating and editing tables through class exercises.

• Using a set of criteria, successfully analyze the data to be stored and apply that analysis to create an effective table design.

• Use information provided in the exercises to demonstrate the ability to design and customize forms to apply to specific applications.

Students will design and create databases, tables, queries, forms, and reports. This one day course contributes toward the Microsoft Proficiency Guidelines for Access 2003.

* Working with a Relational Database
* Database Terminology
* Create a New Database Based on a Template
* Planning a Database
* Examine an Access Form
* Building the Basic Structure
* Identify Table Relationships
* Creating and working with Select Queries
* Create Auto Forms and use the Form Wizard
* Creating and using Reports

Access 2003: Introduction

Learn Microsoft's database management system, starting with a primer of database theory. Explore Access's objects such as tables, forms, reports, and queries. Learn how to create a table, and how to modify your tables already made. Learn to find and edit specific pieces of information from your tables. Next is what to consider when making tables - we'll explore data validation principles Learn queries, how to develop, use, and print them. Explore form creation. Customize how your forms will look and function. Next, we create custom reports to detail your data. Create a query and a form using a Wizard. Report modification is covered to format your data the way you want it. Create an AutoReport and a Report using a Wizard.

Class targeted to:

Students enrolling in this course should understand the basic concepts involved in working with a personal computer. Students should also be somewhat familiar with databases and how they are utilized.

Prerequisites:

Students should be comfortable working in the Windows environment.