Cashback Offer from 10th to 18th May 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question Details Normal
$ 10.00

CIS223 Unit 4 Assignment

Question posted by
Online Tutor Profile
  1. You have been asked by the owner of a pre-owned car dealership to set up a way to track the cars in his inventory. He often needs to search his records for specific makes and models or cars made in certain years. He also wants to be able to generate reports based on his sales and reports on which sales representatives are doing the most business.
  2. Create a new Access database and set up a table named Sales Rep. Be sure to create attributes, set a primary key, select data types, and add descriptions as necessary. Use the following information:

Rep NumberLast NameFirst NameAddressCityStateZIPPhone

1PerryJim3453 E. StateJacksonvilleFL32231904-555-4353

2BauerEvan5347 W. GrandJacksonvilleFL32232904-555-3423

3DickensBilly2351 S. FergusonJacksonvilleFL32232904-555-5632

  1. Create a table named Inventory using the instructions above. Use the data shown below, with the following guidelines:
    1. Set up an auto number to use for a primary key.
    2. Use a drop-down list to enter the condition. Possible conditions are Excellent, Good, Fair, and Poor.


MakeModelYrDescriptionConditionCostSelling PriceDate ArrivedDate SoldSales Rep

PontiacGrand Am20054-Door, RedExcellent$8,000$9,9905/5/086/1/08Perry

LincolnTown Car20012-Door, WhiteGood$5,500$5,9954/15/084/20/08Dickens

ChevroletCavalier20054-Door, BlueExcellent$7,0005/15/08

ToyotaCorolla20014-Door, BlackFair$4,000$4,5005/1/08

FordTempo20022-Door, RedPoor$2,000$2,3005/5/08

ChevroletLumina20052-Door, WhiteExcellent$8,5005/12/08

FordFocus20035 Speed, BlackGood$6,500$7,0004/20/084/30/08Perry

FordEscort20002-Door, WhiteExcellent$5,5005/3/08

PlymouthNeon20014-Door, BlueGood$6,5005/1/08

  1. Create a one-to-many relationship between SALES_REP and INVENTORY.
  2. Create a form to enter and edit inventory information. You decide on the design of the form.
  3. Enter the following record into the Inventory table using the new form:


MakeModelYearDescriptionConditionCostSelling PriceDate ArrivedDate SoldSales Rep

FordTaurus LX2003Wagon, GrayExcellent$8,2005/20/07

  1. The Chevrolet Lumina was sold on 5/20/08 by Bauer for $9,300. Update the record using the form.
  2. Create the following reports using whatever method you prefer. Format the reports so that information is easy to find, give each report an applicable title, and include the date and your name on the report. Hint: You need to create a query to obtain the desired information, and then base the report on the query.
    1. All vehicles available for sale with a selling price less than $6,000, sorted by cost in descending order.
    2. All vehicles sold, grouped by Sales Rep.
    3. All vehicles made by Ford and Toyota.

Submit your Access database file (.accdb) following the instructions below.

Upload Instructions:

Select the Submit Assignment button to the right. Click Choose File, located in the File Upload box. Navigate to your file location. Once the file is located, select it and then select the Open button. Click Submit Assignment to complete the upload process.

Available Answers
$ 10.00

[Solved] CIS223 Unit 4 Assignment

  • This Solution has been Purchased 3 time
  • Average Rating for this solution is A+
  • Submitted On 08 Feb, 2017 03:15:11
Answer posted by
Online Tutor Profile
Unit 4 Assignment 1. You have been asked by the owner of a pre-owned car dealership to set up a way to track the cars in his inventory. He ofte...
Buy now to view the complete solution
Other Related Questions

The benefits of buying study notes from CourseMerit

Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
Only 45 characters allowed.

$ 629.35