Access Level 2

Welcome to your Access Level 2 Class Placement Assessment

Name Business Email Phone Number
I understand relational database theory.
I understand data normalization concepts.
I know the difference between primary, foreign, and composite keys.
I can create relationships between tables.
I can alter join properties.
I can create action, parameter, unmatched, and duplicate queries.
I know what a junction table is.
I can create a subquery.
I can use field validation.
I can add a calculated field to a report.