IC3 Database Applications 1 — Questions and Answers
Question 1: In a database, what is a 'record'?
- A single piece of data in a cell
- A complete set of fields about one entity (Correct answer)
- A category label for a column
- A formula used to calculate values
Correct 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.
Question 2: Which of the following best describes a 'field' in a database table?
- A row containing all data for one item
- A single category of information stored in a column (Correct answer)
- A query used to search for data
- A report generated from the database
Correct 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'.
Question 3: What is the primary purpose of a primary key in a database table?
- To sort records alphabetically
- To link two tables together automatically
- To uniquely identify each record in the table (Correct answer)
- To restrict who can view the table
Correct 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.
Question 4: In Microsoft Access, which object is used to enter and view data in an easy-to-use layout?
- Query
- Report
- Form (Correct answer)
- Module
Correct answer: Form
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?
- Prints formatted data for distribution
- Retrieves specific data from one or more tables based on set criteria (Correct answer)
- Creates a visual layout for data entry
- Backs up the entire database
Correct 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.
Question 6: Which data type should be used to store a person's age in a database field?
- Text
- Number (Correct answer)
- Date/Time
- Hyperlink
Correct answer: Number
Age is a numeric value, so the Number data type is appropriate, allowing mathematical operations like averaging ages.
Question 7: What is the purpose of a database Report object in Microsoft Access?
- To run automated macros on data
- To establish relationships between tables
- To display and print data in a formatted, organized layout (Correct answer)
- To import data from external sources
Correct 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.
IC3 Database Applications 1
In a database, what is a 'record'?