Exam 4: Organizing and Manipulating the Data in Databases

If you wish to create a select query with alternate criteria using Microsoft Access ,you should specify them on separate Criteria lines of the query.

Using Microsoft Access to create a select query with

Sorting records are unlike indexing records in that:

One purpose of a data manipulation language is to:

It is not necessary for data to be "clean" or accurate if they are stored in a data warehouse.

Which of these is true about finding data in multimedia databases?

OLAP is notable for its "drill-down capability."

A database subschema is a plot that can often be discovered with forensic accounting.

A dynaset is the total set of records in a database table.

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

To perform a range test of the "hours worked" data field for an employee,you should store the term "Between 0 and 40" in which of these properties in Access?

DML stands for "data management logic."

DDL is an acronym for "data definition language."

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

DML stands for:

All of the following are advantages of drop-down boxes in Access except:

Using Microsoft Access,you create a "one-to-many" relationship between "Customers" records and "Customer Orders" records.When you view the Customers records in a datasheet view,Access indicates the presence of these customer order records using this symbol:

At the time that a user starts to input data into a database,an "input mask" for a telephone number in an Access database might look like:

The conventional prefix for the name of a table is "tbl."

Using Microsoft Access to create a select query with