Microsoft Access MCQ Questions with answers and solutions Page 16

Q. Which of the following creates a drop down list of values to choose from?

(A) Lookup wizard
(B) Memo
(C) Hyperlink
(D) Ole object

💬 Discuss

✅ Correct Answer: (A) Lookup wizard

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:25 pm in Microsoft Access

Q. Which of the following is not a database model

(A) Network database model
(B) Relational database model
(C) Object oriented database model
(D) None

💬 Discuss

✅ Correct Answer: (D) None

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:26 pm in Microsoft Access

Q. Which of the following is not a database object?

(A) Reports
(B) Relationships
(C) Queries
(D) Tables

💬 Discuss

✅ Correct Answer: (B) Relationships

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:27 pm in Microsoft Access

Q. To create queries in access

(A) You can drag and drop fields on query builders
(B) You can type the sql command in sql view
(C) You can use query wizard or design view
(D) All of above

💬 Discuss

✅ Correct Answer: (D) All of above

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:31 pm in Microsoft Access

Q. What do you mean by one-to-many relationship between student and class table?

(A) Many students may have many classes
(B) Many classes may have many students
(C) One class may have many students
(D) One student can have many classes

💬 Discuss

✅ Correct Answer: (D) One student can have many classes

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:32 pm in Microsoft Access

Q. 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

💬 Discuss

✅ Correct Answer: (B) Select

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:33 pm in Microsoft Access

Q. The operation of checking input data against specified criteria is known as?

(A) Data control
(B) Cross check
(C) Data validation
(D) Data verification

💬 Discuss

✅ Correct Answer: (C) Data validation

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:34 pm in Microsoft Access

Q. The ascending order of data hierarchy is?

(A) Bit – byte – field – record – database – file
(B) Byte – bit – field – record – file – database
(C) Bit – byte – record – field – file – database
(D) Bit – byte – field – record – file – database

💬 Discuss

✅ Correct Answer: (D) Bit – byte – field – record – file – database

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:34 pm in Microsoft Access

Q. In the form wizard dialog box, the fields from the selected table are displayed in this list box.

(A) Available fields
(B) Available records
(C) All records
(D) All fields

💬 Discuss

✅ Correct Answer: (A) Available fields

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:35 pm in Microsoft Access

Q. Which of the following is NOT a type of Microsoft Access database object?

(A) Modules
(B) Worksheets
(C) Form
(D) Table

💬 Discuss

✅ Correct Answer: (B) Worksheets

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 10:37 pm in Microsoft Access

Previous
First
16
17
18
19
20
....
Last
Next

Jump to