S3 Database

A ___ contains all the information about one person, thing or subject

• File

• Field

• Record

Answer explanation

A record contains all the information about on subject.

For example in the school you have a "permanent record" that displays your successes in different subjects, attendance, merits and demerits, etc.

To order a database you should ___ it.

• Search

• Sort

• Shift

• Look through it

Answer explanation

Sorting a database means to put it in a specific order. For example if you were buying a new computer you might want to sort by the price of the computers to get all the smaller prices first and find something within your budget.

Each category of information is called a ___.

• File

• Record

• Field

Answer explanation

A field is the heading at the top of each column in a database. For example "Name", "Gender", "Age", "Team". that denotes what all of the cells beneath it will be about and what data type they will be.

a ___ is a collection of records.

• Folder

• Table

• Group

• Cluster

Answer explanation

A table is a group of records all about one subject. So a table could be about Pupils in the school and it would contain a record for each pupil.

A ___ is a collection of tables.

• File

• Folder

• Field

• Group

Answer explanation

A file is a collection of tables, think of it as the access FILE that we open to look at our databases. In that file you'll find multiple tables as well as all of your saved queries.

If you wanted to find all the patients in a database named "Smith" you should ___ the database.

• Search

• Sort

• Find

• Look at

Answer explanation

Searching the database allows us to pull out specific records based on some sort of criteria. In this case we were looking for any record tat included the name "Smith" in the name field.

If I wanted to hold an age I would use a ___ data type.

• Age

• Text

• Number

• Date

Answer explanation

An age field would normally use a number field. This is because it contains only numbers and no letters or special cases.

The only exception to this are fields like phone numbers which often start wth a 0. These fields are treated as text so the computer doesn't try and do any maths with them.

If I want to add a pupil to the school, what must I do to the school database?

• Fill in the class fields to include this new pupil.

• Delete the pupil's information from their old school.

• Add a new record with the pupil's information

Which field name should I search on if I want to find all of the Male famous people in the table?

What should my criteria be if I want to find out how many people in the database are older than 18?

Answer explanation

You should mention the field name and whatever the qualifier is. For example we would use the > symbol to say we want a number "greater than"

Age > 18