databases

?
database features
tables,records,fields,reports
1 of 7
data types
auto-number,text,number,currency ,date/time
2 of 7
what is a primary key
uniquely indentifies a record
3 of 7
relationships
a relationship is a link between two tables. The links are made using a common field existing in both tables eg one to one, one to many, many to many
4 of 7
what is validation
helps to reduce errors at input,guarantees that the data is present and the correct type, range or length
5 of 7
validation techniques
type, range, format,presence,
6 of 7
forms
forms make it easier to enter data when there are a number of tablesin a database because a form may including fileds from different tables
7 of 7

Other cards in this set

Card 2

Front

data types

Back

auto-number,text,number,currency ,date/time

Card 3

Front

what is a primary key

Back

Preview of the front of card 3

Card 4

Front

relationships

Back

Preview of the front of card 4

Card 5

Front

what is validation

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »