Microsoft Access MCQ Questions with answers and solutions Page 91

Q. what is the corresponding text for the <#1/1/95# validation rule setting?

(A) Neter a value less or more than 1,195
(B) Value must be less than 95 characters
(C) Enter a date before 1995
(D) All of above

💬 Discuss

✅ Correct Answer: (A) Neter a value less or more than 1,195

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. which of the following is not a data type

(A) Picture/graphic
(B) Data/time
(C) Texst
(D) Number

💬 Discuss

✅ Correct Answer: (A) Picture/graphic

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. the executive responsible for the data processing function in an organization is

(A) Pm
(B) Dbms
(C) Dp
(D) Dpm

💬 Discuss

✅ Correct Answer: (B) Dbms

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. which of the following is not a type of Microsoft Access database object?

(A) Queries
(B) Workbooks
(C) Forms
(D) Tables

💬 Discuss

✅ Correct Answer: (B) Workbooks

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. a file containing relatively permanent data is

(A) Random file
(B) Transaction file
(C) Master file
(D) Sequential file

💬 Discuss

✅ Correct Answer: (C) Master file

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. the complete picture of data stored in database is known as

(A) Record
(B) Scheme
(C) System flowchart
(D) Dbms

💬 Discuss

✅ Correct Answer: (B) Scheme

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. a subset of characters within a data field is known as

(A) Record
(B) File
(C) Data string
(D) Byte

💬 Discuss

✅ Correct Answer: (C) Data string

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. what is a fast way t adjust the width of a column?

(A) Right click the left side of the column heading
(B) Double click the left side of the column heading
(C) Double click the right side of the column heading
(D) Select tools>adjust column width from the menu

💬 Discuss

✅ Correct Answer: (C) Double click the right side of the column heading

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. what are the columns in a Microsoft Access table called?

(A) Rows
(B) Fields
(C) Cells
(D) Records

💬 Discuss

✅ Correct Answer: (B) Fields

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Q. how do you update pivot table report data after changes are made to the source data?

(A) Save your changes, close the workbook, and then reopen it.
(B) Select the pivot table worksheet and press f9 on the keyboard
(C) Click the report, and on the pivot table toolbar, click the refresh data button
(D) All of the above

💬 Discuss

✅ Correct Answer: (C) Click the report, and on the pivot table toolbar, click the refresh data button

Published by Mr. Dubey ⭐ 111.54K Points at 14-Jan-2024 12:39 pm in Microsoft Access

Microsoft Access MCQs with answers Page - 91

Q. what is the corresponding text for the <#1/1/95# validation rule setting?

Q. which of the following is not a data type

Q. the executive responsible for the data processing function in an organization is

Q. which of the following is not a type of Microsoft Access database object?

Q. a file containing relatively permanent data is

Q. the complete picture of data stored in database is known as

Q. a subset of characters within a data field is known as

Q. what is a fast way t adjust the width of a column?

Q. what are the columns in a Microsoft Access table called?

Q. how do you update pivot table report data after changes are made to the source data?

Programming Categories

📱 Download Our App