Question

A database is a structured collection of data, such as an inventory management system or an employee records system.

Question 1 options:
True
False
Question 2 (1.5 points)
A table is a set of fields used to create a record.

Question 2 options:
True
False
Question 3 (1.5 points)
A form is a set of sorting, filtering, and calculation rules that define how the records from one or more tables are displayed to a user.

Question 3 options:
True
False
Question 4 (1.5 points)
The most common query language is the Structured Query Language (SQL).

Question 4 options:
True
False
Question 5 (1.5 points)
A criterion is a condition that must be met for something to happen. The plural of criterion is criteria.

Question 5 options:
True
False
Question 6 (1.5 points)
To enter text criteria, type the text in the Criteria row in the grid in Query Design view in the column for the desired field. Enclose the text in quotation marks.

Question 6 options:
True
False
Question 7 (1.5 points)
To enter numeric criteria, type the number directly into the Criteria row for the desired field's column. Enclose the number in quotation marks.

Question 7 options:
True
False
Question 8 (1.5 points)
To enter a date or time as a criterion, write it in short date format, and enclose it in hash symbols (#), like this: #12/20/2021# or #10:00:00 AM#.

Question 8 options:
True
False
Question 9 (1.5 points)
A comparison operator is a symbol that describes a logical condition such as equal to or greater than.

Question 9 options:
True
False
Question 10 (1.5 points)
There are special operators you can use in criteria such as:

Is Null: Includes the record only if the field is blank.

Question 10 options:
True
False

0 of 10 questio

Answer 1

Here are the answers to your questions:

**Question 1:** True
A database is indeed a structured collection of data.

**Question 2:** False
A table is a set of records, not fields. A record is made up of fields.

**Question 3:** False
A form is typically used for data entry and display, while sorting, filtering, and calculation rules describe queries.

**Question 4:** True
SQL (Structured Query Language) is the most common query language used for interacting with relational databases.

**Question 5:** True
The plural of criterion is indeed criteria.

**Question 6:** True
Text criteria can be entered in the Criteria row and must be enclosed in quotation marks.

**Question 7:** False
Numeric criteria should be typed directly in the Criteria row without quotation marks.

**Question 8:** True
Date and time criteria should be written in short date format and enclosed in hash symbols.

**Question 9:** True
A comparison operator describes a logical condition such as equal to or greater than.

**Question 10:** True
The "Is Null" operator includes the record only if the field is blank.

Please feel free to ask if you have any more questions!