Practice questions · Public Library

Try answering the question yourself before revealing the answer.

Exam-style questions from the same notes. Reveal the library answer when ready.

Calculated Fields

Computer Science · Class 12

Short text, long text, number, date/time, currency, auto-number, yes/no, and attachment types suit different data.

Update, append, delete, and make-table queries modify data and require preview, validation, and backup.

A new row must satisfy required fields, data types, key uniqueness, validation, and relationship rules.

Expressions in controls produce row calculations, group totals, grand totals, dates, and page numbers.

Widths, hidden columns, frozen fields, and display formats improve viewing without changing underlying values.

A selection control can show meaningful text while storing a related key, reducing typing errors.