Getting the tables and relationships set up correctly is critical when designing a database. Table properties, including field formatting, input masks, validation rules, and importing data will be discussed in detail.  For the Query portion, you will cover action queries, which perform actions like Delete, Append, Update and Make Table on multiple records, and then use the Query Wizards to create Crosstab, Find Unmatched, and Find Duplicate queries. You will also create calculated query fields, parameter queries, and functions to extract portions of field values within a query. Prerequisite: Intro to Access or equivalent experience. Limit: 10