MS Access MCQ Questions and solutions with explanations

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6

21.
Queries in Access can be used as

A. view, change and analyze data in different ways

B. a source of records for forms and reports

C. Only A

D. Both A and B

Answer & Solution Discuss in Board Save for Later

22.
If you need to edit a relationship

A. Right click the relationship line and choose Edit Relationship

B. Double click the relationship line

C. Both of above

D. None of above

Answer & Solution Discuss in Board Save for Later

23.
Which of the following is not an action query?

A. add

B. delete

C. make-table

D. update

Answer & Solution Discuss in Board Save for Later

24.
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

A. 2-tier

B. 3-tier

C. 4-tier

D. n-tier

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

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.

25.
What is the use of Referential Integrity in MS Access?

A. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

B. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table

C. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table

D. None of above

Answer & Solution Discuss in Board Save for Later

26.
In Access to reduce the height of the selected control

A. SHIFT+RIGHT ARROW

B. SHIFT+DOWN ARROW

C. DOWN ARROW or CTRL+DOWN ARROW

D. None of these

Answer & Solution Discuss in Board Save for Later

27.
The content and application of the Search tool CANNOT be retained when you ______.

A. format an object

B. resize a column

C. use Datasheet View

D. close an object

Answer & Solution Discuss in Board Save for Later

28.
It is most common type of query. It retrieves records from one or more tables and then displays the

A. Parameter

B. Select

C. crosstab

D. All of above

Answer & Solution Discuss in Board Save for Later

29.
When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

A. Report

B. Table

C. Query

D. Tools

Answer & Solution Discuss in Board Save for Later

30.
Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MS Access MCQ Questions and solutions with explanations | MS Office

21. Queries in Access can be used as

Answer & Solution

22. If you need to edit a relationship

Answer & Solution

23. Which of the following is not an action query?

Answer & Solution

24. An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

Answer & Solution

25. What is the use of Referential Integrity in MS Access?

Answer & Solution

26. In Access to reduce the height of the selected control

Answer & Solution

27. The content and application of the Search tool CANNOT be retained when you ______.

Answer & Solution

28. It is most common type of query. It retrieves records from one or more tables and then displays the

Answer & Solution

29. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

Answer & Solution

30. Which of the following database object hold data?

Answer & Solution

Read More Section(MS Access)

21.
Queries in Access can be used as

22.
If you need to edit a relationship

23.
Which of the following is not an action query?

24.
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

25.
What is the use of Referential Integrity in MS Access?

26.
In Access to reduce the height of the selected control

27.
The content and application of the Search tool CANNOT be retained when you ______.

28.
It is most common type of query. It retrieves records from one or more tables and then displays the

29.
When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

30.
Which of the following database object hold data?