D4-4/4
icanusesomehelp
D4-nstructons.pdf
4/1/2019 Project - CIS 118C04 Intro PC Application
Assignments ) Module 4 Capstone Project
Module 4 Capstone Project
Instructions
Overview
Ms. Chavez would like to track sales information in a database, rather than relying on Excel spreadsheets. She
heard it was easier and would cut down on data redundancy.
Objectives
1. Create, edit, and save a database
2. Create and run a Query
3. Apply basic formatting to a database
4. Create, modify and manipulate Tables in a database
5. Maintain a Database
6. Create, use and modify Forms in a database
Instructions
• Using the same information from Module 3 Capstone Project and in the Discussion for Module 4
(copied below), create a database to track the data, using the Tables and Fields created for the
Discussion.
• Create at least 2 related Tables.
• Create a Query showing all sales that occurred in Aurora. Name it City Sales Query.
• Create a Report based on the City Sales Query.
• Create a Form, using the Form Wizard to enter the information for each Realtor.
• Upload your completed Database to the assignment folder, naming it Move NOW! Sales Database.
HINTS: Start by creating the related Tables. If you changed your mind on how the Tables should be related or
the fields that should be in the Tables, based on the Discussion, you may change them here - they do not have
to be the same as you may have originally posted. You may use the Wizards to create the Form, Queries and
Reports.
Murray - Sold 8 houses in the cities shown at the prices below:
• Denver - 105,000
• Brighton - 352,000
1/4
4/1/2019 f'.AC iiilr."� Project- CIS118C04 Intro PC Applications • Lafayette - 785,000
• Lone Tree - 674,000
• Broomfield - 426,000
Gu led - Sold 4 houses at the following prices:
• Louisville - 738,000
• Broomfield - 123,800
• Aurora - 342,000
• Thornton - 569,000
Jones - Sold 5 houses at the following prices:
• Aurora - 1,782,072
• Denver - 922,000
• Broomfield - 728,200
• Lakewood - 255,000
• Thornt on - 499,000
• Hide Rubrics
Rubric Name: Module 4 Capstone Rubric
Criteria
Tables
[ �----
P - ro
_ fi
_ c
_ ie
_ n
_ t ____ ...,
Proficient - 10 points
Created 2 Tables with correct Fields
Table Relationships
( �-----
P - ro_fi_c_
ie_n_t ____ �
Proficient - 10 po ints
Created Table Relationships Correctly
[ Submit Cancel
Satisfactory
Satisfactory
Incomplete
Incomplete
https://ccco .desire2Iearn.com/d21/lms/dropbox/user/folder _ submit_files.d2I?db=1662277 &grpid=0&isprv=0&bp=0&ou=2311504
I 10
>
/ 10
)
2/4
4/1/2019 Module 4 Capstone Project- CIS118C04 Intro PC App�ations �-------------
[ Proficient Satisfactory
Proficient - 10 points
Created City Sales Query correctly
City Sales Report
[ Proficient Satisfactory Proficient - 10 points
Created City Sales Report based on City Sales Query
Form
Proficient Satisfactory
Proficient - 10 points
Created the Form to enter Realtor information correctly
Total
Overall Score
Level 3
14 points minimum
Level2
9 points minimum
Level 1
0 points minimum
Incomplete
Incomplete
Incomplete
/ 10
>
/ 10
>
I 10
>
I 50
3/4
