LO6- software selection

Question 1

What are the main tools to process data?

Answer 1

• spreadsheets

- databases

Question 2

What can a spreadsheet be used to do?

Answer 2

-Store text and numerical data and produce graphs

Question 3

What the tasks can a spreadsheet be used for?

Answer 3

Calculate invoices

Question 4

What are databases used for?

Answer 4

Databases are used to store, edit and process data and text

Question 5

What is a database made up of?

Answer 5

One or more tables that are made up of records.

Question 6

What can a database be used to do?

Answer 6

-Store and process data and text and create queries to search for data

Question 7

Types of validation:

Answer 7

• Length check
• Range check
• Presence check
• Look up value
• Format check
• Input masks

Question 8

Tasks of a database are…

Answer 8

-To send personalized letters by using mail merge and

track stock levels in a shop