Which of the following are valid data types in MS Access?

Here are the answers to the questions:

1) Which is the valid data type in Access?
(A) Currency
(B) Text
(C) Number
(D) All of the above

Microsoft Access supports various data types for storing different kinds of information. These include:

• Currency for monetary values.
• Text (also known as Short Text or Long Text/Memo) for alphanumeric characters.
• Number for numerical values. Since all the listed options are valid data types in Access, the correct choice is (D).

The correct option is (D).
$\boxed{\text{(D) All of the above}}$

2) To open a new database, press
(A) Ctrl + O
(B) Ctrl + N
(C) Ctrl + M
(D) Ctrl + S

In most Windows applications, including Microsoft Access:

• Ctrl + O is used to open an existing file or database.
• Ctrl + N is the standard shortcut to create a new file, document, or database.
• Ctrl + M is not a common shortcut for creating a new file.
• Ctrl + S is used to save a file or database.

The correct option is (B).
$\boxed{\text{(B) Ctrl + N}}$

3) In MS Access, OLE objects Data type can store
(A) Microsoft Excel Spreadsheets

The OLE (Object Linking and Embedding) Object data type in Microsoft Access allows you to store data created in other applications directly within your database or link to it. This can include a variety of file types.

• Microsoft Excel Spreadsheets are a common example of an OLE object that can be embedded or linked using this data type. Other examples include Word documents, images, and sound files.

The correct option is (A).
$\boxed{\text{(A) Microsoft Excel Spreadsheets}}$