Database - How To Movies |
||||
| 1. Setting up and creating tables and fields | 2. Formatting Fields. | 3. Creating Primary Key and Relationships | 4. Searching and Creating Reports | 5. Editing Reports |
Database
Computed Fields
Calculating values
One of the main advantages that computers have over humans is the ability to perform calculations very quickly, as many times as necessary, without errors.
In a database, calculations are performed using expressions or formulas. Here is an expression to calculate a student’s total mark from three tests:
= [Test 1] + [Test 2] + [Test 3]
Many databases also allow you to use functions in expressions. For example, the following expression would calculate the student’s average mark from the three tests:
= Average([Test 1], [Test 2], [Test 3])
