MS ACCESS QUIZ

The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.

• Fields

• records

• Data

• None of these

Each table must have only one column set as __________

• Foregin Key

• Primary Key

• Design Key

To create a table, click on Create and then

• Forms

• reports

• queries

• Table

The Primary Key is a __________ identifier for a record

• Distinct

• unique

• None of these

Which field has primary key in the given table

• Address 1

• CustomerName

• Customer ID

_______ is used to store alphanumeric data

• Text

• Number

• Date time

• Curency

_______ is used to store numeric data

• Text

• Number

• Date time

• Curency

If you want to enter the birth date of the student which data type will you use?

• Text

• Number

• Date time

• Curency

Mr. Faris wants to save the price of the product he selling in the market so he used number datatype. Is he correct? Why?

• Yes, correct price is a number,

• No, not correct because price is a currency

• None of these

The field name should not be more than _____characters

• 60

• 64

• 66

• 68