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

OverviewIn 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.ObjectivesCreate, modify, and print Reports and FormsAdd fields to reports or forms, group and sort dataFormat and move controlsCreate and modify a form with a subform in Design viewUse the input Mask WizardAdd Yes/No, Long Text, OLE Object and Attachment fields and use in a queryInstructionsUsing 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 FieldsCreate Lookup FieldsAdd a Multivalued FieldChange Field Size using Validation RulesSpecify a Default ValueSpecify a FormatCreate a Form based on more than one TableWrite 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.

Looking for this or a Similar Assignment? Click below to Place your Order

Open chat