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
💬 Discuss
✅ Correct Answer: (B) Queries

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 01:59 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:00 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:01 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:01 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:02 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:03 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:04 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:04 pm in 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

Published by Ram Sharma ⭐ 193.88K Points at 24-Jul-2022 02:05 pm in 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

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

Programming Categories

📱 Download Our App

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

Get it on Google Play