ExamVeda
Login
Home

MS Access MCQ Questions and solutions with explanations | MS Office

This section contains MCQ and Aptitude questions and answers on MS Access MCQ Point for IBPS clerk, IBPS PO, SBI clerk, SBI PO and other IT exams. Page-5 section-2

Each section contains 100 MCQs on MS Access .
41
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
42
In one-to-many relationship the table in 'one' side is called _______ and on 'many' side is called _______
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
43
Database properties do NOT include ___________.
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
44
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
45
A collection of related records in database is known as a
Discuss
Answer & Solution
Answer: Option A
Solution:
A Table is a collection of related records in a database. It organizes data into rows and columns, where each row represents a record, and each column represents a field or attribute. Unlike a file, which is a collection of data without any inherent structure, a table in a database is designed to store structured and related information. A table is a fundamental component of a relational database, providing a systematic way to organize and manage data.
Therefore, the correct option is Table.
46
How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
47
In Access to increase the width of the selected control
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
48
Saving a database in access is done
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
49
What is the maximum length a text field can be?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
50
This query wizard will create a select query.
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board