Databases

Question	Answer
Database	An organised store of electronic data
Flat File database	All the data is contained in on table
Relational Database	Data is stored in seperate tables which are linked together using primary keys / Key fields.
Primary Key	A unique identifier used to identify each record in a table
Table	Used to store data in a database
Records	All of the information about one person or thing in a database.
Field	One piece of information about a person or things, many fields make up a record.
Queries	Can perform many different functions such as retrieving explicit data from one or more tables. Queries permit the viewing of data from more than one table in a single datasheet.
Data Redundancy	Storing the same data more than once in a database.
Reports	used to summarise and present the data that is in the tables
Forms	A user friendly screen to input data.

Resource summary

	Created by Dean Whittle over 10 years ago