BARU
Ukuran huruf
Lembar kerjaMultiple Table Queries and Modifying Queries
Total soal: 25
Worksheet time: 13mins
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
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
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
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
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
What character is known as a wild-card character in search criteria?
*
#
&
%
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
What symbol is used to look for numbers greater than a certain value?
>
<
=
!
How do you look for numbers that are between two values?
Using the greater than and less than symbols together
By typing the two values in quotation marks
Using the 'between' keyword
There is no way to do this
What can you do by double-clicking the join in a query?
Delete the join
Change the type of join
Add a new table to the query
Nothing, it's not an interactive feature
How can you switch to Design view from Datasheet view?
Go to the View drop-down arrow and select Design view or click the icon on the far right in the bottom-right corner.
Press Ctrl + D on your keyboard.
Double-click on any field name.
Right-click on the tab name and select Design view.
What is the purpose of sorting the results in the query?
To delete unwanted data from the database.
To make the results easier to read by organizing them in a specific order.
To increase the speed of the query execution.
To change the data type of the fields.
How do you perform a multilevel sort in the query?
By adding a sort to multiple fields, which will work from top to bottom.
By selecting all fields and choosing a sort option.
By adding a sort to multiple fields, which will work from left to right.
By writing a special SQL command.
What is the correct order of steps to sort the query results first by zip code and then by city?
It's not possible to sort by zip code first in this system.
Add a multilevel sort by selecting zip code first and then city.
Sort by city first, then drag the zip code column to the left of the city column.
Change the ordering of the columns so zip code is before city, then add a sort to each.
A data field can be hidden by clicking the checkbox on the ___________ row.
Show
Criteria
Field
Table
What is the first step in designing a query that involves more than one table?
Identify the relationships between tables
Decide on the output format
Choose the tables involved
Pinpoint exactly what you want to find out
What is the main reason for sending out coupons to customers in the bakery example?
To increase sales during off-peak hours
To clear out old stock
To entice them to come back to the bakery
To introduce new products
How many tables were used to target customers for receiving coupons in the bakery example?
1
2
3
4
What additional condition, besides living outside the city limits, must customers meet to receive coupons?
They must have a birthday in the current month
They must be part of the bakery's loyalty program
They must have placed an order at the bakery
They must have visited the bakery in the last month
When the join arrow is pointing from left to right, this means the query will look at data in the left table first, then look at only the data in the right table that _______ to the records it's already seen in the left table
relates
copies
speaks
Why does creating a query involving more than one table require more planning?
Because it is more complex and you have to ask questions to find the info you want.
Because it requires more computational resources
Because it can only be done using special software
Because it involves more data to process
In the Video, what is the ultimate question the bakery wants to answer with its query?
Which customers live in our area, are outside the city limits, and have placed an order at our bakery?
Which customers have placed an order at our bakery?
How many customers live outside the city limits?
How many coupons should be sent out?
What is the purpose of pinpointing exactly what you want to find out in the first step of designing a query?
To clarify the question you are trying to answer
To identify which database to use
To determine the complexity of the query
To decide how many tables to include
Why is it important to focus on customers who live relatively close to Raleigh for the bakery's coupon campaign?
Because it's more cost-effective for shipping
To ensure a higher likelihood of customers returning to the bakery
To target a specific demographic
Because the bakery only delivers within a certain radius
The Table Join must be _______ to _______ in order to get the needed results.
Right to Left
Left to Right
Top to Bottom
Bottom to Top
