DBMS

A table is divided into __________________

• field and form

• fields and records

• datasheet and design

• record and form

Which of these options is the best to use for a primary key?

• Number

• Currency

• Short Text

• Autonumber

We have two kinds of view in Access. Datasheet view and _____________ view.

Which view can be used to enter data into the database?

• Design View 

• Record View

• Field View

• Form View

In Microsoft Access, a field labelled “Price” must be created as

• Currency

• Primary Key

• Number 

• Short Text

Which of these is not an example of a field type?

• Picture

• Short Text

• Date and Time

• Yes/No

A Primary Key is a code that uniquely identifies a _____________ in a Database.

• Record

• Field

• Text

• Number

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell

• Field

• Column

• Record

In a database table, rows are called __________

• Field

• Record

• Primary Key

Forms, queries, and reports are created based on the information in the _________

• Form
• Table
• Report