Problem 18.10 Refer to Problem 17.10 and develop a set of tables to implement the REA diagram you developed for Stans Southern Barbeque Supply Store. Identify the primary and foreign keys for each table, and dont forget to address any M:N relationships.

Given from Problem 17.10 Stans Southern Barbeque Supply Store orders mass-produced barbecue products from various suppliers. Stans maintains information about a contact person at each supplier along with all required address information. Each purchase order has the order number, date, tax, and total. Purchase orders also contain the following information for each product ordered: stock number, description, and price. The manager of Stans places orders by fax several times a day, whenever he notices that an item is running low. Some suppliers fill each individual order separately. Others, however, consolidate orders and fill all of them in one weekly delivery. Stans suppliers never make partial shipments; if they are out of stock of a certain item, they wait until they obtain that item and then ship the entire order. Some suppliers require payment at the time of delivery, but others send Stans a monthly statement detailing all purchases during the current period. Two suppliers allow Stans to make installment payments for any individual purchase orders that exceed $20,000.

I am required to answer this question using Access. I have found some info for the answer which I have attached. My issue is that I have no idea how to use ACCESS. I'm not sure how to apply the info I have found to Access. I would highly appreciate screen shots to help me understand what I am doing here and hoping to never have to use Access again :-)

Primary key and foreign key exist in all Tables The primary keys which are used for uniquely identify a records and the foreign key that is used to link one table with another table is presented in the following tabular format as follows Table Name Primary key Foreign Keys Other attributes Order Employee ID, Vendor ID Purchase Order ID Date of order Inventory Date of receiving Inventory vendor invoice number Receive InventoryReceiving Report ID Table Vendor_ID, Employee ID Date of cash Cash Disburse Vendor_ID, Employee ID GeneralLedgerAccount_ID Check ID disburse, amount, Table Balance, Initial balance Cash Table GeneralLedgerAccount ID Description for items, initial quantity on hand, quantity for placing re order, point for reorder Inventory Table Item ID Employee Name Employee Name date of hire Designation, rate of pay Employee Employee ID Table Name of Vendo, address details Contact Numbe Initial account balance, Rating of Vendor Table Vendor ID Purchase Order ID Inventory Table Quantity of order, unit cost Item ID Receive Quantity of items, Inventory Receiving Report ID Item ID Other condition Table Disbursement Receiving Report ID Applied amount Check ID Table