Step-by-step explanation:
In the Query window of a database application, you can use the design grid or SQL to filter data based on certain criteria. The main difference between entering criteria involving text fields in the design grid and entering criteria in SQL is the syntax and the level of control over the filtering process.
In the design grid, you can select a text field from the table and then specify the criteria you want to use to filter the data in that field. You can use comparison operators such as "Equals", "Like", "Begins With", "Ends With", and "Contains" to specify the criteria. You can also use wildcards such as the asterisk (*) or the question mark (?) to represent any character or any single character, respectively. The design grid provides a user-friendly interface for specifying criteria and allows you to easily combine multiple criteria using AND and OR operators.
On the other hand, when entering criteria in SQL, you have more control over the filtering process. You can write SQL statements that use various clauses such as SELECT, FROM, WHERE, and ORDER BY to filter data based on one or more text fields. You can use comparison operators such as "=", "<", ">", "<=", ">=", "<>" and logical operators such as AND, OR, and NOT to specify the criteria. You can also use wildcards such as the percent sign (%) to represent any number of characters. Writing SQL statements requires more technical knowledge than using the design grid, but it also allows you to perform more complex filtering tasks.
In summary, the design grid provides a user-friendly interface for specifying criteria involving text fields, whereas entering criteria in SQL gives you more control over the filtering process but requires more technical knowledge.