Exam (elaborations)
Access Chapter 3 Quiz (1).
Access Chapter 3 Quiz (1).
[Show more]
Content preview
Access Chapter 3 QuizAfter you create a query in Design view, what do you need to do in order to see the
results? - ANS-Run the query
How does Access evaluate a criterion expression that just includes a criteria value? -
ANS-equal to
How many criteria would you need in a query in order to find all the employees who
work as insurance agents in the Cameron Park branch of a company who were hired
after January 1, 2019? - ANS-3
How many fields can you add to the query design grid? - ANS-as many as you like
In the query design grid, what do you delete to delete a field from a query? - ANS-a
column
In what view do query results display? - ANS-Datasheet view
What determines the type of criterion you enter, along with the way you enter the
criterion? - ANS-data type of the field
What is created when values are entered on the same Criteria row of the query design
grid? - ANS-an AND condition
What is the name for hardcoded values entered into a formula? - ANS-constant
What name does Access assign to new queries? - ANS-Query1
What should you use to write criterion into a query? - ANS-expressions
When entering an expression, which of the following tools may suggest a list of possible
values? - ANS-IntelliSense
When structuring a criteria expression with a parameter that includes one or more
wildcards, where can the wildcards be positioned? - ANS-any of the above
Which of the following cannot be changed in Datasheet view of a query? -
ANS-alignment
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller topgradesdr. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77988 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now