After completing this course, students will know how to:
- Normalize tables, set table relationships, and implement
referential integrity between related tables.
- Create a Lookup list field, modify Lookup field properties,
and use a subdatasheet to add data to related tables.
- Create join queries, create calculated fields in a query, and
use queries to view summarized and grouped data.
- Add unbound controls, graphics, calculated fields, and a combo
box to a form.
- Add headers and footers in a report, use functions to add
calculated values in a report, and embed a subreport in a report.
- Create and modify charts in forms and reports.
- Create a PivotTable, modify a PivotTable, and create a
PivotChart.
|