Access 2013 Lesson 12 Vocab Question Preview (ID: 37895)
Access 2013 Lesson 12 Vocab.
TEACHERS: click here for quick copy question ID numbers.
Changes the data in its data source or creates a new table.
a) action query
b) aggregate function
c) append query
d) calculated function
Performs a calculation on a set of values and then returns a single value.
a) action query
b) aggregate function
c) append query
d) calculated field
An action query that adds the records in a query’s result set to the end of an existing table.
a) action query
b) aggregate function
c) append query
d) calculated field
A column in a query that results from an expression.
a) action query
b) aggregate function
c) append query
d) calculated field
A join in which each row from one table is combined with each row from another table.
a) cross join
b) crosstab query
c) delete query
d) inner join
A query that calculates a sum, average, count, or other type of total on records and then groups the results by two types of information: one down the left side of the datasheet and the other across the top.
a) cross join
b) crosstab query
c) delete query
d) inner join
An action query that removes rows matching the criteria that you specify from one or more tables.
a) cross join
b) crosstab query
c) delete query
d) inner join
Most common type of join; includes rows in the query only when the joined field matches records in both tables.
a) delete query
b) inner join
c) join
d) left outer join
A relationship between identical fields in different tables.
a) inner join
b) join
c) left outer join
d) delete query
A join that includes all of the rows from the first table in the query and only those records from the second table that match the join field in the first table.
a) join
b) left outer join
c) make table query
d) cross join
An action query that creates a new table and then creates records in it by copying records from an existing table.
a) outer join
b) make table query
c) right outer join
d) left outer join
A join that includes all of the rows from one table and only those rows from the other table that match the join field in the first table.
a) outer join
b) right outer join
c) left outer join
d) join
A join that includes all of the rows from the second table in the query and only those records from the first table that match the join field in the second table.
a) outer join
b) join
c) left outer join
d) right outer join
An SQL command that instructs the Microsoft Access database engine to return information from the database as a set of records.
a) right outer join
b) select statement
c) subquery
d) unequal join
An SQL SELECT statement that is inside another select or action query.
a) right outer join
b) make table query
c) subquery
d) unequal join
A join that is not based on the equivalence of the joined fields.
a) unequal join
b) right outer join
c) subquery
d) outer join
An action query that changes a set of records according to specified criteria.
a) unequal join
b) outer join
c) join
d) update query
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37895 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37895 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register