Microsoft Access 2003 Level 1
Overview of Access 2003
Introduction to database concepts and terminology
An introduction to Access 2003
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
Creating and maintaining a database
Creating a database
Managing a database and its objects
Database maintenance
Class Information
Duration: 1 day
Prerequisite: Basic knowledge of the windows environment, basic keyboard skills.
Course Materials: Course manual (074460S3)
Description: This class is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.
Student Comments
Mr. Black is very professional and has thorough knowledge of this program. Excellent job!
—Access, Level 1
Great experience. Enjoyed the class immensely and would like to go to the second level of Access.
—Access, Level 1
Sally Dicken the instructor taught us at an appropriate pace. She was energetic and very methodical.
—Access, Level 1