IGCSE DB Query - Questions

This will test your query searching skills

What do you need to know?

​The different types of ways to search

Task

Using the SoftwareCompanyDB database create the queries on the next few slides and answer the questions that follow.

Include all name fields and position in every query.

​qry 1

Use Qry1: find all the female programmers in the company.  Include the gender field but do not show the gender field in the final results.

Fill in the Blanks

qry1

How many results do you get?

Fill in the Blanks

qry1

What is Samantha's surname?

​qry 2

Create a query that finds all the employees that earn £20,000 or less. 

Fill in the Blanks

qry2

How many results do you get?

Multiple Choice

qry2

Who earns the least?

• Zac Ashcroft

• Mia Hamm

• Billy McCann

• Rajan Uppal

• Viveta De Veer

​qry 3

Create a query that finds all employees who have a position of either a web designer OR programmer and work part time.

Fill in the Blanks

qry3

How many results do you get?

Multiple Choice

qry3

Are there more Programmers or Web Designers?

• Programmers

• Web Designers

​qry 4

Create a query that finds all employees that hold a driving licence, works part time, and are male. 

Fill in the Blanks

qry4

All employees are web designers, however one employee is not. What is their job role?

​qry 5

Create a query that includes all employees but not programmers.  Include the salary field. 

Sort this query ascending (A-Z) by position. 

Fill in the Blanks

qry5

How many results do you get?

Fill in the Blanks

qry5

What job position is first?

​qry 6

Create a query that finds all employees who have the word clerk in their position. 

Fill in the Blanks

qry6

How many results do you get?

Fill in the Blanks

qry6

What criteria did you use?

Multiple Select

qry6

What are the three types of clerks?

• HR clerk

• Admin clerk

• Finance clerk

• Clerk to the directors

• Assistant office clerk

​qry 7

Create a query that:

1. Shows only the employees who are entitled to overtime

2. Includes the fields: Surname, Forename, Position, Salary, and Entitled to overtime, and OT hours.

3. Has a new field called OT Pay that calculates the amount they have earnt based on the number of hours overtime they have done multiplied by £15 an hour.

4. Format the new calculated field as £ Look at property sheet – right side

Fill in the Blanks

qry7

How many results do you get?

Fill in the Blanks

qry7

What calculation did you use?

Multiple Choice

qry7

Who earns the most money for overtime?

• Karwad Mustafa

• Mia Hamm

• Nanas Amor

• Max Smith

• Viveta De Veer

​qry 8

Create a query that:

1. Only shows the employees who are full time

2. Includes the fields: Surname, Forename, Position, Salary, and Full or part time.

3. Create a new field called Bonus that calculates the total amount they have earnt based on their Salary plus £500.

4. Format the new calculated field as £

5. Sort this query into descending order by Bonus.

Fill in the Blanks

qry8

How many results do you get?

Fill in the Blanks

qry8

What calculation did you use?

Multiple Choice

qry8

Who is first in the results?

• Jacob Jones

• Raol Kolev

• Sam Caine

• Max Smith

• Daniel Williams

Well done

You have completed all the queries and now must make a report.