Lesson 10 project | Accounting homework help

 PART 1

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Order a unique copy of this paper
(550 words)

Approximate price: $22

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

It's no longer good enough to create a high-quality product at a reasonable cost.
That is why we have created 9 compelling warranties to make your usage of our service pleasant, simple, and secure.

Money-back guarantee

You must be completely confident in the quality of your products in order to provide a money-back guarantee. This is precisely how custom paper writing services work. We double-check that there are no hidden issues with this promise and that you are completely happy with the quality of your purchase.

Read more

Zero-plagiarism guarantee

Our writers do not employ others’ writing tricks, because we are aware that plagiarism may cost a lot to our clients and take away their reputation.

Read more

Free-revision policy

We want you to be satisfied with your order, so we offer a free revision policy. If you are not completely happy with your order, let us know and we will revise it for free.

Read more

Privacy policy

We care about our customers and always strive to keep their trust. That’s why Customwritingspapers.com guarantees privacy and safety of your personal information. To ensure total security, we take the following measures:

Read more

Professional Editors

Our team of editors works tirelessly to ensure that all papers meet our high standards for quality. They check for the instructions, grammar, punctuation, and spelling mistakes as well as for plagiarism.

Read more

Fair-cooperation guarantee

We would never want to jeopardize our relationship with you, and that is why we offer a fair-cooperation guarantee: If for any reason you are not satisfied with your order, you can always get your money back.

Read more

Professional Writers

We only hire the best, most qualified professionals to work on your order. Each writer is a degree holder with extensive experience in their field. You can be assured that your project will be handled by a true expert.

Read more

Quality Control

Our quality assurance department ensures that each paper is of excellent quality before it is sent to you. You can be sure that your paper will meet all of the requirements that you set. Our experts are highly skilled and will follow your specific instructions to the letter.

Read more

Customer support

We have a highly professional and qualified customer support team that is available 24/24, 365 days a year. They will be more than happy to answer any questions or concerns that you may have about our company or products. You can contact them by phone, email, or chat on our website.

Read more

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
Open chat
1
Order through WhatsApp!
customwritingspapers.com
Hello!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code DISCOUNT2022