Table Name Primary Key(s) Foreign Key(s) Others Attributes Purchase Request Request No Supervisor No, Agent No Request Date Order Inventory Order No Agent No, Vendor ID, Request No Order Date Receive Inventory Receipt No Vendor ID, Employee No Receipt Date Disburse Cash Disburse No Account No, Vendor ID, Employee No Date Disbursed Inventory Item No Description, Quantity Cash Account No Bank, Account Type Supervisor Supervisor No Last Name, First Name, Phone, Address Purchasing Agent Agent No Last Name, First Name, Phone, Address Vendor Vendor ID Last Name, First Name, Phone, Address Receiving Clerk Employee No Last Name, First Name, Phone, Address Request Inventory Item No Request No Quantity Inventory Order Item No Order No Quantity, Actual Price Receive Order Order No Receipt No Discrepancy, Discrepancy Amount Receipt of Inventory Item No Receipt No Quantity Receive Disburse Receipt No Disburse No Amount Disbursed Ive attached the tables, i need the next parts to be done in Microsoft Access, can anyone guide me step by step how to do them and attach screenshots thanks alot guys Using Access, create at least three records for each of the tables you identified in part 3 Document by printing the window from the Access Create relationships for your various tables Document by printing the relationships window make sure primary key icons appear on the relationships Dan Tragg insists on using only the highest quality blanks in the manufacturing of his surfboards Tragg's uses a list of approved vendors with whom they have established a good relationship over the years The blanks are purchased when a production supervisor recognizes a need for inventory The supervisor goes to his or her terminal and completes a Purchase Order Form online This is done by selecting the vendor, the inventory item, and the amounts to be ordered The order can be for one type of blank or for several types The Purchase Order Form is reviewed by a Purchasing Agent If it is approved, a Purchase Order Report is prepared, printed, and mailed to the selected vendor The goods are received and counted by the Receiving Clerk The Receiving Clerk enters the date, the PO number, and the Vendor's Invoice Number in the top portion of the form In addition, the Clerk must enter the Inventory ID number and the quantity received in the form If the order is in agreement with the Purchase Order, it is scheduled for payment Tragg's sometimes pays for more than one invoice (receipt of inventory) with each check (cash disbursement) In addition, on occasion they have placed very large orders and have paid for those orders in installments You w apply the REA Model and use Microsoft Access software to complete the case analysis of the expenditure cycle described above

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 22, 2024

Table Name Primary Key(s) Foreign Key(s) Others Attributes Purchase Request Request No Supervisor No, Agent No Request Date Order Inventory Order No Agent No, Vendor

image text in transcribed

Table Name	Primary Key(s)	Foreign Key(s)	Others Attributes
Purchase Request	Request No	Supervisor No, Agent No	Request Date
Order Inventory	Order No	Agent No, Vendor ID, Request No	Order Date
Receive Inventory	Receipt No	Vendor ID, Employee No	Receipt Date
Disburse Cash	Disburse No	Account No, Vendor ID, Employee No	Date Disbursed
Inventory	Item No		Description, Quantity
Cash	Account No		Bank, Account Type
Supervisor	Supervisor No		Last Name, First Name, Phone, Address
Purchasing Agent	Agent No		Last Name, First Name, Phone, Address
Vendor	Vendor ID		Last Name, First Name, Phone, Address
Receiving Clerk	Employee No		Last Name, First Name, Phone, Address
Request-Inventory	Item No - Request No		Quantity
Inventory-Order	Item No - Order No		Quantity, Actual Price
Receive-Order	Order No - Receipt No		Discrepancy, Discrepancy Amount
Receipt of Inventory	Item No - Receipt No		Quantity
Receive-Disburse	Receipt No - Disburse No		Amount Disbursed

Ive attached the tables, i need the next parts to be done in Microsoft Access, can anyone guide me step by step how to do them and attach screenshots? thanks alot guys!

Using Access, create at least three records for each of the tables you identified in part 3. Document by printing the window from the Access.
Create relationships for your various tables. Document by printing the relationships window make sure primary key icons appear on the relationships

Dan Tragg insists on using only the highest quality blanks in the manufacturing of his surfboards. Tragg's uses a list of approved vendors with whom they have established a good relationship over the years. The blanks are purchased when a production supervisor recognizes a need for inventory. The supervisor goes to his or her terminal and completes a Purchase Order Form online. This is done by selecting the vendor, the inventory item, and the amounts to be ordered. The order can be for one type of blank or for several types. The Purchase Order Form is reviewed by a Purchasing Agent. If it is approved, a Purchase Order Report is prepared, printed, and mailed to the selected vendor The goods are received and counted by the Receiving Clerk. The Receiving Clerk enters the date, the PO number, and the Vendor's Invoice Number in the top portion of the form. In addition, the Clerk must enter the Inventory ID number and the quantity received in the form. If the order is in agreement with the Purchase Order, it is scheduled for payment. Tragg's sometimes pays for more than one invoice (receipt of inventory) with each check (cash disbursement). In addition, on occasion they have placed very large orders and have paid for those orders in installments. You w apply the REA Model and use Microsoft Access software to complete the case analysis of the expenditure cycle described above