Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access 2013 Lesson 12 Vocab
Test Description: Access 2013 lesson 12 vocab
Instructions: Answer all questions to get your test result.
1) Changes the data in its data source or creates a new table.
A
calculated function
B
action query
C
append query
D
aggregate function
2) Performs a calculation on a set of values and then returns a single value.
A
append query
B
aggregate function
C
action query
D
calculated field
3) An action query that adds the records in a query’s result set to the end of an existing table.
A
calculated field
B
append query
C
action query
D
aggregate function
4) A column in a query that results from an expression.
A
append query
B
calculated field
C
aggregate function
D
action query
5) A join in which each row from one table is combined with each row from another table.
A
crosstab query
B
inner join
C
delete query
D
cross join
6) 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
crosstab query
B
delete query
C
inner join
D
cross join
7) An action query that removes rows matching the criteria that you specify from one or more tables.
A
crosstab query
B
delete query
C
cross join
D
inner join
8) Most common type of join; includes rows in the query only when the joined field matches records in both tables.
A
left outer join
B
delete query
C
join
D
inner join
9) A relationship between identical fields in different tables.
A
inner join
B
join
C
delete query
D
left outer join
10) 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
cross join
C
make table query
D
left outer join
11) 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
12) 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
left outer join
C
right outer join
D
join
13) 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
left outer join
C
join
D
right outer join
14) 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
unequal join
C
subquery
D
select statement
15) An SQL SELECT statement that is inside another select or action query.
A
make table query
B
right outer join
C
unequal join
D
subquery
16) A join that is not based on the equivalence of the joined fields.
A
subquery
B
outer join
C
right outer join
D
unequal join
17) An action query that changes a set of records according to specified criteria.
A
unequal join
B
outer join
C
update query
D
join
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?