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 the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more