03b - Data Types Flashcards
1
Q
What data type automatically assigns the next available number? (Often used for ID Fields)
A
Auto Number.
2
Q
Used for things like forename/surname, address, home town.
A
Short Text
3
Q
Used for things like age.
A
Number
4
Q
Used for things like price, amount to pay.
A
Currency
5
Q
Used for things like insurance or questions, e.g. Signed up?
A
Yes/no
6
Q
Used for things like birth date/booking dates.
A
Date/Time
