Unit 2 - Data Types

Question 1

What are the different Data Types?

Answer 1

Short Text
Memo
Number
Date/Time
Currency
Auto Number
Yes/No
OLE Object
Hyperlink
Attachment
Calculated
Lookup Wizard

Question 2

Short Text

Answer 2

General purpose field contain any data item made up of letters and/or numbers and/or characters
Use this type for numeric entries that will not have calculations performed on them, such as telephone numbers

Question 3

Memo

Answer 3

Where more that 255 characters is needed to store text values

Question 4

Number

Answer 4

Flexible field size of 1,2,4,8 or 16 bytes

Can also hold symbols used as helpers for umbers such as decimal points

Question 5

Date/Time

Answer 5

Any data item that will be a date or a time

Question 6

Currency

Answer 6

Used to store monetary data

Question 7

Autonumber

Answer 7

This data type generates an automatically incremented numeric counter
This data type will provide a unique value that serves no other purpose than to make each record unique
The most common use for an this datatype is as a primary key

Question 8

Yes/No

Answer 8

Used to store a Boolean Value

Question 9

OLE Object

Answer 9

Can be used to show a picture or link directly to an external document

Question 10

Hyperlink

Answer 10

Can be used to link a field to an external website or email address

Question 11

Attachment

Answer 11

Can attach multiple documents to a record

Question 12

Calculated

Answer 12

Used to store the results of a calculation

Question 13

Lookup Wizard

Answer 13

Used to create a drop down box in forms later on