During this course, the student will analyze tables, create a junction table, and improve table structure. Create subqueries, create unmatched and duplicate queries, group and summarize records using criteria, summarize data using a crosstab query, and create a PivotTable and a PivotChart. Create and attach a Macro, restrict records using a condition, validate data using a Macro, and automate data entry using a Macro. Display a calendar on a form, organize information with Tab pages and display a summary of data in a Form. Include a chart in a report, print data in columns, and create a report snapshot. Link tables to external data sources, determine object dependency, document a database and analyze the performance of a database.