By the end of this lab students should know how to:

• Import a table.
• Import data from Excel.
• Save import steps.
• Create an input mask.
• Make fields required.
• Create and use action queries.
• Add a calculated field to a query.
• Create a subquery.
• Create a Top-Values query.
• Create a crosstab query.