Microsoft Access MCQ Questions with answers and solutions Page 93

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

Q. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

(A) The pin code
(B) The last name
(C) A compound key consisting of the first name and the last name
(D) All of the above

💬 Discuss

✅ Correct Answer: (C) A compound key consisting of the first name and the last name

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Microsoft Access

Q. What happens when you add the asterisk (*) from any field list ot a query?

(A) The table will not include any fields from the table
(B) The query sorts the table’s record in the order you specify
(C) The query will include every field from the table
(D) The query uses the records from the table without displaying them

💬 Discuss

✅ Correct Answer: (C) The query will include every field from the table

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Microsoft Access

Q. The filter by selection feature allows you to filter:

(A) Those records that match an entity in a field
(B) Records based on a criterion you specify
(C) Records that meet any of several criteria you specify
(D) All of above

💬 Discuss

✅ Correct Answer: (A) Those records that match an entity in a field

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Microsoft Access

Q. What is the purpose of the description column in table design view?

(A) To define the data type applied to each field within the table
(B) To describe the data that should be entered in each field
(C) To enter lookup data that the field should refer to.
(D) None of the ablve

💬 Discuss

✅ Correct Answer: (B) To describe the data that should be entered in each field

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Microsoft Access

Q. Which of the following is not a selection technique

(A) To select a word, double click the word
(B) To select an entire table click the empty bosx to the left of the field names
(C) To select a row, click the record selector box to the left of the row
(D) To select a column, double click anywhere in the column

💬 Discuss

✅ Correct Answer: (D) To select a column, double click anywhere in the column

I

Indresh Gehalot

🎓 Tutor II ⭐ 10.11K Points

📊 Microsoft Access

Q. In MS-Access, a table can have primary key /keys ?

(A) One
(B) Two
(C) Three
(D) Four

💬 Discuss

✅ Correct Answer: (A) One

Explanation: The correct answer is (1) One. In Microsoft Access, a table can have one primary key. A primary key is a unique identifier for each record in a table. It ensures that each record in the table is uniquely identified and provides a way to access and manipulate data in the table. The primary key can be composed of one or more fields in the table, but there can only be one primary key per table.

V

Vinay

🎓 Mover ⭐ 28.75K Points

📊 Microsoft Access

Q. Which of the following methods CANNOT be used to delete records from a table?

(A) Selecting records and pressing [Delete]
(B) Pressing [Ctrl]+[\']
(C) Clicking the Delete Record button
(D) From the ribbon, selecting Delete Record

💬 Discuss

✅ Correct Answer: (B) Pressing [Ctrl]+[\']

P

Praveen Singh

🎓 Tutor III ⭐ 36.81K Points

📊 Microsoft Access

Q. Which of the following statement is true?

(A) Foreign key fields don\'t allow duplicate values
(B) In primary key field you can enter duplicate value
(C) In an indexed field you may or may not enter duplicate value depending upon setting
(D) All statements are true

💬 Discuss

✅ Correct Answer: (C) In an indexed field you may or may not enter duplicate value depending upon setting

V

Vikash Gupta

🎓 Tutor III ⭐ 33.56K Points

📊 Microsoft Access

Q. When increasing the Control Padding, space is added where?

(A) Between the content of the controls and the outside edge of then controls
(B) Between all controls
(C) Between the control and the Form\'s edge
(D) Between controls and gridlines

💬 Discuss

✅ Correct Answer: (B) Between all controls

P

Praveen Singh

🎓 Tutor III ⭐ 36.81K Points

📊 Microsoft Access

Q. In a query, what symbol is used to surround a parameter\'s user prompt?

(A) [ ]
(B) { }
(C) " "
(D) ( )

💬 Discuss

✅ Correct Answer: (A) [ ]

Microsoft Access MCQs with answers Page - 93

Mr. Dubey

Mr. Dubey

Mr. Dubey

Mr. Dubey

Mr. Dubey

Indresh Gehalot

Vinay

Praveen Singh

Vikash Gupta

Praveen Singh

Programming Categories

📱 Download Our App