Create a query showing all sales that occurred in aurora

Assignment Help Management Information Sys

Reference no: EM132273599

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

• 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

• Thornton - 499,000

Reference no: EM132273599

Questions Cloud

Identify two companies that have time-based strategies : Identify two companies that have time-based strategies, and two that have quality-based strategies.

What is inventory accumulation or decumulation : If Y is 1,500, what is planned spending? What is inventory accumulation or decumulation? Should equilibrium Y be higher or lower than 1,500?

Examine the major design flaws and features of the airline : Describe the key factors that constitute a user friendly check-in experience. Examine the major design flaws and features of the airline you researched.

Research the laws and regulations : Research the laws and regulations that require care providers to override patient confidentiality and privacy rights, such as is the case in New York.

Create a query showing all sales that occurred in aurora : Create at least 2 related Tables. Create a Query showing all sales that occurred in Aurora. Name it City Sales Query.

Comments ending up on facebook about patients : Perhaps you have heard about pictures and comments ending up on Facebook about patients.

Pros and cons of the current highway funding structure : What are the pros and cons of the current highway funding structure as related the taxes paid by motor carries?

Write a report detailing steps jack needs to take to gather : Write a one-page report detailing the steps Jack needs to take to gather all of the appropriate evidence and protect his company.

Summarize the importance of the fourth amendment : Summarize the importance of the fourth amendment, specifically as it applies to a forensic investigation.

User Account

All Pages