Computer Science

A(n) ________ query enables you to create a new table or change data in an existing table.

Started by xclash

A(n) ________ is an action query that creates a new table by extracting data from one or more tables.

Started by abern

Record in one table that have no matching records in a related table are known as ________.

Started by Zoey63294

The ________ Wizard locates unmatched records and then deletes the records from the table.

Started by mydiamond

A(n) ________ function adds the values in a column.

Started by NguyenJ

The first element of a ________ is the new field name that will display the calculated value.

Started by Awilson837

________ are mathematical symbols used to build expressions in calculated fields.

Started by meagbuch

A(n) ________ is a field that obtains its data by performing a computation.

Started by wenmo

A(n) ________ is a formula that performs a calculation.

Started by sheilaspns

The default type of join is the inner join.

Started by kodithompson

An unequal join is used to combine rows from two data sources based on field values that are not equal.

Started by yoroshambo

A delete query is an action query that removes an existing table in the same database.

Started by asmith134

Unmatched records are records in one table that have no matching records in a related table.

Started by misspop

In Access 2016, it is not possible to have records in one table that have no matching records in a ...

Started by madam-professor

A crosstab query always has at least one row heading, one column heading, and one summary field.

Started by nenivikky

A totals query can be used as a source for another database object.

Started by bobthebuilder

The Total row of a table is a record.

Started by Medesa

The Maximum function can only be used for numbers, decimal, and currency data types.

Started by asmith134

Which type of join will display all of the records on the many side of the relationship?

Started by vicky

A(n) ________ is created unintentionally when a join line is not created between related tables.

Started by newbem

In a(n) ________, each row from one table is combined with each row in a related table.

Started by bobbie

When a query with a(n) ________ is run, only the records where the value in the common field exists ...

Started by plus1

A(n) ________ is an action query that is used to add, change, or delete data in fields of one or ...

Started by lb_gilbert

A(n) ________ is an action query that creates a new table by extracting data from one or more tables.

Started by jhjkgdfhk

When you type the parameter in the Criteria row of a parameter query, make sure that the prompt is ...

Started by ashley