The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.
Name the four types of Action queries.
Insert, Update, Delete, and Make Table.
Name some aggregate expressions.
Sum, Max, Min, Count, and Average.
What database rules do calculated fields help you to enforce?
Calculated fields help you to enforce normalization rules.
Access stores the results of a query in a database (True/False).
False. Access stores all queries as SQL.
Action queries allow you to override referential integrity rules (True/False).
False. When running Action queries, Access enforces all referential integrity rules.
Practice building each type of Action query: Insert, Update, Delete, and Make Table queries. Use parameters to determine the criteria for Action queries.