Part 2 Multiple Table Queries

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