IGCSE ICT DATA MANIPULATION QUIZ_practice

A database is an

• interesting collection of facts

• a computer-based data storage technology

• organised collection of data

• a large disorganised bucket of data

To search a database

• Report

• Query

• Label

• Table

A foreign key is a normal field in one table which is used as a .................... in another table

When would MS Access be used instead of MS Excel?

• When using one large worksheet with mostly numeric data

• Creating complex graphs or charts

• Creating essays with included data

• For multiple tables, lots of data & using external databases

What table has been used in the design of this query?

• Query1

• Shapes

• Access

• ID

How many fields will appear in this query results?

• ONE

• TWO

• THREE

• ZERO

There are 30 records in the database. How many will be found with this query?

• 30

• 0

• ERROR

• 20

What query type is shown below?

• AND

• OR

• EQUALS

• NOT

What query would get you the same results as the one below?

• NOT White

• EQUALS White

• Black AND White

• Black OR White

What symbol means GREATER THAN or EQUALS to?

• <=

• >=

• >

• <