List and Describe Common Data Types

Question

Examlex · Accepted Answer

The Answer is Common data types include the following:
• Text: Letters, numeric characters, or special characters
• Number (also called numeric values: Positive or negative numbers, and the number zero, with or without decimal points
• AutoNumber: Unique number automatically assigned by the DBMS to each added record, which provides a value that identifies the record (such as a student ID
• Currency: Dollar and cent amounts or numbers containing decimal values
• Date (also called date/time: Month, day, year, and sometimes time
• Memo (also called long text: Lengthy text entries, which may or may not include separate paragraphs
• Yes/No (also called Boolean : Only the values Yes or No (or True or False
• Hyperlink: Email address or web address that links to a webpage on the Internet or document on a network
• Object (also called BLOB , for binary large object: Photo, audio, video, or a document created in other programs or apps, such as word processing or spreadsheet, stored as a sequence of bytes in the database
• Attachment: Document or image that is attached to the field, which can be opened in the program that created the document or image (functions similarly to email attachments

List and Describe Common Data Types

Definitions: