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
Card 4
Front
You would use these in a database, like Schools Doctors etc.
Back
Card 5
Front
a unique field that helps you tell each record apart
Comments
No comments have yet been made