Multiple Table Queries and Modifying Queries
Quiz
•
Computers
•
10th Grade
•
Hard
Wayne Wedge
Used 2+ times
FREE Resource
Enhance your content in a minute
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why was a right-to-left join chosen in the example?
To exclude orders not connected to a customer
Because it's the default join type in Access
To pull in records from the orders table first
To include all customer records regardless of orders
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens when a left-to-right join is used?
It prioritizes the orders table over the customers table
It only includes orders that have been fulfilled
It includes customer records not connected with an order
It retrieves orders not connected to a customer
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is necessary when using search criteria in queries?
A specific syntax including quotation marks and parentheses
Only numerical values can be used
Search criteria must be written in a foreign language
No special syntax is required
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How are orders and customers connected in the database?
Through a random assignment
Every order is connected with a customer
Customers are only connected to their first order
Orders are standalone and not connected to customers
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the 'like' syntax do in search criteria?
Looks for numeric values only
Searches for terms at the beginning or end of a field
Excludes certain records
Finds exact matches
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What character is known as a wild-card character in search criteria?
*
#
&
%
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you exclude several different things in your search criteria?
By using the greater than symbol
Using the 'like' syntax
By using 'not in' and separating them with commas
By listing them in quotation marks
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Network topologies
Quiz
•
8th Grade - University
20 questions
Quiz 4
Quiz
•
1st - 10th Grade
20 questions
Basic of Computer and Network
Quiz
•
8th Grade - University
20 questions
Unit 2 Lesson 3 Designing the Interface
Quiz
•
10th Grade
20 questions
Summative Exam
Quiz
•
9th - 12th Grade
20 questions
Software
Quiz
•
10th - 11th Grade
20 questions
Application and System Software
Quiz
•
5th - 12th Grade
20 questions
UNIT 1.3 STORAGE
Quiz
•
10th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
