G9/10 Support and Revision

A database is an

• interesting collection of facts

• a computer-based data storage technology

• organised collection of data

• a large disorganised bucket of data

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

How many fields will appear in this query results?

• ONE

• TWO

• THREE

• ZERO

What symbol means GREATER THAN or EQUALS to?

• <=

• >=

• >

• <

The process of checking data as it is input to ensure that it is reasonable is known as...

• DATA VERIFICATION

• DATA VALIDATION

• CONDITIONAL FORMATTING

• NONE OF THESE

What do we use to ensure that at least one aspect of a Record is unique?

• Datatypes

• Primary Key

• Field Names

• Reports

• Query criteria

• Wildcards

• Datatypes

• Field names

Which component stores data being accessed by the CPU?

• Motherboard
• Power supply
• Hard drive
• RAM

Which input device should you use to transfer audio (sounds, music) to a computer as digital files?

• Digital camera
• Microphone
• Mouse
• Scanner