Topic 4: Manipulating data

Question 0

What are numbers useful?

Answer 0

Used for storing numbers that can be used in calculations, such as integers (i.e. whole numbers), numbers to a certain number of decimal places, percentages and fractions.

Question 1

What is text used for?

Answer 1

Used for storing names, words and numbers that are not used in calculations (telephone numbers, code numbers, credit card numbers, etc.)

Question 2

What is currency used for?

Answer 2

Used for storing monetary values to 2 decimal places.

Question 3

What is auto number?

Answer 3

These are numbers allocated by the computer. It is useful when you want to give each record a unique number (student number, bank account number, etc.)

Question 4

What is a Boolean?

Answer 4

This is used when only one of two choices can be entered for a field (yes/no, male/female, etc.)

Question 5

What are lists?

Answer 5

Useful when there is a limited number of choices you can choose from. The user is presented with a list to choose from. (For example, enter the year 7, 8, 9, 10 or 11.) You can also have radio buttons (i.e. you mark your choice by filling in a dot) or checklists where you can place a tick in a box.