Write (T) for True and (F) for False statements.
1. A database can have only one table.
2. Number data type is used for numeric data that will be used in calculations.
3. Caption property is used to give an alternate name to a field.
4. Field Properties Pane is used to set properties for the fields in the table.
5. Primary key option is available on the Home tab.
Answer (1)
A database can have only one table. (F)
In database systems, while it is possible for a database to have only one table, it is not a requirement or limitation. Databases can have multiple tables that can be linked or related to each other through keys, such as primary keys and foreign keys. This is a common practice to manage complex data more efficiently.
Number data type is used for numeric data that will be used in calculations. (T)
The Number data type is specifically used for storing numeric values, especially when you need to perform calculations such as addition, subtraction, multiplication, or division. This data type ensures that the values stored can be used in arithmetic operations.
Caption property is used to give an alternate name to a field. (T)
In a database, the Caption property allows you to set a descriptive or alternative name for a field. This is particularly useful for user interfaces where you want the field name to be more user-friendly or self-explanatory, especially if the original field name is formatted for database conventions and might not be intuitive for end users.
Field Properties Pane is used to set properties for the fields in the table. (T)
The Field Properties Pane, which you find in database management systems, lets you define field-specific settings or attributes. This may include data type, default values, input masks, validations, or any field constraints, allowing you to control how data is input and stored at a granular level.
Primary key option is available on the Home tab. (F)
In most database management systems, the primary key option is generally found under the Table Design or similar sections, not the Home tab. The Home tab typically contains general commands related to editing and data entry, while design-specific features, such as setting a primary key, are found under design or structure-related menus.
