Database-Datatypes

Collection of fields known as

• keyfield
• record
• file
• table

Which datatype can store both text and numbers

• Boolean
• Image 
• number
• Text

Which datatype would you use for a car registration number?

• Boolean
• Image 
• number
• Text

What datatype is used for yes/no?

• text
• boolean
• numbers
• memo

Which datatype is suitable for your date of birth?

• TEXT
• NUMBER
• DATE
• TIME

What datatype is used to store an appointment time? 

• DATE
• TIME
• MEMO
• NUMBERS

Which datatype is used to store the field SURNAME

• NUMBER
• BOOLEAN
• TEXT
• IMAGE

Which datatype would be the best choice to store if  have you passed your driving test.

• text
• boolean
• memo
• number

Which are the  operators for less than, greater than and equal to?

• \ / =
• { } =
• ( ) ==
• < > =

Select the correct definition for "Database"

• This stores all the records for a particular field
• A collection of data stored in logical order
• One piece of data or information about a person of thing
• Used to uniquely identify every record in a table