Database Basics - revision

When is a database used?

•  To perform searches for information on the Internet
•  To create and format text documents for sharing information
•  To display information in a picture form instead of using words
•  To store and organize large amounts of information for quick searching

Databases store information in ___________________, which are made up of columns and rows.

• tabs
• tables
• ribbons
• image files

A column in a database.

• Field
• Record
• Entity
• Validation

A row in a database.

• Record
• Field
• Entity
• Table

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

Text, Number, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

A rule to make sure that only reasonable and sensible data is entered.

• Filter
• Query
• Validation
• Verification

3.  In the Doctors Table, all of the information about Pam Pauls is classified as a/an: 

• entry
• field
• file
• record

In the Doctors Table, Resident is classified as a/an: 

•  entry
• field
• file
• record

4.  Which field in the Doctors Table CANNOT be formatted with a drop-down list? 

• Doctor ID
• First Name
• Last Name
• Resident