STRUGGLING WITH MICROSOFT ACCESS need helpNeed help with #2-3 thanks!

Assignment You must design a database file with tables & fields, relationships, queries, and reports as given below. Please submit your Access file without any data-the TAs will import a standard batch of data to evaluate your work. However, you may find it useful to temporarily add some data to your tables, especially to test your queries and reports. 1) Tables: Fields (keys in yellow, foreign keys in blue, both key & foreign key in green) Supplier: Id (AutoNumber), LastName (short text, field size 30), FirstName (short text, field size 30), Email (Short Text, field size 30), PrimacyPhone (Short Text with 000-000-0000 input mask) Distributor. Id (Number), LastName (short text, field size 30), FirstName(short text, field size 30). Supplier (Number), Email (Short Text, field size 30), PrimacyPhone (short text with 000-000-0000 input mask), SecondaryPhone (short Text with 000-000-0000 input mask) Customer: Code (Number), Name (short text, field size 30). Useld (short text), PrimaryPhone (short text with 000-000-0000 input mask), StreetAddress (short text), ZinCode (Number with 00000 input mask), City (short text), State(short text) Item: UPC (Number), Name (short text field size 50), Supplier (Number), UnitPrice (Number), Sent (yeso, default value: no), Paid (yeso, default value: no) Transaction: InvoiceNumber (AutoNumber), Supplier (Number), Distributor (Number), Customer (Number), Date (Date/Time with Short Date format), Amount (Number) Transaction Element (note that this table's key is two fields): Item (Number), InvoiceNumber (Number), Quantity (Number), Amount (Number) 2) Relationships: Link all foreign key fields to their original tables Distributor Supplier, Item. Supplier, and Transaction Supplier to Supplier.ld Transaction Distributor to Distributorld Transaction Customer to Customer. Code Transaction ElementInvoiceNumber to Transaction. Loxoice Number Transaction Element.ltem to Item UPS 3) Queries: Select all Transactions where Supplier.Id = 123 Select all Transaction Elements where Transaction Element Quantity >= 1000 Select all Items where Supplier.Id = 765 Select all items that have been paid but not yet sent (ie. Paid = "yes" but Sent = "no") Select all Distributors where Supplier.Id = 234 and LastName = 'James" Select all Customers where Name = 'Chang" and Userld = "abc123" Select all Transactions from February 2020 where the Distributor was named John Adams and the Customer's user id was "zwy098" 4) Reports: For all Distributors, show their LastName, FirstName, Email, and PrimaryPhone (only). The list should be sorted in ascending order by LastName and then FirstName For all Customers, show their Name, Userld StreetAddress, and ZipCode. The list should be grouped by ZipCode, and within each zip code, customers should be sorted in ascending order by Name