Summary: Creating Advanced Queries in Access
About the Lecture
The lecture Summary: Creating Advanced Queries in Access by Sonic Performance is from the course Creating Advanced Queries in Access 2013. It contains the following chapters:
- Creating Advanced Queries - Summary
Included Quiz Questions
True or False? Periods and exclamation points are permitted in a parameter query prompt as long as they are enclosed in square brackets.
- False
- True
Which of the following make changes to table data? (Choose four.)
- Append query
- Update query
- Delete query
- Make table query
- Select query
Which of the following would you use to find records that have no related records in another table?
- Find unmatched query
- Orphan query
- Widow query
- Delete query
- Find duplicates query
What kind of query displays summary data in a table with one data category labeled across the top (columns) of the table and another data category labeled across the left (rows) of the table?
- Crosstab
- CatMat
- CatMatrix
- SumTab
- CatScan
Author of lecture Summary: Creating Advanced Queries in Access
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
