(Answered) You have been asked by the owner of a pre-owned car

Engineering

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.
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 Number	Last Name	First Name	Address	City	State	ZIP	Phone
1	Perry	Jim	3453 E. State	Jacksonville	FL	32231	904-555-4353
2	Bauer	Evan	5347 W. Grand	Jacksonville	FL	32232	904-555-3423
3	Dickens	Billy	2351 S. Ferguson	Jacksonville	FL	32232	904-555-5632

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.

Make	Model	Yr	Description	Condition	Cost	Selling Price	Date Arrived	Date Sold	Sales Rep
Pontiac	Grand Am	2005	4-Door, Red	Excellent	$8,000	$9,990	5/5/08	6/1/08	Perry
Lincoln	Town Car	2001	2-Door, White	Good	$5,500	$5,995	4/15/08	4/20/08	Dickens
Chevrolet	Cavalier	2005	4-Door, Blue	Excellent	$7,000		5/15/08
Toyota	Corolla	2001	4-Door, Black	Fair	$4,000	$4,500	5/1/08
Ford	Tempo	2002	2-Door, Red	Poor	$2,000	$2,300	5/5/08
Chevrolet	Lumina	2005	2-Door, White	Excellent	$8,500		5/12/08
Ford	Focus	2003	5 Speed, Black	Good	$6,500	$7,000	4/20/08	4/30/08	Perry
Ford	Escort	2000	2-Door, White	Excellent	$5,500		5/3/08
Plymouth	Neon	2001	4-Door, Blue	Good	$6,500		5/1/08

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

Make	Model	Year	Description	Condition	Cost	Selling Price	Date Arrived	Date Sold	Sales Rep
Ford	Taurus LX	2003	Wagon, Gray	Excellent	$8,200		5/20/07

The Chevrolet Lumina was sold on 5/20/08 by Bauer for $9,300. Update the record using the form.
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.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M92178446
Price:- $40

Verified Expert

Priced at $80 Now at $40, Verified Solution

Have any Question?Write your Review or question?

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Ask Computer Engineering Expert

Engineering

Related Questions in Computer Engineering

Write a program that takes as input an xy center value and

You have been recently promoted to it security manager your

A national report indicates that the mean and standard

Do a system model in terms of states inputs outputs next

Submit a 2- to 3-page paper in which youidentify an

A standard 52 card playing deck assigns a unique

Question steve jobs was a strong charismatic leader who

Anbspwhen aqueous solutions (a) When aqueous solutions of Pb(NO 3 ) 2 and MnCl 2 are

Briefly explain the meaning of the t-test for regression

A decision maker has ordered every commodity in walmart