Ms Access Databases

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

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

Tick the Functions of a Database

• Updating

• Sorting

• Editing

• Playing

Fields in database are similar to _________ in tables.

• Rows

• Columns

• Cells

• Values

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

• Date sheet

• Design

• Database

• all of the above

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

• Number

• Auto number

• Automatic Number

• Integer

What kind of data type do you use when entering a Client Number?

• Short Text
• Currency
• Number
• Autonumber