Develop an Access Database that illustrates the following. Based upon the information below, create a Microsoft Access Project that accomplishes the following tasks: Project Part 3 Create in SQL a table for Suppliers that contains fields for the following data: Supplier ID, first name, last name, address, city, state, zip. Be sure to set the correct primary key. Create in SQL a table for Products: Product ID, Product Name. Be sure to set the correct primary key. Tie the two tables together by using a foreign key (Supplier ID) in Product Table and cascade the foreign key. Enter the following data into the supplier table:
Get Free Quote!
288 Experts Online