Free Printable Databases and Queries

Worksheets

Databases and Queries

Total questions: 20

Worksheet time: 24mins

Name

Class

Date

What is a database?

A software package used to store information

Something that has a list

A spreadsheet

A table of data

Who might use a database?

School

Police

Employer

All of the above

Short text, date, long text and number are all examples of what?

Data types

Headings

Fields

Records

A column in a database is better known as a...

Record

Query

Field

Form

A row in a database is better known as

Record

Query

Field

Form

True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database

True

False

A query is used to

Sort the database in alphabetical order

Search the database

Delete records

Create a form

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

>1999

>01/01/1999

<01/01/1999

<1999

The best data type to choose for date of birth would be

Number

Date/Time

Text

Currency

10.

How many records are in this database?

11.

One of the members of the Sports Club has decided to resign. What would the secretary do with the record for that member on the database?

Amend the record

Delete the field

Delete the record

Delete the file

12.

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

Field

File

Table

Record

13.

The Sports Club has had an Open Day and has gained a new member. How will they add their details to the database?

Add another field

Amend a record

Add a new record

Delete a record

14.

A gym has a database with all their members they want to include email addresses in the database, what will they do?

Add a record

Add a field

Edit a record

Delete a field

15.

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' criteria?

<=3

>=3

16.

What is letter "A" showing?

Where to configure the Join properties

Where to Run the query

Where to configure which fields and criteria are used for the Query

17.

A query can get its data from

a. one or more tables.

b. existing queries.

c. a combination of a and b.

d. all of the above.

18.

A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?

Position = "Striker" OR Goals = 20

Position = "Striker" AND Goals = 20

Position = "Striker" or Goals >=20

Position = "Striker" AND Goals >= 20

19.

Wildcard that represents any collection of characters

Asterisk

Question Mark

Query

Equal Sign

20.

A bookshop owner is using the shop's database to help a customer. The customer is looking for a particular author but cannot remember their full name. The customer remembers that the surname of the author starts with the letters "Co". What kind of query could the bookshop owner use to find this information?

Parameter

GroupBy

Wildcard

Selection

Reset

Databases and Queries

Total questions: 20

Worksheet time: 24mins

Similar Resources on Wayground