Microsoft Access MCQs with answers Page - 92

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. In access, the best types of queries to use for data analysis are:
  • (A) Select queries
  • (B) Parameter queries
  • (C) Action queries
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (A) Select queries
📊 Microsoft Access
Q. How can you add a table to the relationship window?
  • (A) Select tools>add table from the menu
  • (B) Select the table from the table list on the toolbar
  • (C) Click the show table button on the toolbar
  • (D) Select edit>add table from the menu
💬 Discuss
✅ Correct Answer: (B) Select the table from the table list on the toolbar
📊 Microsoft Access
Q. What is the first step in creating a form or report with the form wizard or report wizard?
  • (A) Selecting the fields that you want to appear in the form or report
  • (B) Selecting the underlying table or query on which you want to base the form or report
  • (C) Reading several screens of mostly useless information and clicking next
  • (D) Selecting how the form or report should be formatted
💬 Discuss
✅ Correct Answer: (B) Selecting the underlying table or query on which you want to base the form or report
📊 Microsoft Access
Q. The arranging of data in a logical sequence is called
  • (A) Sorting
  • (B) Classifying
  • (C) Reproducing
  • (D) Summarizing
💬 Discuss
✅ Correct Answer: (A) Sorting
📊 Microsoft Access
Q. According to access help, what’s a good way to design a database?
  • (A) Start from data access pages and work backward
  • (B) Sketch the design of your database using a pencil and paper
  • (C) Use the table analyzer to reverse-engineer your flat source data.
  • (D) None of above
💬 Discuss
✅ Correct Answer: (B) Sketch the design of your database using a pencil and paper
📊 Microsoft Access
Q. If a piece of data is stored in two places in the database, then
  • (A) Storage space is wasted
  • (B) Changing the data is one spot will cause data inconsistency
  • (C) It can be more easily accessed
  • (D) Both a and b
💬 Discuss
✅ Correct Answer: (D) Both a and b
📊 Microsoft Access
Q. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As
  • (A) Tables
  • (B) Relations
  • (C) Tuple
  • (D) Both a and b
💬 Discuss
✅ Correct Answer: (D) Both a and b
📊 Microsoft Access
Q. Which of the following database objects asks a question of information in a database and then displays the result?
  • (A) Tables
  • (B) Reports
  • (C) Queries
  • (D) Forms
💬 Discuss
✅ Correct Answer: (C) Queries
📊 Microsoft Access
Q. What data type should yo choose for a zip code field in a table?
  • (A) Text
  • (B) Number
  • (C) Memo
  • (D) All of above
💬 Discuss
✅ Correct Answer: (A) Text
📊 Microsoft Access
Q. In order to use dbms, it is important to understand
  • (A) The physical schema
  • (B) All sub schemas that the sytem supports
  • (C) One sub schema
  • (D) Both a and b
💬 Discuss
✅ Correct Answer: (C) One sub schema

Programming Categories

📱 Download Our App

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

Get it on Google Play