Study the tables and then complete the text below with words from B opposite.
Look at A opposite and find the terms which correspond with these definitions.
1 software which allows data to he displayed and managed in a table format
2 it goes up and down and has letter labels
3 it goes across and has number labels
4 an area in a spreadsheet which contains data
5 the current cell where you enter information
6 mathematical equations that help you calculate and analyze data
7 ready-to-use formulae that help you perform specialized calculations, e.g. SUM, AVERAGE, etc.
A (1).................. program allows the user to store, change and retrieve information.
A database file is a collection of records. Each (2)........ contains a set of fields.
Each (3)................. holds a separate piece of information; for example, a student file
contains a list of records, each of which consists of several fields which give their name, address, birthday, etc.
In a (4).................. database, information is stored in tables that have a connection or link with one another (see tables above).
A database lets you create an (5)............. , a list of records ordered according to the content of certain fields; this helps you search and (6).......................... records into numerical or alphabetical order very fast. It also has a (7)................................................................. function which allow you to extract information that meets certain criteria.