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
 
Home DatabaseUsing Information Internet NAB/Coursework Revision Legal Responsibilities

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])


 

 



 

Intermediate II Home
Database | Using Information | Internet | NAB/Coursework| Revision
Log into Glow | School Website | Contact Us