Access Video Quiz B1.9
By Richard Rost
3 days ago
What Happens When You Edit a Select Query Result? What is the purpose of a select query in Microsoft Access? Welcome to another Access Video Quiz. You will be asked five beginner-level questions about queries, including selecting data, filtering fields without displaying them, sort order, editing query results, and refreshing records. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?Keywords Access Video Quiz, Access select query, hide field in query results, query criteria without showing field, query sort priority, query design grid sort order, editable select query, update underlying table from query, refresh query results, F5 refresh query
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one's for beginner-level users.
I got five questions covering Access Queries. You'll have three seconds to answer each question, so use that pause button if you need more time.
Keep track of your scores so we can see how you did at the end.
Are you ready to earn your lunar database badge?
Here we go.
Question one. What is the purpose of a select query in Microsoft Access?
To display selected data from one or more tables, to permanently copy records into a new table, to print a formatted report, or to change every record in a table automatically.
That is, a select query is to display selected data from one or more tables.
Question two. You need to filter customers by credit limit, but you do not want users to see the actual credit limit amounts.
What do you do?
Remove credit limit from the query after entering the criteria, include credit limit in the query, enter the criteria, and clear its Show box, put credit limit only in the table's primary key, convert credit limit to a short text field.
That's going to be option B, include the credit limit in the query, enter the criteria, and then clear its Show box, and it won't show up in the results.
Question three. In a query design grid, you sort last name ascending and first name ascending. Which field must be further to the left to sort by last name first?
First name because Access reads sorts from right to left, either field because Access sorts alphabetically by field name, last name because query sort priority runs from left to right, or the field with the shorter values.
That'll be C, last name, because query sort priority runs left to right.
Question four. What normally happens if you edit an editable value while viewing a select query?
The change affects only the query's temporary results. This creates a new record in the source table. The query becomes permanently read-only. The change is saved to the underlying table record.
That'll be D, the change is saved to the underlying table record.
Remember, folks, you're changing actual live data.
Question five. A query is already open when another user changes a record so that it should now match the query criteria.
You don't see it yet. What should you do?
Rebuild the query in design view. Refresh the query results or close and reopen the query. Save the query under a new name. Add a new primary key to the source table.
That'll be B, refresh the query results or close and reopen the query.
Good old F5.
How'd you do?
Did you get all five right?
Are you the first mayor of Luna City with gravity optional?
Or did you miss the shuttle and just start naming moon rocks?
Well, if you missed any of these, all these topics and more are covered in Microsoft Access Beginner Level 1, Lesson 9, about customer queries.
This is completely free. It's on my YouTube channel and on my website.
Go watch it.
Thanks for playing.
Post your score in the comments down below, and remember, on the moon, even your queries need space.
And until next time, live long and prosper. Intro What is the purpose of a select query in Microsoft Access? Welcome to another Access Video Quiz. You will be asked five beginner-level questions about queries, including selecting data, filtering fields without displaying them, sort order, editing query results, and refreshing records. Answer each question, check your score, and see how well you know Microsoft Access. |
