03b - Data Types

Question 1

What data type automatically assigns the next available number? (Often used for ID Fields)

Answer 1

Auto Number.

Question 2

Used for things like forename/surname, address, home town.

Answer 2

Short Text

Question 3

Used for things like age.

Answer 3

Number

Question 4

Used for things like price, amount to pay.

Answer 4

Currency

Question 5

Used for things like insurance or questions, e.g. Signed up?

Answer 5

Yes/no

Question 6

Used for things like birth date/booking dates.

Answer 6

Date/Time