Week 5 Analysis

Week analysis 5.1

Purpose

The purpose of this assignment is to assess your ability to:

• Identify Good Database Design.
• Create an Entire Database With Tables, Queries, Forms, and Reports.
• Demonstrate Your Knowledge of a Database in an Oral Presentation.
• Create a Table and Define Fields in a New Database.
• Modify Existing Tables.
• Create Table Relationships.
• Change Data Types.
• Create a Lookup Field.
• Set Field Properties.
• Create a Query in Design View.
• Specify Criteria in a Query.
• Use Compound Criteria.
• Create a Query Based on More Than One Table.
• Use Calculated Fields in a Query.
• Use Aggregate Functions in a Query.
• Create a Parameter Query.
• Create and Use a Form to Add and Delete Records.
• Modify a Form in layout View and in Design View.
• Create a Report by Using the Blank Report Tool and the Report Wizard.
• Create a Form in Design View.
• Format a Form.
• Make a Form User Friendly.
• Create Validation Rules and Validation Text.
• Create a Switchboard with Buttons to Open the Database.

Action Items

1. First, you need to choose one of the following databases to create. Each database option contains a list of all of the components that must be included in your completed database. These projects are roughly equivalent in difficulty.
   

   Database Information – Dentist Office

   OR

   Database Information – Superheros

   OR

   Database Information – Pet vet

2. Complete steps 1 through 9 as outlined in each of the project files.