DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
currency
|
|
|
number
|
|
|
date/time
|
|
|
text
|
Detailed explanation-1: -Think of a field’s data type as a set of qualities that applies to all the values that are contained in the field. For example, values that are stored in a Text field can contain only letters, numbers, and a limited set of punctuation characters, and a Text field can only contain a maximum of 255 characters.
Detailed explanation-2: -The modern database possesses the feature called ‘Structured Query Language or SQL’ which makes it possible to access the data.
Detailed explanation-3: -Right-click the document tab for the new table and click Design View. In the Field Name column, select the first blank row, and then type a name for the field. Select the adjacent cell in the Data Type column, and then select Short Text from the list. Save your changes.
Detailed explanation-4: -For number fields, the field size determines exactly how much disk space Access uses for each value of the field. For text fields, the field size determines the maximum amount of disk space that Access allows for each value of the field.