Computer & IT

note!Answer: B) Selecting the database object and clicking the design button on the database window
Selecting an object in the Database window and clicking the Design button opens it in Design view.

note!Answer: D) A cross tab query
Cross tab queries summarize data in a grid with row and column headings, such as regions and months.

note!Answer: A) Table
Tables store the data, so they must exist before forms, reports, or queries that work on that data.

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.