access lesson 13

Question 1

parameter query

Answer 1

allows you to specify a criterion for the query result at the time that the query is executed

Question 2

multi-table query

Answer 2

could be used to display all of the orders placed by each customer

Question 3

what happens if the tables in a multi-table query are not already defined by a relationship?

Answer 3

drag the foreign key in one table and relate it to the other

Question 4

what happens if there isn’t a direct relationship between tables in a multi-table query?

Answer 4

add a table that can be related to both of the previously added tables to link them

Question 5

aggregate query

Answer 5

used when you wish to calculate summary statistics. used to group query results into categories based on the values for a field and then perform calculations for each category.

Question 6

“group by” option

Answer 6

used when you wish to use the values for that field to categorize the records in the query results

Question 7

“where” option

Answer 7

used to add criteria for that field

Question 8

“sum” option

Answer 8

sum of results

Question 9

adding a calculated field

Answer 9

1. provide Access a name

2. define the calculation to be performed

Question 10

how do you use another field as part of the calculation?

Answer 10

”[ ]”

Question 11

what do crosstab queries in Access resemble?

Answer 11

PivotTables in Excel

Question 12

crosstab queries

Answer 12

used to create a multi-dimensional view of our data

Question 13

the Crosstab

Answer 13

contains at least two group by fields (one used for column labels, one used for row labels)
used for summary calculations