Microsoft Access MCQs with answers Page - 6

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 • 833K Points
Coach

Q. Print options can be changed in the Print _________.

  • (A) Dialog box
  • (B) Setup routine
  • (C) Layout mode
  • (D) Tab

A

Admin • 833K Points
Coach

Q. In Datasheet View, new records are added to a table _________.

  • (A) In numerical order
  • (B) At the beginning of the table
  • (C) At the end of the table
  • (D) In alphabetical order

A

Admin • 833K Points
Coach

Q. A(n) ________ in the Record Selector indicates a new record.

  • (A) Arrow
  • (B) Asterisk
  • (C) Pencil
  • (D) Check mark

A

Admin • 833K Points
Coach

Q. The ability of a database to grow as the data tracking needs grow is its _________.

  • (A) Platform-independence
  • (B) Maintainability
  • (C) Expandability
  • (D) Scalability

A

Admin • 833K Points
Coach

Q. This database has only one table.

  • (A) DBMS
  • (B) Flat-file
  • (C) Large
  • (D) Relational

A

Admin • 833K Points
Coach

Q. The ________ is used to access one record at a time.

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

A

Admin • 833K Points
Coach

Q. Which of the field has width 8 bytes?

  • (A) Hyperlink
  • (B) Date/time
  • (C) Number
  • (D) Memo

A

Admin • 833K Points
Coach

Q. A __________ enables you to view data from a table based on a specific criterion

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

A

Admin • 833K Points
Coach

Q. Which of the following is a method to create a new table in MS Access?

  • (A) Create table in design view
  • (B) Create table by entering data
  • (C) Create table using wizard
  • (D) All of the above

A

Admin • 833K Points
Coach

Q. What is a form in MS Access?

  • (A) It is a printed page where users will write their data to fill it up
  • (B) It is an input screen designed to make the viewing and entering data easier
  • (C) This is an important part of database used by analysts to draw conclusions
  • (D) All of above