Microsoft Access MCQs with answers Page - 1

Here, you will find a collection of MCQ questions on Microsoft Access. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

A

Admin • 799.53K Points
Coach

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

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

A

Admin • 799.53K Points
Coach

Q. Which type of field is incremented automatically?

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

A

Admin • 799.53K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.