IGCSE ICT DATA MANIPULATION FLASHCARD_11D

Front

A database is an

Back

organised collection of data

Front

To search a database

Back

Query

Front

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

Back

primary key

Front

When would MS Access be used instead of MS Excel?

Back

For multiple tables, lots of data & using external databases

Front

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

Back

Shapes

Front

How many fields will appear in this query results?

Back

TWO

Front

How many records will be found with the query in a database of 30 records?

Back

30

Front

What query type is shown below? AND, OR, EQUALS, NOT

Back

EQUALS

Front

What query would get you the same results as the one below? Options: NOT White, EQUALS White, Black AND White, Black OR White

Back

EQUALS White

Front

What symbol means GREATER THAN or EQUALS to? Options: <=, >=, >, <

Back

>=