Database 1

Examine the database shown in the image. How many fields are in the database?

How many records are in the database?

• 39

• 6

• 174

A query is to be performed to find a list of green cars. What field would be used in the query?

• Make

• Model

• Colour

• Registration No

A query is to be performed to find a list of Audis. What field should be used in the query?

• Make

• Model

• Colour

• Registration No

A query is to be performed to find a list of red Fords. What fields should be used in the query?

• Make

• Model

• Colour

• Registration No

A query is to be performed to find a list of black Citroen Ami cars. What fields should be used in the query?

• Make

• Model

• Colour

• Registration No

A query is to be performed to find the name of the owner of the car with the registration number P197 CWX. What fields should be used in the query?

• Make

• Model

• Owner

• Registration No

Examine the database shown, how many fields are in the database?

How many records are in the database?

• 39

• 65

• 25

A query is to be used to find a list of people with Blonde hair. What fields should be used in the query?

• Gender

• Age

• Eye Colour

• Hair Colour