Home / Programming Questions / Microsoft Access MCQs / Page 1

Microsoft Access MCQs with answers Page - 1

Dear candidates you will find MCQ questions of Microsoft Access here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

Q. Which of the following store command to retrieve data from database?

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

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 student
(D) One student can have many classes

Q. Which of the following term is least related to database?

(A) Columns
(B) Relationship
(C) Tuples
(D) Attributes

Q. A database object in MS Access that stores a question about the data in database?

(A) Report
(B) Query
(C) Form
(D) Table

Q. Which of the following expresses correct order?

(A) Files, Databases, Tables, Records, Fields, Characters
(B) Databases, Tables, Files, Records, Field, Character
(C) Characters, Fields, Records, Tables, Database, Files
(D) Characters, Fields, Records, Tables, Files, Databases

Q. To create primary key for a table when in design view

(A) Type PRIMARY in field type box when creating
(B) Click the Primary Key button in Design ribbon when the cursor is in required field
(C) Mark the Primary check box in field name of required field
(D) None of the above

Q. Which of the following is not a logical database structure?

(A) Relational
(B) Tree
(C) Network
(D) Chain

Q. Which type of field is incremented automatically?

(A) Auto Value
(B) Auto Increment
(C) AutoNumber
(D) Auto Elevate

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.