Question: how do i do number 5? Excel VehicleSales g? - View-only File Home Insert Draw Page Layout V B a Ar . General 5 5

how do i do number 5? how do i do number 5? Excel VehicleSales g? -
how do i do number 5? Excel VehicleSales g? -
how do i do number 5? Excel VehicleSales g? -
how do i do number 5? Excel VehicleSales g? -
how do i do number 5? Excel VehicleSales g? -
Excel VehicleSales g? - View-only File Home Insert Draw Page Layout V B a Ar . General 5 5 A B D E VehicleID Customerid Employeeld Sale Price SaleDate 1000 1 26,999.00 12/1/2018 1007 5 31,500.00 11/28/2018 1009 2 32,000.00 10/18/2018 1008 8 2 33,000.00 11/26/2018 1004 1 1 14,400.00 11/28/2018 N 5 . 1 0 1 2 3 4 5 6 7 8 00 Excel Customers 8R - View-only File Home Insert Draw Page Layout V DvB & Av v General 16 fx 1 2 3 4 5 6 7 8 A B D FirstName Last Name Phone Number Email Doctor Who 9999999999 doctor.who@bbc.com Captain Kirk 9999998888 captain.kirk@starfleet.gov Han Solo 9999997777 han.solo@falcon.com Jack Ryan 9999996666 jack.ryan@cia.gov Gregory House 9999995555 house@princetonplainsboro.com Ethan Hunt 9999994444 ethan.hunt@mi6.gov Bojack Horseman 9999993333 bojack horseman@hollywoo.com James Holden 9999992222 james.holden@rocinante.mars Stark 9999991111 tony.stark@avengers.org E CreditScore 800 599 750 775 300 830 0 9 10 Tony 490 850 + 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 III Customers Gira dha Microsoft 1. (5 Points) Create a new table in the database called "VehicleMakes" a. Create a column in the new table titled "VehicleMake" with data type "Short Text". i. Ensure that "VehicleMake" is the primary key. b. Add the information below to the new column. Audi For Chevy Mazda Toyota 2. (5 Points) Import the data from the "Customers.xlsx" file and let Access create a primary key. a. Name the table "Customers". b. Rename the primary key from "ID" to "Customer D" 3. (5 Points) Import the data from the "VehicleSales.xlsx" file and let Access create a primary key a. Name the table "VehicleSales" b. Rename the primary key from "ID" to "SaleID" C. Change the data type for Sale Price from a "Number" to "Currency" 4. (10 Points) Create the proper relationships between the following tables: a. Customers to VehicleSales b. Employees to Vehicle Sales c. Vehicles to Vehicle Sales 5. (10 Points) Modify the Vehicles table so that the "VehicleMake" field uses a Lookup Field against the "VehicleMake" column in the "VehicleMakes" table. Frontier Q All AG - w 2013 DOO INTE w whe TO COTTIS 100 HER W OR OP 2 3 3 5 6 2 9 O Q W E R . Y U 1 O . S D F G H K L N c V . N M Alt Alt y [B Copy View Paste R Views All Ac... Tables Customers Cut 2 Ascending 7 Selection Al Descending Advanced Filter Format Painter 0 Remove Sort Y Toggle Filter Clipboard Sort & Filter Customers X Vehicles VehicleMakes Vehicle Make Click to Add- Audi Chevy Ford Mazda Toyota Departments Employees VehicleMakes Vehicles VehicleSales

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!