DUET44

Chavez at Move NOW! that will track the

sales by city and by realtor, using the same

data you used in Module 3 shown below.

Murray - Sold 8 liouses in the cities shown

at the prices below:

٠ Denver - 1ه5,ه0ه

٠ Brigliton - 352,٥٥٥

٠ Louisville - 647,٥٥٥

٠ Aurora - 529,00٥

٠ Lakewood - 272,000

٠ Lafayette - 785,٥00

٠ lone Tree - 674,٥٥٥

٠ Broomfie!d - 426,0٥٥

Gu!ed - So!d 4 houses at the fo!!owlng

pdces:

٠ Lous!v!!!e-738,٥0٥

٠ Broomfie!d - 123,800

٠ Aurora - 342,000

٠ Thornton - 569,000

Jones - So!d 5 houses at the fo!!ow!ng

prices:

٠ Aurora - 1,782,072

٠ Denver - 922,000

٠ Broomfield - 728,200

٠ Lakewood - 255,000

٠ Thornton-499,000

Part ٥ne: Database requirements and Inỉtìa!

Post Requirements:

٠ Describe, in detail, the purpose of this

database and its intended use.

٠ Describe what reports you intend to

run using this database.

٠ Describe, in detail, why Access would

be a better soludon than Excel for this

project.

٠ Use Microsoft Word to idendfy the

name of each of the Tables in your

database. Under each Table name, list

the fields contained In the table.

٠ Your database must have at least two

Tables, and should show the

relationship between the two tables.

You should learn a lot in this discussion, as

there will be differing ideas on exactly how

this should be done. I strongly recommend

reading All classmates' posts on this for

better understanding.