Database Fundamentals

What software should we use to create a database?
Select the best answer.

• Excel
• Access
• OneNote
• Word

Which of the following can you do with a database?

• Search
• Sort
• Do calculations
• All of these

A ________ in a database is used to hold a single item of data, such as "pupilName".

• Table
• Record
• Cell
• Field

A row of fields in a database is known as:

• A column
• A cell reference
• A record
• A table

All of the records in a database create a

• Spreadsheet
• Table
• Column
• None of these

A database contains a field called "PostCode".
Which of these would be the data type used for the field "PostCode"?

• String
• Number
• Text
• Object

To search a database, we create a

• Sort
• Query
• Report
• Table

We want to order the records in a database by pupil names from A-Z.
This is an example of sorting in _______ order.

• Ascending
• Descending

Which query could be used to find all pupils who are at least 13 years old in a pupil database?

• age >13
• age<13
• age>=13
• age<=13

A database is essential to all shopping websites.

• True
• False