Database System

note!Answer: C) Relational
A relational database stores data in multiple related tables that are linked by common fields to produce combined results.

note!Answer: B) Data Validation
Data validation checks entered data against defined rules or criteria before it is accepted.

note!Answer: D) Data Validation
Data validation rules restrict input so that only correct values are permitted.

note!Answer: A) Sorting
Sorting arranges records in a particular order, such as ascending or descending, based on values.

note!Answer: D) Calculated field
A calculated field is created by entering an expression in the query design grid that uses other field values.

note!Answer: A) Bit - Byte - Field - Record - File - Database
Data hierarchy goes from smallest to largest: bit, byte, field, record, file, database.

note!Answer: C) A report
Reports are designed for formatted, printable output such as invoices that can be mailed.

note!Answer: B) Calculated field
A calculated field in a query displays the result of an expression computed from other fields.

note!Answer: B) Restore
Restore copies a backup from storage media back to the computer.

note!Answer: D) Available Fields
The Form Wizard's Available Fields list shows the fields from the chosen table that can be added to the form.

note!Answer: C) Columnar
A columnar form places each label on the left with its data on the right, one field per row.

note!Answer: C) Datasheet
A Datasheet displays data in a table layout, like a spreadsheet, with field names as column headings.

note!Answer: B) Tabular
A Tabular form shows multiple records, each on its own row, with field labels across the top.

note!Answer: D) Page Up
Tab, Enter and Shift+Tab move between fields, while Page Up moves between records.

note!Answer: B) Tables
Queries are built on tables, and a query can then serve as the record source for forms and reports.

note!Answer: A) Crosstab
A Crosstab query summarizes data in a row-and-column grid, such as totals by category.

note!Answer: D) Datasheet View
The New Query dialog offers Design View, Simple Query Wizard, Crosstab Query Wizard, and Find Duplicates/Unmatched wizards, but not Datasheet View.

note!Answer: C) Simple
The Simple Query Wizard creates a basic select query that retrieves chosen fields from tables.

note!Answer: D) Available Fields
The list of fields you can add is called the Available Fields list; double-clicking a field moves it to Selected Fields.

note!Answer: B) Query datasheet
A query's results appear in a query datasheet, which looks like a table of rows and columns.