Checkpoint 5 - Reports, Testing and Synoptic Review

Vocabulary flashcards covering database reports, macro actions, testing types, usability testing, synoptic database design rules, and build order from Checkpoint 5.

Report

A structured, formatted database output designed for viewing or printing.

Grouping in reports

Puts related records together into sections.

Sorting in reports

Controls the order records appear within a report/group.

Report totals

Calculations such as Count or Sum can be placed in group/report footers.

Macro

A sequence of Access actions used to automate tasks.

OpenForm

A macro action that opens a specified form.

OpenReport

A macro action that opens a specified report.

Normal test data

Typical valid data that should be accepted and processed correctly.

Erroneous test data

Invalid data that should be rejected or handled.

Extreme test data

Valid data at or near an allowed boundary.

Referential-integrity test

Attempts to create an invalid relationship to confirm it is prevented.

Usability testing

A real user attempts realistic tasks so the interface can be evaluated.

Refinement

An improvement made because testing/review identified a weakness.

Retesting

Testing again after a change to confirm the issue is fixed and no new problem was introduced.

Synoptic: M:M

A many-to-many relationship requires a junction/transaction table.

Synoptic: primary key

Use a unique, stable identifier for each record.

Synoptic: money data

Use Currency for monetary values.

Synoptic: non-negative validation

A rule such as $\ge 0$ prevents negative values.

Synoptic: forms vs reports

Forms are for interaction/data entry; reports are formatted outputs.

Build order

Build on a sound data model before creating dependent interface/output objects.