Chapter 10 (Database)

Question 1

What is a query?

Answer 1

Used to search and extract data from a database

Question 2

What is a report?

Answer 2

Allows tables and results of queries to be presented in a user-friendly way

Question 3

What is a database relationship?

Answer 3

They link two or more tables in a database using a relationship type

Question 4

Name the 6 datatypes

Answer 4

• text
• number
• date/time
• currency
• Autonumber
• yes/no

Question 5

What is data validation?

Answer 5

it ensures data entered is sensible in range and the right data type

Question 6

name three types of data validation

Answer 6

• range check
• length check
• type check