Questions and Answers
What data type is used for storing monetary values in Access?
Currency
Which data type is suitable for storing long blocks of text and text with formatting in Access?
Memo
In Access, which data type should be used for storing digital photos that allow multiple files to be attached per record?
Attachment
What data type is automatically generated for each record in Access?
Signup and view all the answers
Which data type in Access allows you to attach OLE objects like Word documents?
Signup and view all the answers
What kind of values does the Yes/No data type in Access store?
Signup and view all the answers
Which data type in Access should be chosen when creating a field that displays a list of values retrieved from a table or query?
Signup and view all the answers
What is the purpose of the Attachment data type in Access?
Signup and view all the answers
Study Notes
Access Data Types
- There are 10 data types in Access: Attachment, AutoNumber, Currency, Date/Time, Hyperlink, Memo, Number, OLE Object, Text, and Yes/No.
Attachment Data Type
- Stores files, such as digital photos, and allows multiple files to be attached per record.
- Not available in earlier versions of Access.
AutoNumber Data Type
- Automatically generates numbers for each record.
Currency Data Type
- Stores monetary values.
Date/Time Data Type
- Stores dates and times.
Hyperlink Data Type
- Stores hyperlinks, such as e-mail addresses.
Memo Data Type
- Stores long blocks of text and text that uses text formatting.
- A typical use case is a detailed product description.
Number Data Type
- Stores numeric values, such as distances.
- Note that there is a separate data type for currency.
OLE Object Data Type
- Stores OLE objects, such as Word documents.
Text Data Type
- Stores short, alphanumeric values, such as a last name or a street address.
Yes/No Data Type
- Stores boolean values.
Lookup Fields
- Allows you to create a Lookup field that displays a list of values retrieved from a table or query, or a static set of values.
- The data type of a Lookup field is either Text or Number, depending on the choices made in the Lookup Wizard.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
