Podcast
Questions and Answers
What is the purpose of joining tables in a query?
What is the purpose of joining tables in a query?
- To create new tables in the database
- To sort the data in a specific order
- To combine data from multiple tables into a single result set (correct)
- To filter the data in each table individually
Which type of join returns only the rows that have matching values in both tables?
Which type of join returns only the rows that have matching values in both tables?
- Left outer join
- Inner join (correct)
- Right outer join
- Full outer join
What happens if you do not join the tables in a query?
What happens if you do not join the tables in a query?
- The query will return only the unique values from each table
- The query will match each record of one table to every record in another table, resulting in spurious rows (correct)
- The query will not run and return an error
- The query will return the data in a specific order
Which type of join returns all rows from the left table, and the matching rows from the right table?
Which type of join returns all rows from the left table, and the matching rows from the right table?
What is the purpose of the Relationship window in Access?
What is the purpose of the Relationship window in Access?
Which of the following is a valid reason for joining tables in a query?
Which of the following is a valid reason for joining tables in a query?
What is the purpose of the CTRL key when selecting tables in the Show Table window?
What is the purpose of the CTRL key when selecting tables in the Show Table window?
What type of relationship is demonstrated between the two tables in the example?
What type of relationship is demonstrated between the two tables in the example?
What is the purpose of clicking the Totals button in the Design tab?
What is the purpose of clicking the Totals button in the Design tab?
What is the purpose of dragging fields to the Columns tab in the Query window?
What is the purpose of dragging fields to the Columns tab in the Query window?
What is the purpose of setting the Group By function on the Category and Item Number columns?
What is the purpose of setting the Group By function on the Category and Item Number columns?
What does the Count function applied to the Sales Order Number column indicate?
What does the Count function applied to the Sales Order Number column indicate?
Which of the following steps is NOT necessary when creating a query to display invoices with their payment details?
Which of the following steps is NOT necessary when creating a query to display invoices with their payment details?
What is the purpose of joining tables in a query?
What is the purpose of joining tables in a query?
Which of the following steps is correct when joining the Sales Order, Invoice, and Payments tables to display all sales orders with their invoices and payment details?
Which of the following steps is correct when joining the Sales Order, Invoice, and Payments tables to display all sales orders with their invoices and payment details?
What is the purpose of the Save button in the query design window?
What is the purpose of the Save button in the query design window?
Which of the following statements is true about selecting columns in a query?
Which of the following statements is true about selecting columns in a query?
What is the purpose of the Run icon in the query design window?
What is the purpose of the Run icon in the query design window?
