• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Workshop

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.

Quiz

1:Name the four types of Action queries.
A1: Insert, Update, Delete, and Make Table.
2:Name some aggregate expressions.
A2: Sum, Max, Min, Count, and Average.
3:What database rules do calculated fields help you to enforce?
A3: Calculated fields help you to enforce normalization rules.
4:Access stores the results of a query in a database (True/False).
A4: False. Access stores all queries as SQL.
5:Action queries allow you to override referential integrity rules (True/False).
A5: False. When running Action queries, Access enforces all referential integrity rules.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint