Using Microsoft Access 2003
Day 1: Introduction and Beyond
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills. Familiarity with the Access environment is helpful but not required. |
| Course Materials: | Training book (350 pages) and handouts. |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will learn how to create simple tables, how to create a simple form as an easy-to-use interface to get more information into your database, how to manipulate data by creating queries and how to create basic reports. This is not a class for developers who need to learn how to design a database. This is a class for end-uses who what to learn how to use an existing Access database. You have the option of taking all 3 days of training (highly recommended), or cherry-picking topics for a 1 or 2 day custom course. If you just want an Introduction to Microsoft Access, we can put together that class as well. |
Creating Databases
- A Tour of an Access Database
- Creating a New Database
- Starting with a Wizard
- Modifying the Wizard's Database
- Starting from a Blank Database
Creating Tables to Hold Data
- Planning Your Tables
- Creating Tables with the Wizard
- Creating Tables in the Design Window
- Adding and Editing Table Data
- Changing How a Table Displays Data
Creating Forms to Add and Display Data
- Form Basics
- Creating Autoforms
- Creating Forms with the Form Wizard
- Modifying the Form Design
- Creating Forms in Design View
Linking Tables to Combine Data
- Why Relate?
- A Relational Database Tour
- Linking Tables in the Relationships Window
- Using Subdatasheets to View Related Items
- Creating Subforms
- Organizing Information
Sorting and Filtering
- Sorting Database Records
- Finding Data with Filters
Finding Data with Queries
- Types of Queries
- Setting Query Properties
- Creating Queries with the Query Wizard
- Saving, Deleting, and Printing Queries
Generating Reports
- View an Access Report
- Create a Report
- Create a Report Using the Report Wizard