MS Access MCQ Questions and solutions with explanations | MS Office

To open a new database in Microsoft Access, you can use the keyboard shortcut CTRL+N. This combination of keys will create a new, blank database. It's important to note that CTRL+O is typically used to open an existing database, not to create a new one. ALT+F4 is a general Windows shortcut to close the currently active window, and it would not be used to open a new database. Therefore, the correct option is Option A: CTRL+N.

To save a database object in Microsoft Access, you can use either the keyboard shortcut CTRL+S or SHIFT+F12. These combinations of keys will trigger the saving process for the currently active object. CTRL+P is typically used for printing, not for saving. P or CTRL+P is not the correct option for saving. F12 is generally used to open the "Save As" dialog, but it is not the direct shortcut for saving the object. Therefore, the correct option is Option C: CTRL+S or SHIFT+F12.

In Microsoft Access, when you press the TAB key, it is used to exit the currently active combo box or list box. This is especially helpful when you are navigating through forms or data entry fields. It allows you to move to the next field or control after making a selection in a combo box or list box without needing to use the mouse. TAB is not used to move up or down lines or pages. Therefore, the correct option is Option C: Exit the combo box or list box.

Microsoft Access is classified as a Relational Database Management System (RDBMS). An RDBMS is a type of database management system that stores and organizes data in a structured manner using tables with predefined relationships between them. In Microsoft Access, data is stored in tables, and you can create relationships between these tables using keys. Access follows the principles of a relational database by allowing you to establish connections between tables, ensuring data integrity, and supporting SQL (Structured Query Language) for querying and managing data.

Option B: Object-Oriented Database Management System (OODBMS) refers to a type of database system that stores data in the form of objects, which are instances of classes. Microsoft Access does not primarily fall under this category.
Option C: Object-Relational Database Management System (ORDBMS) combines features of both relational and object-oriented databases. While Microsoft Access has some object-oriented features, it is primarily categorized as an RDBMS.
Option D: The Network Database Model is a type of database model that represents data in a network-like structure of records and sets. Microsoft Access doesn't primarily adhere to the network database model.

Therefore, the correct option is Option A: RDBMS.

You can sort records in a table in Microsoft Access using different methods. All of the provided options are valid ways to achieve sorting:

Option A: Open the table, click on the field on which you want to perform sorting, and then click the Sort button on the database toolbar. This method allows you to sort the table based on the selected field in ascending order.
Option B: Open the table and click the Sort button on the database toolbar. A dialog will appear where you can choose the field based on which you want to sort. After selecting the field, click OK to apply the sorting. This method provides you with more control over the sorting options.
Option C: Clicking on the field heading allows you to sort the data in ascending order by default. Clicking the same field heading again will change the sorting to descending order.
Option D: All of the above options are valid ways to sort records in a table. Depending on your preference and the complexity of the sorting criteria, you can choose the most suitable method.

Therefore, the correct option is Option D: All of above.

A database is a structured collection of data that is organized and stored in a way that allows for efficient retrieval, management, and manipulation of the data. It can include various types of information and can serve different purposes. All of the provided options are examples of databases:

Option A: An address book containing the contact details of all the suppliers of a company can be considered a database. It stores structured information about suppliers, allowing easy access and management of their contact information.
Option B: A salary sheet containing the salary details of all employees of a company is also an example of a database. It stores data related to employee salaries, which can be organized and manipulated for payroll processing and analysis.
Option C: The records of daily sales transactions of a company represent a database as well. This type of database stores information about sales transactions, which can be used for tracking sales performance and generating reports.
Option D: All of the above options are valid examples of databases. They each involve storing structured data for specific purposes, making them organized collections of information that can be queried, updated, and managed efficiently.

Therefore, the correct option is Option D: All of above.

In Microsoft Access, pressing the F11 key serves to Toggle the Navigation Pane. The Navigation Pane is a side panel that helps users navigate through various objects in the database, such as tables, queries, forms, and reports. When you press F11, it will either show or hide the Navigation Pane, making it easier to switch between different objects in your database without the need to manually navigate through menus.
Option B: Pressing F6 is typically used to cycle between open windows, allowing you to switch focus between different elements of the user interface.
Option C: Pressing ALT+TAB is the common keyboard shortcut to switch between open windows, and it can restore a minimized window if you select it.
Option D: This action is not associated with the F11 key in Microsoft Access. The described behavior seems more relevant to window management in general, rather than a specific action triggered by F11 in Access.

Therefore, the correct option is Option A: Toggle the Navigation Pane.

In Microsoft Access, pressing SHIFT+F10 is used to Display the shortcut menu. The shortcut menu, also known as the context menu, is a menu that provides options related to the selected object or area. It typically contains commands that are relevant to the current context, allowing you to perform various actions without navigating through multiple menus.
Option A: Pressing ALT+SPACEBAR typically displays the Control menu, which allows you to move, size, minimize, maximize, or close the active window.
Option C: Pressing CTRL+F4 is often used to close the active window or tab, but this behavior is not associated with SHIFT+F10.
Option D: The described action, SHIFT+F10, does have a specific function in Microsoft Access, which is to display the shortcut menu.

Therefore, the correct option is Option B: Display the shortcut menu.

You can display relationships in a database in Microsoft Access using multiple methods, all of which are mentioned in the options:

Option A: To display relationships, you can select View > Relationships from the menu. This will open the Relationships window where you can view and manage the relationships between tables.
Option B: Clicking the Relationships button on the toolbar also allows you to display relationships. This button typically resembles a set of linked tables and provides a convenient way to access the Relationships window.
Option C: While not the most common method, you can also select Edit > Relationships from the menu to open the Relationships window and view the database's relationships.
Option D: All of the above options are indeed true. Each of these methods serves the purpose of displaying the relationships in a database, allowing you to visualize and manage how tables are connected to each other.

Therefore, the correct option is Option D: All the above are true.

To open an existing database in Microsoft Access, you can use the keyboard shortcut CTRL+O. This combination of keys opens the Open dialog where you can browse and select the database file you want to open. The CTRL+N shortcut is used to create a new, blank database instead of opening an existing one. ALT+F4 is a general Windows shortcut to close the currently active window, and it is not used to open databases. Therefore, the correct option is Option B: CTRL+O.