Topic 4 Database Applications

Question 1

In a database a key field has a _______ value for each _____

Answer 1

Different value for each record

Question 2

A database and main document are required to create what? What is it necessary for the main document to have too?

Answer 2

Main document needs merge fields
Both needed to create a mail merge.

Question 3

What is the most appropriate validation check for the following and why?
Surname
Budget
Age
Password

Answer 3

Surname- presence check- to be certain it’s filled it
Budget - type check - must be in pounds
Age - range check - must be a number between eg 10-18
Password - length check - can’t be too short

Question 4

Name 3 relationships that can be created in a relational database?

Answer 4

One to one
One to many
Many to many

Question 5

What defines the format of data being entered?

Answer 5

Data type

Question 6

What is a wizard?

Answer 6

Program that helps a user with a simple task

Question 7

What is a single item of data called?

Answer 7

File

Question 8

How can a dropdown help users during data entry?

Answer 8

Can’t enter incorrect information
Quicker
Accurate

Question 9

What is the purpose of primary key in a table?

Answer 9

Uniquely identifies data

Question 10

What is data analytics?

Answer 10

The application of algorithms to data to identify patterns