Quiz on Microsoft Access

What type of data does Microsoft Access primarily deal with?

• Text, numbers, files, and all kinds of data

• Only graphical data

• Only text data

• Only numerical data

How does Microsoft Excel differ from Access?

• Excel is a database management system

• Excel allows for data entry forms

• Excel generally deals with numerical data

• Excel stores data in one place only

What is a key feature of Access regarding data storage?

• Data is stored multiple times

• Data cannot be stored

• All data is stored one time, in one place

• Data is stored in separate files

Which view in Access is used to enter and view data for records?

• Form View

• Datasheet View

• Report View

• Design View

What does the Design View in Access allow you to do?

• Enter data

• View reports

• Set data types and insert or delete fields

• Create queries

What is a DBMS?

• A word processor

• A graphical design tool

• A database management system that includes data, forms, queries, and reports

• A type of spreadsheet

What is the main advantage of using Access for data entry?

• Data accuracy and speed are high

• Data accuracy and speed are not much affected

• It is easier to use than Excel

• It does not require a computer

What is the first step to create a new database in Access?

• Select an existing database

• Enter the name and click the Create button

• Open a spreadsheet

• Choose a template

Which of the following is NOT a feature of Access?

• Storing data in multiple worksheets

• Creating highly functional data entry forms

• Running queries

• Generating reports

What is the purpose of queries in a DBMS?

• To enter data

• To store data

• To analyze and retrieve specific data

• To create forms