Unit 1

Question 1

Name 4 data types

Answer 1

• Numeric
• Date
• Text
• Boolean

Question 2

Define Record

Answer 2

A record is a unit of data that is made up of a number of fields

Question 3

Define Key field

Answer 3

A value that uniquely identifies a record in the table

Question 4

Another name for a key field

Answer 4

Primary key

Question 5

Validation ensures…

Answer 5

• Text is present
• In the correct range
• In the correct format

Question 6

Name 5 types of data validation

Answer 6

• Presence check
• Length check
• Type check
• Range check
• Format check

Question 7

Define relationship

Answer 7

A link between two tables

Question 8

2 advantages of a relationship

Answer 8

• It can reduce the amount of data which has to be stored

- It makes the searching and sorting of data more efficient

Question 9

Define a wizard

Answer 9

A wizard is software that helps the user to complete a task step by step

Question 10

What would you use a wizard to create

Answer 10

• Reports
• Queries
• Forms

Question 11

What is mail merge

Answer 11

Users can create standard documents and merge records from the database onto the documents

Question 12

Common features of a spreadsheet package

Answer 12

• They perform calculations and re calculations automatically
• They allow results to be displayed in tabular or graphic format
• They consist of a table divided into rows and columns to produce cells
• They consist of a number of worksheets