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

📊 Microsoft Access
Q. Which of the following store command to retrieve data from database?
  • (A) Tables
  • (B) Queries
  • (C) Reports
  • (D) Forms
💬 Discuss
✅ Correct Answer: (B) Queries
📊 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 student
  • (D) One student can have many classes
💬 Discuss
✅ Correct Answer: (D) One student can have many classes
📊 Microsoft Access
Q. Which of the following term is least related to database?
  • (A) Columns
  • (B) Relationship
  • (C) Tuples
  • (D) Attributes
💬 Discuss
✅ Correct Answer: (A) Columns
📊 Microsoft Access
Q. A database object in MS Access that stores a question about the data in database?
  • (A) Report
  • (B) Query
  • (C) Form
  • (D) Table
💬 Discuss
✅ Correct Answer: (B) Query
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (D) Characters, Fields, Records, Tables, Files, Databases
📊 Microsoft Access
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
💬 Discuss
✅ Correct Answer: (B) Click the Primary Key button in Design ribbon when the cursor is in required field
📊 Microsoft Access
Q. Which of the following is not a logical database structure?
  • (A) Relational
  • (B) Tree
  • (C) Network
  • (D) Chain
💬 Discuss
✅ Correct Answer: (D) Chain
📊 Microsoft Access
Q. Which type of field is incremented automatically?
  • (A) Auto Value
  • (B) Auto Increment
  • (C) AutoNumber
  • (D) Auto Elevate
💬 Discuss
✅ Correct Answer: (C) AutoNumber
📊 Microsoft Access
Q. Which tool do you use to create a query object?
  • (A) Table query wizard
  • (B) Simple query wizard
  • (C) Simple filter wizard
  • (D) Database wizard
💬 Discuss
✅ Correct Answer: (B) Simple query wizard
📊 Microsoft Access
Q. How many relations may exist between tables in databases?
  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4
💬 Discuss
✅ Correct Answer: (C) 3

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play