Database Review

Multiple Choice

What is a database?

• A collection of organised information on a particular topic or theme.

• A collection of random information.

• A collection of information on several different topics.

• Information on a single person or thing.

Multiple Select

Which of the following are examples of modern databases (choose more than 1)?

• Email addresses

• Netflix

• Amazon

• The contact list on your phone.

• A car

Match

Match the following

• A file...

• A record...

• A field...

...contains many records.

...contains many fields.

...contains one piece of information.

• ...contains many records.

• ...contains many fields.

• ...contains one piece of information.

Categorize

Options (11)

First name

Surname

Address

Phone number

No. of Orders

Customer Number

Postcode

Date of Birth

Last Login Date

Account Creation Date

Pro Member?

Organize the fields for a customer database below into the correct data types.

Text

Number

Date

Yes/No

Fill in the Blank

In MS Access, the ______ view is used to design your database. You enter the field names and datatypes here.

Fill in the Blank

The ____ _____ view is where you can enter data into your database, creating records.

Reorder

Put these in the order of what you would click on to save a database as a PDF.

• File

• Print

• Print Preview

• PDF or XPS

• Publish

1

2

3

4

5

• 1
• 2
• 3
• 4
• 5

Multiple Choice

What is a database query?

• A database query is a tool to design a database.

• A database query is a method to format data in a database.
• A database query is a request for data or information from a database.
• A database query is a way to delete data from a database.

Multiple Choice

What records will be returned by this database query?

• All records from the Customer table where the customer's car is Red, the Reg Number, Price, Engine Size and Make will be shown.

• All records from the Cars table where the car is Red, the Reg Number, Price, Engine Size and Make will be shown.

• All records from the Cars table where the Price of the car is £150,000, the Reg Number, Price, Engine Size and Make will be shown.

• All records from the Cars table where the colour of the car is Red. Only the Registration number and Price of the car will be shown.

Multiple Choice

Which design below would show the Forename, Surname and Salary for all Employees in Sales?

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Branch

  Criteria: "London"

• Table: Employees

  Fields Shown: Surname, Position

  Searched Field: Position

  Criteria: "Sales"

• Table: Customers

  Fields Shown: Forename, Surname, Salary

  Searched Field: Position

  Criteria: "Sales"

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Position

  Criteria: "Sales"

Multiple Choice

You can also use "Between ___ and ___" as Criteria, this will show all of the records contain numbers or dates between two values. Which design below would display the full names and salaries of all people hired between 01/01/2010 and 01/01/2014.

• Table: Employees

  Fields Shown: Forename, Surname

  Searched Field: Date of Birth

  Criteria: Between 01/01/2010 and 01/01/2014

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Hiring Date

  Criteria: Between 01/01/2020 and 01/01/2024

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Hiring Date

  Criteria: Between 01/01/2010 and 01/01/2014

• Table: Employees

  Fields Shown: Forename, Surname

  Searched Field: Hiring Date

  Criteria: Between 01/01/2010 and 01/01/2014

Multiple Choice

You can also use maths symbols in your criteria, like > (greater than) and < (less than). Which design below will show the forename, surname and salary of all of the employees who earn more than £30,000.

• Table: Employees

  Fields Shown: Forename, Surname

  Searched Field: Salary

  Criteria: >30000

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Salary

  Criteria: >30000

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Salary

  Criteria: <30000

• Table: Employees

  Fields Shown: Forename, Surname, Salary

  Searched Field: Surname

  Criteria: <30000

Well done!

You completed the quiz, now you can log into https://hourofcode.com/uk/learn and try some of the activities.