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-10 section-5

Each section contains 100 MCQs on MS Access .
91
An application that executes on separate PCs like this is called a(n) __________ application.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
92
To enter the input mask wizard
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
93
Which is the valid data type in Access?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
94
How many relations may exist between tables in databases?
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
95
It is a database object to view, change, and analyze data in different ways
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
96
Which of the following is the default join between two recordsets?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
97
It is a sign or symbol that specifies, operator, and values that produce a result
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
98
The report footer section is most useful for displaying:
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
99
Which part of the IIF expression is the action performed if the true condition exists?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
100
how do you update pivot table report data after changes are made to the source data?
Discuss
Answer & Solution
Answer: Option C
Solution:
When changes are made to the source data of a pivot table, the pivot table itself does not automatically update.

To refresh the pivot table with the updated data, you need to click on the pivot table report.

Then, on the pivot table toolbar, you can find the "Refresh Data" button which will update the report with the latest data from the source.

Therefore, the correct method is to click the refresh data button, making Option C the correct answer.