Databases data types

12/4/16

• Text
• Date
• Memo
• Lookup

My customer is having problems with the engine of their car as it is letting out smoke and it smells funny. He suggests that we look at the enginge but also at the way he drives as he uses the clutch a lot. This may be the actually problem and we should look into it

• Text
• Memo
• Number
• Nothing

Hi my name is Bob

• Number
• Memo
• Text
• Lookup

Sir
Madam
Miss
Mrs
Ms

• Lookup
• Text
• Date
• Memo

5.5

• number
• text
• memo
• autonumber

Yes/No

• Boolean
• Lookup
• Text
• Memo

£5.67

• Number
• Currency
• Date
• Time

CV34 5TR

• Text
• Number
• Date
• Autonumber

male/female

• lookup
• boolean
• text
• number

6:21pm

• date/time
• time
• number
• text