Categories
Writers Solution

Create Lookup Fields

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.

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service? 
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay.
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays