Compare the capabilities of queries and filters.
What will be an ideal response?
1. Queries are saved as objects in the database. Filters are not.
2. Both can be used to select a subset of records in a database.
3. Only queries are used to select a subset of fields in a database.
4. The resulting datasheet from both filters and queries can be used to enter and edit data.
5. The resulting datasheet from both filters and queries can be used to sort, filter, and find data.
6. Queries but not filters are commonly used as the source of data for a form or report.
7. Queries but not filters can be used to create calculations across records.
8. Queries but not filters can be used to create calculated fields.
You might also like to view...
Suppose that ch1 and ch2 are char variables and the input is:WXYZWhat is the value of ch2 after the following statements execute?cin.get(ch1);cin.putback(ch1);cin >> ch2;
A. W B. X C. Y D. Z
A corporate datacenter operates in a humid area near an ocean and often has hardware failures. Which of the following controls would help prevent these issues?
A. Fire suppression B. HVAC C. RAID D. Cold aisles
An administrator notes that after a recent power outage, some open files were corrupted on one affected file server. Which of the following items should the administrator consider to determine the cause of this corruption?
A. The servers memory B. The servers RAID controller battery C. The servers processor D. The servers NIC teaming configuration
When configuring a network card that was not automatically detected, the Configuration Name field represents ____.
A. the network device type B. the interface's device number C. the type of module of the network card D. the name you want to use to refer to the network card