i need help with an access assignment .

please advise.

1) Tables: Fields (keys in yellow, foreign keys in blue, both key & foreign key in green) Vendor: Code (AutoNumber), Name (short text, field size 40), StreetAOOces(short text, field size 30), (Number with 00000 input mask) SaJes8ep: ld (Number), LastName(short text, field size 20), EjrstName(short text, field size 15), Vendor (Number), (short text), (short text) Buyer: ld (Number), LastName(short text, field size 20), FirstName(short text, field size 15), Prima Phone (short text), Seconda Phone (short text), Item: UPC (Number with 000000000000 input mask), Name (short text, field size 50), Vendor (Number), UnitPrice (Number) Transaction: JnyqigeNum>er (AutoNumber), Vendor (Number), SalRep (Number), Buyer (Number), Date (Date/Time, format: short date), Amount (Number), Received (yes/no, default value: no), Paid (yes/no, default value: no) TransaptjqnElement: Item (Number)JnypjQNumer (Number), Quantity (Number), Amount (Number) 2) Relationships: Link all foreign key fields to their original tables SaJes8ep,yenOor, Jtem,yendor, and to Transaction.SaIesRe to SalesRe ld Transaptjqn,uyec to BuyerJA TransactionElement.lnvoiceNumber to Transaction.lnvoiceNumber 3) Queries: Select all Transactions where Vendor.Code = 12341 Select all where 1234 Select all Transactions that have been received but not yet paid Select all Items where Item.Vendor = 7654 Select all SaJes8epswhere Vendor = 3344 and = "Demopoulos" Select all Buyers where LastName = "Chang" and FirstName = "Robert" Select all Transactions from August 2019 where the SaJes8ep was named Jane Demopoulos and the Buyer was named Robert Chang 4) Reports: For all Vendors, show their Name, StreetAdOcess, and Zjp04e. The list should be sorted in ascending order by Name For all SavesReps, show their Vendor, LastName, FirstName, and PrimaryPhpne. The list should be sorted in ascending order by Vendor, LastName and FirstName