Question

What are the steps for modifying a query to add calculations? Use the drop-down menus to complete them.

1. Open the query in
view.

2. Select the field to which you wish to add a calculation.

3. Right-click and select
in the drop-down menu.

4. Using the Expression Builder, add
to create a calculation.

5. Click
to see the results of the query.

Answer 1

Explanation:

1. Open the query in

view.

2. Select the field to which you wish to add a calculation.

3. Right-click and select

in the drop-down menu.

4. Using the Expression Builder, add

to create a calculation.

5. Click

to see the results of the query.

Answer 2

Answer:

1) open the query in Design view

2) select the field to which you wish to add a calculation

3) right-click and select Build in the drop down menu

4) using the Expressions Builder, add Expressions to create a calculation

5) click Run to see the results of the query

Explanation:

edg 2021