2] How to Create a Query in Query Design. To use Query Design. Click Query Design. In the Query Design window, there is a Show Table dialog box, with categories such as Tables, Links, Queries, or All.

Create a new query in Design view. Add at least the Quantity and Unit Price fields. ... When you execute the query, Access will display the results of the calculation in the results.

In Microsoft Access, fields can be added and removed from the list of available fields. Learn how to add or delete a Field in Design View in Access.