• 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
• Louisville - 647,000
• Aurora - 529,000
• Lakewood - 272,000
• Lafayette - 785,000
• Lone Tree - 674,000
• Broomfield - 426,000

Guled - 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
• Thornton - 499,000

WOULD NEED TO BE DONE ON MC ACCESS