Show:
1st Category
2nd Category
3rd Category
4th Category
5th Category
100
How is the Join Properties dialog box easily accessed in Query Design View? A. Select Properties from the Quick Access Toolbar B.Select Join Properties from the Query Tools Layout Ribbon C.Double-click the Join Line D. Right-click the Join Line and selecting Join Properties from the Shortcut Menu.
D. Right-click the Join Line and selecting Join Properties from the Shortcut Menu.
100
What type of query enables a user to add the results of a query to an existing table in a database? A. Simply Query B. Duplicates Query C. Unmatched Query D. Crosstab Query
A. Simply Query
100
Which property on a Query properties Sheet must be modified to eliminate duplicates in a Query? A. Identical B.Duplicate C.Replication D.Unique Values
D. Unique Values
100
What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a Query called? A. Replacements B. Common denominators C. Substitutes D. Wildcards
D. Wildcards
100
What object may be used in a Simple Query? A.Table B. Macro C.Form D. Report
A. Table
200
What must be done to ensure that a Query result appears in a specific order? A. Placing B. Filtering C.Ordering D.Sorting
D. Sorting
200
Which checkbox in the Query Design View is used to include a particular field in a criterion while not displaying the field in the Query Results? A.Display B.Include C.Show D.Present
C. Show
200
Which view allows a user to specify fields, criteria, sorting, and calculations when creating a Query? A. File B. Datasheet C. Design D.Backstage
C. Design
200
What is used to remove at once all records that meet specific criteria? A. Append Query B. Delete Query C.Action Query D. Update Query
B. Delete Query
200
What type of query enables the user to add the results of a query to a new table in a database? A. Append B.Make-table C.Action D.Update
B. Make-Table
300
Which type of operator enables a user to equate two values in a Query criterion? A. Evaluation B.Assessment C. Appraisal D. Comparison
D. Comparison
300
Which dialog box accessed through Query Design View is used to manually enter an expression for a field? A.Build B.Create C.Properties D.Zoom
D. Zoom
300
What are questions asked of a database in which the answers are given through the data in the database called? A.Criteria B.Reports C.Benchmarks D.Queries
D. Queries
300
In a Query, what condition must the records that are included satisfy? A.Benchmark B.Measure C.Criterion D.Principle
C.Criterion
300
Which Query type is flexible and prompts the user for input whenever it is used? A.Make-Table B.Update C.Top-Values D.Parameter
D.Parameter
400
What type of query enables a user to add the results of a query to an existing table in a database? A.Make-Table B.Update C.Action D.Append
A.Make-Table
400
What type of query enables a user to make the same change to all records satisfying certain criterion? A.Update B.Action C.Append D.Make-Table
A.Update
400
How is a Query stored after it is created and saved? A.As a database code B.As a database object C.As an image D.As a database macro
B.As a database object
400
Which character is used in a criterion to represent a collection of characters? A.Question Mark (?) B.Ampersand (@) C.Exclamation point (!) D.Asterisk (*)
D.Asterisk (*)
400
Which character is used in a criterion to represent an individual character? A.Question Mark ? B.Exclamation point ! C.Asterisk* D.Ampersand @
A.Question Mark ?
500
What type of query calculates a statistic for data that is grouped by two different types of information? A.Action B.Parameter C.Update D.Crosstab
D.Crosstab
500
Which Query allows a user to quantify the query results by displaying only a specific number of records or a percentage of records? A.Parameter B.Update C.Top-Values D.Make-Table
C.Top-Values