Database - L2

HideShow resource information
What is a table?
The table allows you to see all of the records stored in the database. Tables can store many records, from a few dozen for a small database up to millions for a large company database.
1 of 5
What is a data type?
The type of data you are going to use
2 of 5
Main data types
Text - Letters, numbers, punctuation Number - Numbers only Date/Time - Dates or times AutoNumber - Starts at 1 and counts up automatically for every record
3 of 5
Where they are used?
You would use these in a database, like Schools Doctors etc.
4 of 5
Primary Keys
a unique field that helps you tell each record apart
5 of 5

Other cards in this set

Card 2

Front

The type of data you are going to use

Back

What is a data type?

Card 3

Front

Text - Letters, numbers, punctuation Number - Numbers only Date/Time - Dates or times AutoNumber - Starts at 1 and counts up automatically for every record

Back

Preview of the back of card 3

Card 4

Front

You would use these in a database, like Schools Doctors etc.

Back

Preview of the back of card 4

Card 5

Front

a unique field that helps you tell each record apart

Back

Preview of the back of card 5

Comments

No comments have yet been made

Similar Other resources:

See all Other resources »See all Computing resources »