ACCESS

The software that we would use to create a database is

• Microsoft Publisher

• Microsoft Excel

• Microsoft Word

• Microsoft Access

In a database, data is stored in

• Tables

• Forms

• Reports

• Queries

Which of the following would be used to uniquely identify a record?

• Validation

• Data type

• Primary key

• Field size

The best data type to choose for date of birth would be

• Number

• Text

• Date/Time

• Currency

Where do you find the field properties of a Table?

• Design View

• Datasheet View

• Access View

A collection of records is a ____________.

• Table

• Field

• Guide

• File

Which key is used to identify record in other table?

• Primary key

• Super key

• Foreign key

• Candidate key

In which query the condition is to be given in the criteria box______.

• Select query

• Parameter query

• Table

__________ is the place which is used to view all the database objects which is already created.

• Task pane

• Design pane

• Navigation pane

Which query is used to add records from other table?

• Select query

• Parameter query

• Action query