Management Information Systems Assignment ESSAY

Management Information Systems Assignment

Access Assignment (90 pts)

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 SalesReps using the following information:

RepID Last Name First Name Address City State ZIP Phone

1 Perry James 3453 E. State Jacksonville FL 32231 904-555-4353

2 Bauer Evan 5347 W. Grand Jacksonville FL 32232 904-555-3423

3 Dickens Sandra 2351 S. Ferguson Jacksonville FL 32232 904-555-5632

3. Create a table named Inventory with the data shown below, using the following guidelines:

a. Set up an autonumber to use for a primary key. b. Use a drop-down list to enter the condition. Possible conditions are Excellent,

Good, Fair, and Poor. c. Use a drop-down list for the sale representative ID. The drop-down list should

reference the RepID field in the SalesReps table for choices.

d. Create a relationship between RepID in two tables.

Make Model Year Description Condition Cost Selling Price Date

Arrived Date Sold RepID

Pontiac Grand Am 2011 4-Door, Red Excellent $8,000 $9,990 5/5/21 6/1/21 1

Lincoln Town Car 2010 2-Door, White Good $5,500 $5,995 4/18/21 4/25/21 3

Chevrolet Cavalier 2015 4-Door, Blue Excellent $17,000 5/18/21

Toyota Corolla 2010 4-Door, Black Fair $4,000 5/1/21

Ford Tempo 2008 2-Door, Red Poor $6,000 5/5/21

Chevrolet Lumina 2015 2-Door, White Excellent $18,500 5/12/21

Ford Focus 2013 5-Speed, Black Good $6,500 $7,000 4/20/21 4/30/21 1

Ford Escort 2009 2-Door, White Excellent $5,500 5/3/21

Plymouth Neon 2017 4-Door, Blue Good $16,500 5/1/21

Hyundai Sonata 2018 4-Door, White Excellent $14,500 10/21/21

2

4. Create a form to enter and edit inventory information. You decide on the design of the form.

5. Enter the following record into the Inventory table using the new form:

Make Model Year Description Condition Cost Selling Price Date

Arrived Date Sold RepID

Ford Taurus 2017 Wagon, Gray Excellent $18,200 8/20/21

6. The Chevrolet Lumina was sold on 5/20/21 by Bauer (RepID 2) for $19,300. Update the record using the form.

7. Save the form.

8. 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 time on the report. Hint: You may need to create a query to obtain the desired information, and then base the report on the query.

a. All inventoried vehicles, sorted by cost in descending order. b. All vehicles made by Chevrolet, sorted by cost in ascending order. c. All vehicles made by Ford, sorted by cost in ascending order.

9. Save the reports and your access file with your name (ex. “Access HW – your last name.accdb”

10. Your access file should include two tables (i.e., SalesReps and Inventory) and three reports.

Management Information Systems Assignment ESSAY

Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.

Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!

All our papers are written from scratch. We can cover any assignment/essay in your field of study.