MS Access MCQ Questions and solutions with explanations | MS Office

In Microsoft Access, queries serve multiple purposes, as described in the options:

Option A: Queries can be used to view, change, and analyze data in different ways. You can create queries that extract specific data based on criteria you define, sort and filter data, perform calculations, and join data from multiple tables. Queries help you retrieve and present data in a way that meets your requirements.
Option B: Queries can also be used as a source of records for forms and reports. Forms and reports are designed to provide user-friendly interfaces for data entry and presentation, respectively. Queries allow you to extract the necessary data from tables and present it in forms for data entry or in reports for printing and analysis.
Option C: This option seems incomplete, but from the context, it's not accurate. Queries can serve more than just one purpose.
Option D: Both options a and b are accurate. Queries can be used to view, change, analyze data and also serve as sources of records for forms and reports.

Therefore, the correct option is Option D: Both A and B. Queries in Microsoft Access are versatile tools that offer both data manipulation and data presentation capabilities.

In Microsoft Access, you can edit a relationship between tables using both of the provided methods:

Option A: To edit a relationship, you can right-click on the relationship line that connects two tables in the Relationships window. From the context menu that appears, you can choose the Edit Relationship option. This will open the Edit Relationships dialog box, where you can make changes to the relationship's properties and join fields.
Option B: Alternatively, you can double-click on the relationship line between two tables in the Relationships window. This action will also open the Edit Relationships dialog box, allowing you to modify the relationship settings.
Option C: Both options a and b are accurate. You can use either the right-click method or the double-click method to edit a relationship between tables in Microsoft Access.
Option D: None of the provided options are completely accurate. The correct answer is Option C: Both of above, as both methods are valid ways to edit relationships in Access.

Therefore, the correct option is Option C: Both of above.

In Microsoft Access, an action query is a type of query that performs an action on the data in a database, such as adding, deleting, or updating records. Each of the provided options represents a type of action query except for Option C: make-table.

Option A: Add action query is used to add new records to a table in the database.
Option B: Delete action query is used to remove records from a table in the database.
Option C: Make-table is not an action query. It's actually a query type that creates a new table based on the results of a query. It doesn't directly modify or affect existing data like the other action queries do.
Option D: Update action query is used to modify the data in existing records within a table.

Therefore, the correct option is Option C: make-table. It is not considered an action query in Microsoft Access as it doesn't perform actions on existing data but rather creates a new table based on query results.

An enterprise solution with data storage, a client interface, and a security system is commonly referred to as a 3-tier system. In this architecture, the system is divided into three main layers or tiers, each with specific responsibilities:

1. Data Storage Tier: This is the first tier where the data is stored, typically in a database management system (DBMS) such as Microsoft Access, SQL Server, or Oracle. It includes the storage and management of the actual data used by the application.
2. Client Interface Tier: This is the second tier where the client-side interface or user interface (UI) is located. It's the layer that users interact with, and it provides the user-friendly interface for accessing and interacting with the data. This can be a desktop application, web application, or mobile app.
3. Security System Tier: This is the third tier responsible for managing security and access control to the application and its data. It ensures that authorized users have appropriate access to the system while maintaining data security and privacy.

Option A: A 2-tier system typically consists of a client interface and a database server, without an intermediary security system layer.
Option B: The correct answer. A 3-tier system consists of data storage, client interface, and security system layers, which are described in the question.
Option C: A 4-tier system would include additional tiers beyond those described in the question, such as application logic or business logic tier.
Option D: An n-tier system refers to a general term for systems with multiple tiers or layers. It can encompass any number of tiers beyond three, including more complex architectures.

Therefore, the correct option is Option B: 3-tier.

In Microsoft Access, Referential Integrity is a database property that enforces the relationship between tables in a relational database. It ensures that the relationships between records in different tables are maintained accurately. The options presented describe the effects of enabling referential integrity between tables:

Option A: This option is incorrect. Referential integrity does not allow entering a value in the foreign key field of a child table unless that value exists in the primary key of the parent table. In other words, it enforces the rule that the foreign key value must have a corresponding value in the primary key of the related table.
Option B: The correct option. Referential integrity does not allow entering a value in the foreign key field of a child table if that value exists in the primary key of the parent table. This ensures that relationships are maintained accurately and prevents the creation of orphaned records in the child table that do not have a corresponding parent record.
Option C: This option is incorrect. The description provided is not accurate. Referential integrity primarily concerns the relationship between a foreign key in a child table and the primary key in a parent table, not the other way around.
Option D: None of the provided options accurately represent the effects of referential integrity.

Therefore, the correct option is Option B: It does not allow to enter a value in the foreign key field of a child table if that value exists in the primary key of the parent table. This ensures that data integrity is maintained by preventing inconsistent relationships between tables.