Overview: Students will learn the basic skills necessary to begin using Access 97. They will design and create databases, tables, queries, forms, and reports. This book was written using the Windows 95 platform; however, the manufacturer states that it can also be used with Windows NT.

Prerequisites:. Students should also be familiar with Windows 95, and be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

Benefits: Students learn how to create and use database objects, including tables, queries, forms, and reports.

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.

• Introduction to database concepts and terminology
• An introduction to Access 97
• Database planning and design
• Examining a table
• Creating a table with the Table Wizard
• Creating a table in Design View
• Types of primary keys
• Adding records
• Modifying the table design
• Finding and editing records
• Deleting, adding, and copying records and values
• Filtering and sorting records
• Refining the results of a query
• Using queries to perform calculations
• Joining tables in a query
• Creating a form: modifying the form design
• Using a form to locate and organize information
• Multiple-table forms
• Creating a report that contains totals
• Creating a database
• Copying objects
• Compacting a database