Overview In Module 1, you started a database as part of the Capstone Project. You will use your same database for this Capstone Project, as well as the Database Design you created in Module 1 Discussi

Overview

In Module 1, you started a database as part of the Capstone Project. You will use your same database for this Capstone Project, as well as the Database Design you created in Module 1 Discussion. Part of developing and using a database is understanding the connectivity and relationship of various parts of the database. In the Capstone Projects, you will be working on your own database and making your own decisions on what you need based on the purpose of the database.

Objectives

1. Create, modify, and print Reports and Forms
2. Add fields to reports or forms, group and sort data
3. Format and move controls
4. Create and modify a form with a subform in Design view
5. Use the input Mask Wizard
6. Add Yes/No, Long Text, OLE Object and Attachment fields and use in a query

Instructions

Using the database design you started in Module 1, add the remainder of the Tables and Fields you believe you will need in your database to your design. If you miss something, it can be added later, but try to identify all the fields you may need, as well as the Table relationships.

Update your database to include the changes you made to the database design, including changes in Tables, Forms, Reports, Queries, by adding the following.

• Add Fields
• Create Lookup Fields
• Add a Multivalued Field
• Change Field Size using Validation Rules
• Specify a Default Value
• Specify a Format
• Create a Form based on more than one Table
• Write a summary of changes you made, indicating which Table, Form, Report or Query you added or modified, and the reasons you chose these modifications.

Upload your completed database and summary to the folder.