Course description
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 95, 98 or 2000: Introduction or equivalent knowledge.
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also
provide a means to
evaluate learning. Upon successful completion of this course, students will
be able to:
· Understand database concepts and terminology in Access 97.
· Design and create tables.
· Enter and manipulate data in tables.
· Use Access queries to select and analyze information in a table.
· Create data forms for viewing and inputting data.
· Create reports that summarize and group data.
· Perform database maintenance procedures.
Lesson 1: Overview of Access 97
Introduction to database concepts and terminology
An introduction to Access 97
Database planning and design
Lesson 2: Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys
Lesson 3: Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records
Lesson 4: Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query
Lesson 5: Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms
Lesson 6: Creating and using reports
Creating a report
Creating a report that contains totals
Lesson 7: Database maintenance
Creating a database
Copying objects
Using Windows Explorer
Compacting a database