Lesson 1 Database Basics

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 individual member. The information about each member is called a:

• Field

• File

• Table

• Record

A school needs to store information about each individual student. The information about each student is called a:

• Field

• File

• Table

• Record

A car showroom store information about each car they sell. The individual items of data about each car is called a:

• Field

• File

• Table

• Record

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

• Field
• File
• Record
• Table

A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria?

• >3

• <3

• <=3

• >=3

• 3

An estate agent wants to search for all houses with 2 bedrooms. What will they put in the query in the 'bedrooms' query criteria?

• >2

• <2

• <=2

• >=2

• 2

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

• Report

• Table

• Query

• Sort

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

• Text

• Numeric

• Calculated

• Boolean

What data type would be used to store the following postcode: IM1 4HP

• Text

• Numeric

• Calculated

• Boolean