Lesson 10 project | Accounting homework help

 PART 1

In this hands-on project, you will be creating a new database.  The purpose of this database is to keep track of vehicles in inventory at the RSC Used Car Dealership.  You will be completing the following tasks in Microsoft Access:

  • Creating a table
  • Adding records to the table
  • Modifying records
  • Deleting records 
  • Sorting data
  • Filtering data
  • Backup, save, compact, and repair your database

Project Preparation

  1. Open Microsoft Access and select a new Blank Desktop Database. Do not use a template. 
  2. Save your file as “Lesson10_Project1_MEID.accdb” where MEID is your actual MEID.

Project Directions

  1. Add the following fields (field types provided below) to Table 1:
    • VIN Number – Short Text
    • Vehicle Make – Short Text
    • Vehicle Model – Short Text
    • Vehicle Year – Short Text
    • Purchase Price – Currency
    • Selling Price – Currency
    • Mileage – Number
  2. Change the ID field Name (Default record ID assigned by Access) to VEHICLE ID.
  3. Set Vehicle ID as the primary key. 
  4. Add the following records to Table 1. ( see attachment lesson 10 pic 1) 
  5. Save the table with Table Name “Vehicle Inventory”.
  6. Edit the selling price on record 5 to $15,300.00.
  7. Delete record number 2.
  8. Sort the table Descending, from newest to oldest Year. 
  9. Filter the table to show only Honda vehicles. 
  10. Compact, Repair and Save your database. 
  11. Submit the assignment based on the instructions provided. 

PART 2

In this hands-on project, you will be creating a new database and completing the following tasks in Microsoft Access:

  • Importing data into a database
  • Formatting tables
  • Creating table relationships
  • Backing up, saving, compacting, and repairing your database

Project Preparation

  1. Open Microsoft Access and open a new Blank Desktop Database. Do not use a template. 
  2. Save your file as “Lesson10_Project2_MEID.accdb” where MEID is your MEID.
  3. Download the L10_Project2_DataFiles.zip (see EXCEL attachment) data files to your course lesson folder. 
  4. Extract the two data files to your course lesson folder. 

Project Directions

  1. From the External Data Tab, Import the L10-Hands On Project2_Data File1.xlsx data file into your database. Import the Excel data into a new table in the current database.
  2. Accept all of the default options as you proceed through the rest of the import. 
  3. Save the table with the name “Test Scores”.
  4. Select a background color of your choice (not the default color). 
  5. Select alternate Background color of your choice (not the default color).
  6. Select Gridline color of your choice (not the default color).
  7. Click OK. (Note: The Teaching Assignments table in the navigation pane illustrated below will be added after Step 12). ( SEE ATTACHMENT LESSON 10 PIC2)
  8. From the External Data Tab, Import the L10-Hands On Project2_Data File2.xlsx data file into your database.  Import the Excel data into a new table in the current database.
  9. Accept the default options as you proceed through the rest of the import.  You will need to ensure “First Row Contains Column Headings” is selected during your import procedure.
  10. Save the table with the name “Teaching Assignments”.
  11. Adjust fields on both of the tables so all data and field headings are visible. 
  12. Create a relationship between the Teaching Assignments Table and Test Scores.  Join the Subject 1 Field with the Test Name Field. 
  13. Create another relationship between the Teaching Assignments Table and Test Scores. Join the Subject 2 Field with the Test Name Field. 
  14. Save and close the Relationships window. 
  15. Compact, Repair and Save your database.
  16. Submit the assignment based on the instructions provided.
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
×

Contact Us on WhatsApp

× How can I help you?