Working With A Database

Match the sentence starters and endings together – copy out the complete sentences

STARTERS

Every record in a database is made unique…

If you cannot create a relationship between tables…

If a query does not find a match…

When designing a database you should put different entities…

If you were to store numbers as text…

You can save time when entering data into a table…

You can make the results of a query easier to use …

You can make sure that important data is not left out of a table…

ENDINGS

…check that the spelling of the criteria is correct

…by setting field required to “Yes”

…by setting a primary key

…by using a lookup wizard where there is a limited range of data

…into separate tables

…by sorting the results into order

…you would not be able to sort them into order or perform calculations such as adding and finding averages

…check that the information in the foreign key is identical to the primary key AND check that they are the same field types (e.g. number)