Week 6 homework -- Preparing database tables The following are the tables that are needed to create your database. Table Name Primary Key Foreign Keys Other Attributes Customer Customer Number Customer Name Shipping Address Billing Address Credit Limit Balance Sales Invoice number Customer number Date of sale Sales-Inventory Item number Invoice number Quantity sold Price (actual sales price) Inventory Item Number Cost (standard or list) Description Quantity on Hand Price (standard or list) 1. Open up Access. (File, New, Click Blank Database, then name your file, then click create table in design view) 2. Enter each of the fields for Inventory, starting with the primary key item number. 3. For Item Number, type ItemNumber directly underneath Field Name, leave its data type set to text, and right click your mouse (your cursor should be to the left of ItemNumber) to set up this attribute as the primary key. For field properties: