To understand normalization, you first must understand ____ dependency, because it will help you analyze fields within tables and decide if they need to be split into smaller tables.

Which of the following is TRUE about text in a table?

A) Text can be oriented vertically in a cell. B) You can only sort text in one column. C) Text in tables can be horizontally aligned but cannot be vertically aligned. D) Text can be sorted in ascending, not descending order.

A query is a database object that:

A) summarizes data in a professional-looking manner. B) retrieves specific data from one or more database tables or queries. C) can select its data from tables, other queries, or reports. D) edits data.