Starting from:
$22.99

$16.99

Online store tables Solution

Using Microsoft Access Create tables that will support an invoicing system for the "online store".

Include the following tables:

·         "Orders"

·         "OrderItems"

·         "Items"

·         Note: Make sure you have the following fields associated to the correct table.  These will be used in the following weeks (Order ID, Order Date, Ship Date, Item Name, Item Price, Quantity, Customer First and Last Name, Address, City, State, and Zip). 

·         Import the data for "Customers", using a Microsoft® Excel® document (Customer_Data).

·         Import the data for "Items", using a Microsoft® Excel® document (Item_Data).

·         Create the necessary fields with the appropriate data types, select primary keys, and establish the relationships between tables.

·         Include a description for each field, relevant validation rules, formatting, and other properties.

·         Add data for at least five orders. Each order should contain at least three items.

·         "Customers"

 

More products