$\backslash$table$[[$Field Name,Data Type,Field Size,Description$],[$Equipment ID$,$Short Text,$30,$Part of Primary Key$],[$Date Ordered,$\backslash$table$[[$Date$/$Time $($Use Short Date$],[$format$)]],,$Part of Primary Key$],[$Number Ordered,Number,Integer,$],[$Coach ID$,$Short Text,$10,]]$

Import the data from the Orders.xlsx workbook to the Orders table. Do not save the import steps.

Add the Orders table to the Relationships window and establish a one$-$to$-$many relationship between the Coach table and the Orders table. Save the relationship.

Create a query that joins the Coach table and the Orders table. Include the Equipment ID and Date Ordered from the Orders table. Include Coach ID$,$ First Name, Last Name, Office, and Sport Name from the Coach table. Save the query as Coaches and Orders.

Create the report shown in Figure $6-86.$ The report uses the Coaches and Orders query as the basis for the main report and the Sport table as the basis for the subreport. Use the name Coaches and Orders Master List as the name for the report and the name Sports table as the