Microsoft Access MCQ Questions with answers and solutions Page 7

Q. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

(A) Columnar
(B) Justified
(C) Tabular
(D) Datasheet

💬 Discuss

✅ Correct Answer: (B) Justified

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

Q. In a database table, the category of information is called _________

(A) Tuple
(B) Field
(C) Record
(D) All of above

💬 Discuss

✅ Correct Answer: (B) Field

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

Q. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

(A) Database Tab
(B) External Data Tab
(C) Create Tab
(D) Home Tab

💬 Discuss

✅ Correct Answer: (A) Database Tab

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

Q. The size of Yes No field is always

(A) 1 GB
(B) 1 character
(C) 1 byte
(D) 1 bit

💬 Discuss

✅ Correct Answer: (D) 1 bit

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

Q. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

(A) Indexed
(B) IME Mode
(C) Input mask
(D) Validation Rule

💬 Discuss

✅ Correct Answer: (C) Input mask

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

Q. Which field type will you select when creating a new table if you require to enter long text in that field?

(A) Hyperlink
(B) Currency
(C) Memo
(D) Text

💬 Discuss

✅ Correct Answer: (C) Memo

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

Q. This option allows you to build a new table by entering data directly into the datasheet.

(A) Datasheet view
(B) Design view
(C) Link table
(D) None of the above

💬 Discuss

✅ Correct Answer: (A) Datasheet view

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

Q. Which is not a view to display a table in Access?

(A) Datasheet View
(B) Design View
(C) Pivot Table & Pivot Chart View
(D) None of above

💬 Discuss

✅ Correct Answer: (D) None of above

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

Q. Which of the following database object produces the final result to present?

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

💬 Discuss

✅ Correct Answer: (C) Reports

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

Q. Referential integrity means

(A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
(B) Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
(C) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
(D) All of above

💬 Discuss

✅ Correct Answer: (A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

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

Microsoft Access MCQs with answers Page - 7

Q. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

Q. In a database table, the category of information is called _________

Q. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

Q. The size of Yes No field is always

Q. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

Q. Which field type will you select when creating a new table if you require to enter long text in that field?

Q. This option allows you to build a new table by entering data directly into the datasheet.

Q. Which is not a view to display a table in Access?

Q. Which of the following database object produces the final result to present?

Q. Referential integrity means

Programming Categories

📱 Download Our App