Here are the answers to the questions:
1) Which of the following data type stores text or a combination of text and numbers?
(A) Ole
(B) Text
(C) Currency
(D) Number
In Microsoft Access, the Text data type (now often called Short Text) is used to store alphanumeric characters, which includes text, numbers, and symbols. This is suitable for combinations of text and numbers, such as addresses or product codes.
The correct option is (B).
∗(B)Text∗
2) To create a table in MS Access
(A) Database should be created before creating a table
(B) You should allow atleast one Primary key in a table
(C) Table can be created using Table Templates
(D) All of the above
Let's evaluate each option:
- (A) A database is the container for all objects, including tables. Therefore, a database must exist before you can create a table within it. This is true.
- (B) While not strictly mandatory for the initial creation of a table, it is a fundamental best practice for data integrity and relationships to have at least one primary key. Access often prompts you to create one or adds an AutoNumber primary key by default. This statement reflects good database design.
- (C) Microsoft Access provides built-in Table Templates (e.g., Contacts, Tasks) that allow users to quickly create tables with predefined fields and properties. This is a valid method.
Since all the statements are correct or represent best practices in the context of creating tables in MS Access, option (D) is the most appropriate answer.
The correct option is (D).
∗(D)Alloftheabove∗
3) Which of the following database
The question is incomplete. Please provide the full text of the question for a complete answer.