Learning how to build/record expressions through correct syntax can help control numerous operators in a query. Using the Form/Subform Wizard in Access can help ensure the creation of proper relationships.

Understanding how subforms and relationships work opens the door to form design Queries can handle multiple types of criteria to help isolate data

syntax — set of rules by which the words and symbols in an expression are correctly combined. subform — form that is inserted into another form (the main form). control source — area in the property sheet that controls which data is displayed in a particular field, as well as any updates you make to the field. data validation — process of ensuring that data is entered correctly into a form by specifying a validation rule for the control in the form.

Be able to use report tools to build a custom report in both Layout View and Design View; use report tools to group and sort in a report, filter records, and add totals and subtotals to a report; use report tools to change the appearance of a report by adding fields with time and date, formatting text, adding page numbers to a report, and adding logos….