EDTEC 419 - Access Level 2

This two-day class covers advanced features of tables, queries, forms, and reports. In this Access class, you will learn to use field properties in tables, create junction tables and improve the table structure. You will create advanced queries to locate unmatched or duplicate information and update a database; create a PivotTable and a PivotChart, and make a crosstab query. You will create and use custom forms effectively by restricting data entry, adding Command Buttons, creating sub-forms, creating a mailing label report, and adding sub-reports to existing reports. You will learn how to import and export data, and how to create and attach macros to simplify repetitive tasks such as validating data, automate data entry, and restricting records using a condition.