ICT

Which one of the following makes specific data available for database users?

A database administrator

how is a database organised?

A database contains fields and records stored in tables

Which one of the following plan and build professional databases?

A database specialist.

What is created by matching a unique field in a table with a field in another table?

A relationship

what is a database?

A structured collection of records or data

what is important when designing a database?

A table should contain data related to a single subject type

Why is it important to maintain the integrity of relationships between tables?

Because it prevents related data from being changed or deleted

Which of the following describes the main use for a report?

Compile information for printing.

Which could happen if a data type is changed in an existing table?

Data could be lost.

What is the difference between data and information?

Data is raw facts while information is data processed in some way.

Which of the following is important when creating fields in a database?

Each field in a table should contain only one type of data.

What should be used to display and maintain records in a table?

Forms

Which of the following is an appropriate data type for a field containing decimal values?

Number

In the Bookings table navigate to the last record and select it.

Open the table in Datasheet View. Scroll down to the last record using the vertical scroll bar. Click on the record selector for the last record.

What is the main purpose of relating data between tables in a database?

To minimise duplication of data.

Who builds database tables?

a database administrator

What should be used to display and maintain records in a table?

a report

What could be used to sort and find records faster?

an index

Which is a common use for large-scale databases?

bank account records

Who is responsible for recovery of data after a crash?

database administrator

Which of the following carries out data maintenance and information retrieval in a database?

database users

What property is used to automatically enter a specific field value for new records?

default value

What is used when there is a need to uniquely identify each record in a table?

primary key

What is query used for in a database?

to extract and analyse data