KEMBAR78
Used Car Sales: Project Description | PDF | Information Retrieval | Table (Database)
Scribd
Upload
88 views2 pages

Used Car Sales: Project Description

This document provides instructions for a 12-step project in Microsoft Access. The project involves analyzing used car sales data by creating queries and tables to calculate fields, summarize data, and sort records. Students are tasked with opening an Access database, designing queries to calculate total costs, monthly payments, and commission details, and modifying queries and tables to add totals. The instructions specify the tasks, point values, and expected outputs at each step. Completing all 12 steps earns a total of 100 points.

Uploaded by

ClausulaLover24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
88 views2 pages

Used Car Sales: Project Description

This document provides instructions for a 12-step project in Microsoft Access. The project involves analyzing used car sales data by creating queries and tables to calculate fields, summarize data, and sort records. Students are tasked with opening an Access database, designing queries to calculate total costs, monthly payments, and commission details, and modifying queries and tables to add totals. The instructions specify the tasks, point values, and expected outputs at each step. Completing all 12 steps earns a total of 100 points.

Uploaded by

ClausulaLover24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Office 2010 myitlab:grader Instructions

Exploring Access Ch. 03-IRCD Project

Used Car Sales


Project Description:
In this project, you will analyze data using queries and tables in a database for the Benson Used
Car Dealership. You will create calculated fields using the PMT, IIf, and DatePart functions.
Additionally, you will summarize data in a query and in a table.
Instructions:
For the purpose of grading of the project you are required to perform the following tasks:
Step

Points
Possible

Instructions

Start Access. Open the downloaded Access database named Exploring_a03_Grader_IR.accdb.

View the Payment Information query in Design view. In the first empty column of the query design grid,
create a TotalCost field that will calculate the sale price plus a sales tax of 8%. Run the query. Save the
query.

15

View the Payment Information query in Design view. In the next empty column of the query design
grid, create a field that will calculate the monthly payment for each car sold using the PMT function.
Enter the monthly rate as 0.04, the number of periods as 60, the present value is [TotalCost], the future
value is 0, and the type is 0. Name the field MonthlyPayment. Run the query. The results will be
negative values.

15

With the Payment Information query open in Datasheet view, change the width of the MonthlyPayment
field to 16.625. Save the query.

View the Payment Information query in Design view. In the next empty column of the query design
grid, create a field using the DatePart function. Enter "w" (including the quotes) as the interval and
[Sales Data]![SaleDate] as the date. Assume that the first day of the week and the first day of the year
are both 1 (the 3rd and 4th arguments). Name the field WeekdayOfSale. Run the query. Save and close
the query.

15

View the Commission Details query in Design view. In the first empty column of the query design grid,
create a field that will multiply the sale price by 0.1. Name the field Commission. Run the query. Save
the query.

15

View the Commission Details query in Design view. In the next empty column of the query design grid,
create a field using the IIf function that will display a $250 bonus (use $250 as a text) for agents every
time they sell a car for at least $20,000. Otherwise, the function will return a 0. Name the field Bonus.
Run the query. Save the query.

15

View the Commission Details query in Design view. Display the Total row in the query design window,
and then sum the SalePrice, Commission, and Bonus fields. Run the query. Save the query.

12

With the Commission Details query open in Datasheet view, add the Total row to the bottom of the
table, and then sum the Commission and Bonus columns. Save and close the query.

Updated on: 5/8/2012

A_CH03_EXPV1_IRCD_Instructions.docx

Office 2010 myitlab:grader Instructions

Step

Exploring Access Ch. 03-IRCD Project

Points
Possible

Instructions

10

View the Sales Data table in Datasheet view, and then sort the Agent_LName column in ascending
order.

11

With the Sales Data table open in Datasheet view, add the Total row to the bottom of the table, and then
sum the SalePrice column. Save and close the table.

12

Close the database and then exit Access. Submit the database as directed.

0
Total Points

Updated on: 5/8/2012

100

A_CH03_EXPV1_IRCD_Instructions.docx

You might also like