PC applications- Module 4 capstone Access
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
- Create, edit, and save a database
- Create and run a Query
- Apply basic formatting to a database
- Create, modify and manipulate Tables in a database
- Maintain a Database
- 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 Dropbox, 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
Order from us and get better grades. We are the service you have been looking for.
