database terms flash cards

Set: database terms

Familiarize		Learn		Test
Play Scatter			Play Space Race

	Term	Definition
	Record !	Contains all the information about one item, e.g a person !
	Field !	One piece of information on a recorde e.g a name !
	Simple Search !	To find records using only one field. e.g age !
	Complex Search !	To find records using 2 or more fields, e.g age and class !
	Simple Sort !	To put teh records in order using only one field. e.g sort in order of age !
	Complex Sort !	To put the records in order using 2 or more fields, e.g sort in order of surname and then by first name !
	Record Format !	How the record is displayed, e.g displayed in columns, headings and in bold !
	Field Type !	Describes the type of data to be held in a field e.g text, number and date !
	Computed Field!	A field which performs calculations using the data from other fields e.g rate per hour field * Hours worked field !
	Screen Input Format!	How the user will view records as they key in data, e.g as individual records or as a table !
	Output Format !	How the database will be printed, e.g in columns, as individual records or as a table !
	Keyword !	A word which is used to search for an item in a database !

No Messages