In this section, you will create a two-table query and produce output from related fields, and a calculated query. You will discover more about the construction of queries to analyze data in this chapter and will cover the creation of an Update, Make Table, and Append query; create a Crosstab query using the wizard; have fun with the Parameter query; and learn how relationships affect a query result.
Constructing advanced queries
Creating a two-table query in Design View
When we create a two-table query within Access, we need to ensure that a relationship exists between the two tables prior to creating the query. This is an important rule as the results will neither query nor produce the correct output if the tables are not...
