Create A Calculated Field In A Query Using Zoom

Question: Create a single-table query in Query Design view

Answer:

Question: Add a field to a query in Query Design view

Answer: 1. Double-click the

field

Question: Delete a field from a query in Design view

Answer: 1. Click the

field in the query grid

2. In the Query Setup group of the Query Tools Design tab, click the Delete Columns button

Question: Add a criterion to a Number field of a query in Design view

Answer: 1. Click the first Criteria cell for the

field

2. Type

in the cell

3. In the Results group on the Query Tools Design tab on the Ribbon, click the Run button

Question: Add a criterion using a wildcard to a Short Text field in Query Design view

Answer: 1. Click the first Criteria cell for the

field

2. Type

• in the cell

• 3. In the Results group, click the Run button