Create a query in Query Design view based on both tables. Add the following fields to the design grid in the order given: Concert ID, Sponsor Name, and Box Office Receipts. Sort the records in ascending order by the Concert ID field. In the fourth column of the design grid, create a new field...