Why would you want to build multitable queries?


If you have properly separated data to normalize it (for example, into customers, orders, and order details), you might want to bring the data back together by using queries. To do this, you'd need to use multitable queries.


Why are you able to update query results?


A query result is a dynamic set of records that maintains a link to the original data. When you update a query result, you update the original data.


What are the two ways you can run a query? Explain the difference between them.


You can click the Run button or you can click the Query View button. Whereas the Run button runs any type of query, the Query View button runs only Select queries.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics