IGCSE ICT Database Revision M

A collection of field in a database is:

• Row

• Record

• Data

• None of the above

The name of the a field that identifies each record in a relational database.

• Foreign Key

• Primary Key

• Keyless

• None of the above

Datatype to use for an "AMOUNT" field.

• Numeric

• Boolean

• Currency

• Alphanumeric

Datatype to use for "Are you present?"

• Numeric

• Boolean

• Currency

• Alphanumeric

A database with only one table is:

• Database Management System

• Flat file database

• Spreadsheet

• None of the above

Tick all the views in Microsoft Access database.

• Datasheet view

• Design view

• Form view

• Teleview

It is a method of retrieving data from several tables and come up with a new table of the extracted fields.

• Query

• Table

• Report

• Forms

In Microsoft Access, It is to present data from the database

• Form

• Query

• Report

• Table

In Microsoft Access, it is made up of collection of data in rows and columns.

• Form

• Query

• Report

• Table

In Microsoft Access, you can use ______ to add, modify, or delete data from the database in a attractive way.

• Forms

• Query

• Report

• Table