| A | B |
|---|
| The data type for part number is | Text |
| The data type for on order is | Number |
| The data type for value on order is | Currency |
| The field length for part number is | 6 |
| The field length for description is | 35 |
| A primary key is | a unique field |
| A foreign key is | A primary key of another table |
| An 'And' query is | Where there is more than one criteria to be searched for |
| A relationship formed between tables in a database allows you to | Gather information from all of the related tables |
| Select correct formula for adding cells | =SUM(F2:F9) |
| If you were asked to produce a graph or chart which shows the total owed for each item as part of the grand total owed for all items, what sort of graph or chart would you use? | Pie chart |
| What does the absolute cell address do? | It fixes the cell reference in a formula |
| The correct axis for a bar chart are | x on the bottom y on the side |
| The software package used to create your database is? | Microsoft Access |
| The software package used to create your spreadsheet is? | Microsoft Excel |
