IC3 Database Applications

Question 1

In a database, what is a 'record'?

Accepted Answer

A complete set of fields about one entity

Answer

A record is a complete row in a database table that contains all the related fields for a single entity, such as one customer or one product.

Question 2

Which of the following best describes a 'field' in a database table?

Accepted Answer

A single category of information stored in a column

Answer

A field is a single category of information represented by a column in a database table, such as 'Last Name' or 'Phone Number'.

Question 3

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record in the table

Answer

A primary key is a field (or combination of fields) whose value is unique for every record, ensuring each row can be individually identified.

Question 4

In Microsoft Access, which object is used to enter and view data in an easy-to-use layout?

Accepted Answer

Form

Answer

A Form in Access provides a user-friendly interface for entering, editing, and viewing records one at a time.

Question 5

What does a database query do?

Accepted Answer

Retrieves specific data from one or more tables based on set criteria

Answer

A query filters and retrieves records from tables that meet specified criteria, allowing users to view only the data they need.

IC3 - Digital Literacy Certification Practice Test