To filter records only where the 'Days' field is 'TTh', which criteria should be set?

Study for the CGS Access Test. Leverage flashcards and multiple choice questions, each with hints and explanations. Be prepared for your exam and excel!

To filter records specifically for cases where the 'Days' field is set to 'TTh', typing 'TTh' directly in the Criteria row under the Days field is the correct approach. This action instructs the database to display only those records that match that exact value.

Using criteria is fundamental when you want to narrow down the dataset to specific entries based on field values. In this instance, placing 'TTh' in the Criteria row effectively sets a direct filter, making it clear that only records with 'TTh' in the Days field should be presented in the results.

The other options involve concepts that do not serve the purpose of filtering for an exact match in this specific scenario. "Group By" and "Total" relate to summarizing data rather than filtering subsets of a dataset. A custom filter could also be relevant in some contexts, but it typically adds complexity that is unnecessary when a simple criteria entry suffices for matching specific text.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy