Database Applications Flashcards

In a database, what is a 'record'?

Answer: A complete set of fields about one entity

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.

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

Answer: A single category of information stored in a column

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

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

Answer: To uniquely identify each record in the table

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

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

Answer: Form

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

What does a database query do?

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

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

Which data type should be used to store a person's age in a database field?

Answer: Number

Age is a numeric value, so the Number data type is appropriate, allowing mathematical operations like averaging ages.

What is the purpose of a database Report object in Microsoft Access?

Answer: To display and print data in a formatted, organized layout

Reports in Access format database data for printing or sharing, presenting information in a professional, readable layout such as summaries or invoices.