Microsoft Access is a database management system. In this program, you can create various queries to select data according to certain criteria, including calculated ones.
Necessary
- - computer;
- - Access program.
Instructions
Step 1
Add calculated fields to calculate in Access. You can create such a field in a form, request or report, if necessary. To count in a calculated field, enter an expression. It is a formula that is similar to formulas in Excel, except that it does not use cell references, but the names of tables and fields.
Step 2
When constructing expressions, use the following elements: identifiers (field name enclosed in square brackets, for example, the "Price" field from the "Products" table - [Products] [Price]; operators (+, -, *, /); functions, constants, values (numerical).
Step 3
Create a calculated query, for this go to the "Queries" tab of the database, select "New" - "In design mode". Select the fields of the required tables or queries used in the calculations. In the new field, enter an expression in the field name, for example = [Price] * [Quantity].
Step 4
If you use fields from one table in your query, then you do not need to specify its name in the expression. If several tables are involved in it, then add the name of the table to the name of the field, as shown in the second step. After that, run the execution request using the exclamation mark in the toolbar.
Step 5
Use the Expression Builder to create complex calculations in your query. To do this, in the free field, click in the name, select "Build". Note that at the top of the builder is the expression text box, which is used to write the expression. A line with arithmetic operators is located just below. The bottom area contains three text boxes that are used to select the items to insert into the expression.
Step 6
Enter the expression manually or form it from ready-made functions and operators. For example, select tables and fields to add to the query, between them from the builder panel add arithmetic operators or functions from the corresponding section. Then click "OK". The calculated query in Access is ready.
