Microsoft Access Select Queries: Editing Results and More

Test your Microsoft Access query knowledge with five beginner-friendly questions about select queries. Explore what select queries do, how to filter records without displaying sensitive values, and how sort order works in the query design grid. You'll also learn an important real-world reminder: editing an editable value in a select query changes the underlying table record, not just a temporary result. That can be convenient, but it also means you are working with live data. The quiz also covers refreshing an open query when another user changes data. A quick refresh, or closing and reopening the query, can bring newly matching records into view.