Created by Fiona Faulkner
over 11 years ago
|
||
Question | Answer |
foreign key | a field in a database table that is a primary key in another table |
validation rule | makes sure data entered is reasonable and sensible |
Boolean data | data that can only have one of two values, e.g. true/false, yes/no |
integer | a whole number data type |
real number or float | a number data type that contains decimals |
between ... and .... | a database search criteria for searching between 2 number values |
> | a database search criteria to find a number greater than a specified value |
< | a database search criteria to find a number less than a specified value |
not ... | a database search criteria to find all values apart from a specified value |
'print' keyword in Python | outputs the data to the screen |
int() | casts a value in Python to integer |
str() | casts a value in Python to string |
string | data that can contain text, characters, spaces & numbers |
input() | a command in Python that prompts the user to enter information on the screen in response to a question |
variable | an area (or 'box') in Python where data a user enters is stored, e.g. a name |
loop / iteration | a command in a computer program that makes the program keep repeating until a specified event happens |
if | makes a computer program only run under certain conditions |
cell reference | the name of a cell in a spreadsheet, e.g. A1 |
worksheet | one sheet within a spread sheet workbook |
formula | a calculation in a spread sheet using +, -, * or / |
function | a complex calculation built in to a spread sheet that uses words, e.g. SUM, IF, COUNTIF |
conditional formatting | a cell in a spread sheet changes colour according to data entered into it |
macro | a series of actions recorded as one action and usually run using a button |
cell link | a formula that links the data in a cell in one worksheet to a cell in another worksheet |
IF function | gives a true or false answer depending on a logical test or comparison between the value in one cell and another value |
VLOOKUP | looks up the value in a cell in a range of cells to give an answer from a specified column number in that cell range |
COUNTIF | counts the number of cells in a range of cells that contain a specified criteria or value |
relative cell reference | a cell reference in a formula that will change relative to its position if the formula is copied to another place in the spreadsheet |
absolute cell reference | a cell reference in a formula that won't change if the formula is copied to another position in the spread sheet; the dollar sign is used to make a cell reference absolute |
MAX function | finds the highest value in a range of cells |
MIN function | finds the lowest value in a range of cells |
record | a row in a database containing data about one item or person |
field | a column in a database containing an individual data item |
table | a collection of records and fields in a database |
database form | a user-friendly place to enter data into a database table |
report | a method of printing out a query or table from a database to make it look more attractive |
query | a place to search for data & store the results of the search, in a database |
relational database | more than one table linked to each other by fields |
primary key | a database field that uniquely identifies each record and is used to link tables together |
+ - * / | mathematical operators used to perform calculations in Python |
== | Python command meaning = in 'if' selections |
!= | Python command meaning 'not =' in 'if' selections |
else | keyword in Python that carries out the second part of a program if the first 'if' condition is not met |
elif | if the first 2 parts of a program in Python are not met, this keyword runs the last condition |
# (hash) | used to add comments to a program to make it easier to understand |
Want to create your own Flashcards for free with GoConqr? Learn more.