A sort order for records, which is identified in the table design

A wizard that creates a functional database structure based on the user's selections

A widely recognized naming convention for database objects

A sort order for records, which is identified in the table design

A set of relationship rules that enforce defined database relationships

Learn Microsoft Access MCQ Questions with answers and solutions.

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

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

A

Admin • 833.24K Points
Coach

Q. In a query's Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

(A) The join line but not the relationship between the two tables
(B) The relationship between the two tables locally
(C) The relationship between the two tables globally
(D) The primary key of the first table

A

Admin • 833.24K Points
Coach

Q. What is an index?

(A) A wizard that creates a functional database structure based on the user's selections
(B) A widely recognized naming convention for database objects
(C) A sort order for records, which is identified in the table design
(D) A set of relationship rules that enforce defined database relationships

A

Admin • 833.24K Points
Coach

Q. Which of the following is invalid field name?

(A) Student.Address
(B) Student'sAddress
(C) Student_Address
(D) Student Address

A

Admin • 833.24K Points
Coach

Q. In a table to insert User's Voice, Data field should be

(A) OLE Object
(B) SoundField
(C) VoiceField
(D) Memo

A

Admin • 833.24K Points
Coach

Q. What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

(A) The associated code is displayed in the Code pane.
(B) The associated code is displayed in a new window.
(C) The object is deleted from the Project pane.
(D) The object's property sheet opens.

A

Admin • 833.24K Points
Coach

Q. Which do you click to display the table's primary key and indexes in a separate window?

(A) indexes button
(B) primary key button
(C) view datasheet button
(D) view design button

Microsoft Access MCQs with answers Page - 93

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

Q. Which of the following statement is true?

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

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

Q. In a query's Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

Q. What is an index?

Q. Which of the following is invalid field name?

Q. In a table to insert User's Voice, Data field should be

Q. What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

Q. Which do you click to display the table's primary key and indexes in a separate window?

Add MCQ in this Category

Browse Categories