Written
Database theory for the written test
Connect tables, keys, relationships, queries, forms and reports as one data flow.
Start with table design
Data types, primary keys and indexes define how records are stored and found.
Separate relationship type from integrity
Draw one-to-one, one-to-many and many-to-many examples, then test how referential integrity affects edits.
60 items · 60 min90 minutesFloors + average
Design the query result
Compare select, parameter, crosstab and action queries by purpose. Predict results from small sample tables.
Separate forms from reports
Forms focus on entry and navigation; reports focus on grouping, ordering and output.