Create a query in design view using both the CUSTOMERS and ORDERS tables

Use the fields CustomerID and Name from the CUSTOMERS table and the fields OrderID, Date and Amount from the ORDERS table

Run the query

Save the query as Orders