Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!

glass
pen
clip
papers
heaphones

creating a new database.

creating a new database.

creating a new database.

 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.

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter


1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.