What is a database query, how is it used, and how does it differ from a filter?
• What is a form, how is it used and formatted, and how does it differ from a table? What is a database report? How is it used? What report components are used to control and enhance the appearance of the report and why? Database Objects I. Query. A query is a database object created by placing filters and selecting multiple criteria (comparison operators) to extract information from one or more tables. The resulting data becomes an object that can be saved, recalled, and used to perform other operations. A. Advantages of a Query 1. A query can be saved and used to perform other operations 2. One table can be associated with multiple queries 3. A query can perform specialized operations, such as performing calculations on field values, and placing the results in a new column or datasheet B. Difference Between a Query and a Filter 1. A filter is a one-time deal. It allows application of a set of selection criteria and/or sorting instructions to the records in a table. It is a quick temp
