MS Access, Design View, Queries, Forms and Reports

A computerized record keeping system is called as

• Communication system

• Database management System(DBMS)

• Networking System

6. What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

• Query

• Form

• Report

• Table

Access can import a table of data from Excel.

• True

• False

A unique identifier used in creating a table that assures there will be no duplicate data.

• Primary Key

• Query

• Data Type

DBMS stands for-

• Data basic maintenance system

• Data base maintenance system

• Data base management system

• Data base managed system

Fields in database are similar to _________ in tables.

• Rows

• Columns

• Cells

• Values

What you understand by data redundancy?

• Assurance of the accuracy of data

• Duplicate values in database

• Security of Data

• None of these

Which view of table is used to insert a field name in table.

• Design View

• Datasheet View

• All of these

Which datatype will be used to generate numbers automatically while inserting data?

• Number

• Auto number

• Integer

• Lookup

Which option is used to display the data in printable format in MS-Access?

• Report

• Query

• Form

• Module