Home » Microsoft Access MCQ Questions with Answer

Microsoft Access MCQ Questions with Answer

In this Microsoft Access Multiple Choice Questions (MCQ) with Answer, you will find all the relevant topics of MS Access subject. These MCQs will help you to prepare for any interviews, exams, certification, quiz & online test. There are multiple sets of questions are available in this MS Access MCQ. These MCQs have 10 questions in each set. You will find the most relevant and accurate topics to enhance your MS Access knowledge. You should take all the quiz 1 by 1 to increase your skills or get better opportunities in your current role.

Microsoft Access MCQ Questions and Answers:

Below are the multiple choice questions for Microsoft Access, covering a range of topics related to the use of the software.

Q1. Which data type allows alphanumeric characters and special symbols?

  1. Text
  2. Memo
  3. Auto number
  4. None of the mentioned

1. Text


Q2. What is a database language that deals with the definition of a complete database structure and schema?

  1. DCL
  2. DML
  3. DDL
  4. All of above

3. DDL


Q3. Which field has a width of 8 bytes?

  1. Memo
  2. Number
  3. Date/Time
  4. Hyperlink

3. Date/Time


Q4. The database language that allows you to access or maintain data in a database is called?

  1. DCL
  2. DML
  3. DDL
  4. None of the mentioned

2. DML


Q5. Queries in Access can be used as?

  1. View, change and analyze data in different ways
  2. A source of records for forms and reports
  3. View, change and analyze data in different ways and a source of records for forms and reports
  4. None of the mentioned

3. View, change and analyze data in different ways and a source of records for forms and reports


Q6. Which of the following steps do you take if you need to edit a relationship?

  1. Right click the relationship line and choose Edit Relationship
  2. Double click the relationship line
  3. Right click the relationship line and choose Edit Relationship and Double click the relationship line
  4. None of the mentioned
You May Also Like :   Microsoft Word MCQ Questions with Answer

3. Right click the relationship line and choose Edit Relationship and Double click the relationship line


Q7. Each record is constituted by a number of individual data items which are called?

  1. Fields
  2. Data Types
  3. Relations
  4. Tables

1. Fields


Q8. An organized collection of logically related data is known as?

  1. Data
  2. Meta data
  3. Database
  4. Information

3. Database


Q9. How many relations may exist between tables in databases?

  1. 4
  2. 2
  3. 3
  4. 1

3. 3


Q10. Which function cannot be used for calculated controls in reports?

  1. SUM
  2. AVG
  3. MPT
  4. COUNT

3. MPT


MS Access MCQ Quiz and Online Test:

These MS Access MCQ practice sets gives you the feeling of reality and a clue to the questions asked in the actual Microsoft Excel related exams. When you solve these MCQ questions practically, you come across many difficulties that give you an opportunity to improve.

4.5/5 - (15 votes)
Scroll to Top