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...
By saving a presentation as a PowerPoint show, you bypass the PowerPoint interface and can open the presentation directly in Slide Show view
Indicate whether the statement is true or false
What option is used to access all hard disk drive files?
A) Computer or This PC B) Device Manager C) Clock D) File