Databases Flashcards
1
Q
What is a Database
A
One or more table
2
Q
A flat file database has how many tables?
A
1
3
Q
Tables consist of rows, which in themselves consist of
A
a record
4
Q
Columns contain a
A
Field
5
Q
What is the unique identifier for a record?
A
A primary key
6
Q
Name four types of check on a database
A
Range, Type, Format, Length
7
Q
From where does the data used to make an input form come from?
A
Table or query
8
Q
What can an input form do?
A
Add fields, sort data and combine data from multiple tables
