Database concepts part 1 & 2

A single set of related data values is referred to as

• Data Value

• Field

• Record

• Table

What is used to uniquely identify each record in a table?

• Foreign key

• Field

• Data type

• primary key

What data type stores date and time values between the years 100 through 9999?

• Date

• Time

• Date/Time

• Memo

The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.

• Datasheet View

• Design View

• Table View

• Wizard View

You can select multiple fields of a table in design view by using the ________ key.

• Alt

• Spacebar

• Shift

• Tab

• Ctrl

What validation rule should be entered for a StudentID which should start with the letter "S"

• Like 'S*'

• Like S*

• Like "S"

• Like "S*"

In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?

• Caption

• Validation Text

• Required

• Validation Rule

• Default

Indicate whether the following statement is true or false. Statement: A table can have only one Primary Key

• True

• False

What is the purpose of forms?

• It is used to store data

• It provides a user-friendly interface for entering data into tables

• It is used to retrieve data from tables

• It is used to print or preview data in different formats

A table called students has to be searched to find out how many males are in the class. Which object can be used to achieve this?

• Macros

• Forms

• Queries

• Reports

• Modules