Calculated field-a field in a database record containing data created by calculations Character- text that represents a keyboard symbol Data- raw facts without any clear meaning. The five main types of data used by computer systems are text, numerical, graphic, audio and animation/video. Data analysis- looking for patterns and meaning in data Database- a way of organising and storing collections of similar facts. Usually, it consists of a set of data ®les created and used by a database management system. Database Management System (DBMS)- a software application that manages a computerised database Data dictionary- a description of every field in the database and the rules that decide if an entered data value can be accepted - also, a table used in programming to describe the variables and data types used in a program Data filter- a method of searching a database by supplying a sample of the data value or values that you want to find.
Data processing- editing existing data or creating new data values Field- in a database, a single complete piece of data such as a surname File- a data storage structure, usually on a secondary storage device. A ®le is used to store all the data in a particular document such as a word-processed document, graphics image or a database. In programming, a ®le is a data structure that can store values of any data type. Form- a layout designed to display data on a screen and to collect data for paper documents Form view- a way of displaying all the fields of a single record in a database Key field- a data field used to identify each record in a database. Every value in a key field is like a fingerprint and is unique to each record. List view- a way of displaying many separate records of a database on the same screen Macro- an automated list of commands, usually keystrokes and mouse actions, used in a software application. A macro can be saved and replayed at any time. Mail merge- the process of placing data from selected fields and records into specially marked blank spaces in a form. This allows many copies of the form to be printed, with each copy containing individualised data. Query- a search instruction used to locate data in a database. See also data filter; searching. Record- all the data fields describing just one item in a database. In programming, a record is a data structure used to store values of different data types. Report- a printable list showing selected records and fields from a database. A report is usually the result of a query. Searching- the process of locating data in a data ®le or data structure. See also data filter; query. Sorting- the process of placing individual data items into a set order. See also ascending sort; descending sort. Table view- a way of displaying many separate records of a database on the same screen Validation- the process of checking data for errors (such as the wrong type of data) as the data are entered into a computer system or a database. Validation is normally done by the computer using rules stored in a data dictionary. Verification- the process of checking data for accuracy. Verification is normally done by people manually checking each data item. ASSESSMENT TASK
Character- text that represents a keyboard symbol
Data- raw facts without any clear meaning. The five main types of data used by computer systems are text, numerical, graphic, audio and animation/video.
Data analysis- looking for patterns and meaning in data
Database- a way of organising and storing collections of similar facts. Usually, it consists of a set of data ®les created and used by a database management system.
Database Management System (DBMS)- a software application that manages a computerised database
Data dictionary- a description of every field in the database and the rules that decide if an entered data value can be accepted - also, a table used in programming to describe the variables and data types used in a program
Data filter- a method of searching a database by supplying a sample of the data value or values that you want to find.
Data processing- editing existing data or creating new data values
Field- in a database, a single complete piece of data such as a surname
File- a data storage structure, usually on a secondary storage device. A ®le is used to store all the data in a particular document such as a word-processed document, graphics image or a database. In programming, a ®le is a data structure that can store values of any data type.
Form- a layout designed to display data on a screen and to collect data for paper documents
Form view- a way of displaying all the fields of a single record in a database
Key field- a data field used to identify each record in a database. Every value in a key field is like a fingerprint and is unique to each record.
List view- a way of displaying many separate records of a database on the same screen
Macro- an automated list of commands, usually keystrokes and mouse actions, used in a software application. A macro can be saved and replayed at any time.
Mail merge- the process of placing data from selected fields and records into specially marked blank spaces in a form. This allows many copies of the form to be printed, with each copy containing individualised data.
Query- a search instruction used to locate data in a database. See also data filter; searching.
Record- all the data fields describing just one item in a database. In programming, a record is a data structure used to store values of different data types.
Report- a printable list showing selected records and fields from a database. A report is usually the result of a query.
Searching- the process of locating data in a data ®le or data structure. See also data filter; query.
Sorting- the process of placing individual data items into a set order. See also ascending sort; descending sort.
Table view- a way of displaying many separate records of a database on the same screen
Validation- the process of checking data for errors (such as the wrong type of data) as the data are entered into a computer system or a database. Validation is normally done by the computer using rules stored in a data dictionary.
Verification- the process of checking data for accuracy. Verification is normally done by people manually checking each data item. ASSESSMENT TASK