Quiz on Microsoft Access

What is Access?

• Application software

• Database management system produced by Microsoft

• Hardware

• Both A and B

What are the main functions of Access?

• Create tables

• Calculate and extract data

• Store data

• All of the above

Access is a database management system for

• Personal computers

• Computer networks in the global network

• Computers running in a local network

• Both A and C

What are the basic objects in Access?

• Table, Macro, Form, Query

• Table, Macro, Form, Report

• Table, Query, Form, Report

• Table, Macro, Module, Report

To format, calculate, summarize, and print data, we use

• Table

• Form

• Query

• Report

In Access, to open a saved database, which command is correct?

• File/new/Blank Database

• Create table by using wizard

• File/open/

• Create Table in Design View

To start Access, we perform

• Double-click the Access icon on the desktop

• Click the Access icon on the desktop

• Start All Programs Microsoft Office Microsoft Access

• A or C

To end a session with Access, perform the action:

• File/Close

• Click the (X) button at the top right corner of the Access working screen

• File/Exit

• B or C

The Validation Text property of field A will specify

• Error message when entering an invalid value for field A

• Message that appears when the cursor moves to column A

• Condition required for the cursor to move to column A

• Valid data conditions to limit the range of values entered in field A

The database management system used in Access is

• Distributed database

• Object-oriented database

• Relational database

• Centralized database