Year 8 - Homework - Databases

What is a database?

• A piece of software to do calculations

• A device to load information onto the computer.

• A structured collection of records

• A calculator

A sports club needs to store information about each member. The all the information about each member is called a:

• Field

• File

• Table

• Record

One specific piece of information about a person or thing is called:

• Field
• File
• Record
• Table

A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?

• Report

• Form

• Query

• Sort

What data type would be used to store the following item code: 0024

• Text

• Numeric

• Calculated

• Boolean

The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?

• Ascending order

• Descending order

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

The four main objects of a database consist of:

• form, table, query, report

• filter, table, database, query

• form, data type, record, query

• form, record, field, report

A rule to make sure that only reasonable and sensible data is entered.

• Filter
• Query
• Validation
• Verification

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations