GO! Access 2016 Chapter 2
Which of the following is an INCORRECT wildcard placement? **housing market** housing*market *housing market *housing market*
**housing market**
All of the following are comparison operators EXCEPT ________. < = / >
/
If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________. <= 500 >= 500 =< 500 => 500
>= 500
When multiple criteria must ALL be matched in the query results, a user should use the ________ condition. OR IS NOT NULL AND IF
AND
When a user saves a new database with the default .accdb extension, any user can open the file EXCEPT user who has ________. Access 2016 Access 2013 Access 2002 Access 2007
access 2002
When using a wildcard in a query criteria, a user should substitute a(n) ________ for the missing unknown character(s). ampersands (&) asterisks (*) pound signs (#) quotation marks (")
asterisks (*)
When creating a calculated field, the new field name must be followed by a colon and each field name that will be used in the expression must be enclosed within in its own pair of ________. pound signs (#) brackets ([]) quotation marks (") asterisks (*)
brackets
________ are the conditions that users can set in a query to identify the specific records they want to return. Search Sort Selection Criteria
criteria
To establish table relationships, a user needs to click on Relationships from the Relationship Group on the ________ tab. Database Tools External Data Create Home
database tools
When creating relationships, the 1 and ∞ symbol indicate that ________. Enforce Referential Integrity is unchecked Enforce Referential Integrity is checked Cascade Update Related Fields is unchecked Cascade Update Related Fields is checked
enforce referential integrity is checked
A user will need to double-click on the field from field list one and then double-click on the field from field list two to establish a relationship between the two tables. Group of answer choices True False
false
Query criteria is case sensitive and must match exactly to return the desired results. True False
false
Users can perform mathematical calculations on number even if they are stored as short text data type. True False
false
Users can rename a query as long as it is active and open. True False
false
Users must create a queries from scratch. True False
false
When a user is creating a relationship between two fields within two tables, both fields must have the same name. True False
false
When a user is entering input for a parameter query, the text they input is case sensitive. True False
false
When a user saves a new query, the results of the query are saved in the database for future reference. True False
false
When creating a calculated field, all values in the expression must come from an existing table field. True False
false
Wildcards can be applied to all data types in the query criteria. True False
false
Fields in the Query Design Grid include all of the following EXCEPT ________. fields to be displayed in query results fields that are listed as Primary Keys fields to be searched on in the query results fields to be sorted on in query results
fields that are listed as primary keys
To establish table relationships, a user will link the primary key of one table to the ________ key of the connected table. linked foreign destination source
foreign
A user can add ________ to the criteria for a field in the Query Design Grid to return results where there is nothing in that field. Is Empty Is Null Is Not Null Is Not Empty
is null
To edit an existing relationship, a user will need to right-click on the ________ line. join connection destination link
join
The most common type of relationship in Access is ________. many-to-many one-to-one many-to-one one-to-many
one-to-many
When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field. Parent Innermost Child Outermost
outermost
A ________ query prompts a user for criteria before running the query. parameter user input select crosstab
parameter
When using the Between comparison operator, Access will add ________ around the date fields to search correctly. asterisks (*) quotation marks (") ampersands (&) pound signs (#)
pound signs (#)
It is not common for a user to need to see all data in all tables which is why creating a ________ allowing a user to get a subset of data is so beneficial. search query grouping find
query
The Query window is broken into two parts, the table area and the ________. query design grid field list area properties grid query list area
query design grid
Access will place ________ around a text string within a query criteria that will limit the results to their exact specifications. quotation marks (") asterisks (*) ampersands (&) dollar signs ($)
quotation marks (")
To connect two or more tables that have common fields, a user will need to establish and define the table ________. links bookmarks connections relationships
relationships
To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename. right-click double-click triple-click single-click
right-click
To get the results of a Select Query, the user needs to click ________ from the Results Group in the Design Tab. Search Execute Run Start
run
There are times that users need to use a field as part of their select, but do not want to display it on their query results. They can accomplish this by unchecking the ________ box on the Query Design Grid for that field. show criteria hide display
show
It is helpful to look at the ________ row in the Query Design Grid in case a field may have the same name in multiple locations with different data in each. Field Table Criteria Show
table
A user can change the sort order of a query from the Datasheet View. True False
true
A user can sort on more than field within a table. True False
true
Aggregate functions should be added to the Total row in the Query Design Grid. True False
true
It is common that a database may have several tables where a user will need to establish relationships. True False
true
None of the features added to Access since that earlier version will be available in a database saved with backward compatibility. True False
true
The Save As technique should only be used when a user needs to keep a copy of the original database file. True False
true
To create a crosstab query using fields from more than one table, the user must create a select query with the fields from both tables and then use the query as the data source for the crosstab query. True False
true
To create a many-to-many relationship, a user must create a third table that contains the primary keys of both tables. True False
true
To create a multiple table query, there must be a relationship established between the tables. True False
true
Typically, tables are not stored with the data sorted, but instead use queries to sort the data used within forms and reports. True False
true
Users can Save queries and their associated criteria to be run on-demand in the future. True False
true
Users can combine Grouped By and Aggregate functions in the same query. True False
true
Users can print and save the relationship report to reference outside of the application. True False
true
Users can set the sort order from within the Query Design Grid. True False
true
Users have the ability to move the order of columns within a query. True False
true
When a user is creating a relationship between two fields within two tables, one of the fields is typically the primary key for that table. True False
true
When users are importing data from an Excel spreadsheet into a new table, they have the option to set their own primary key if there is a field in the source file that is unique for each record. True False
true
When using the Between comparison operator for dates, both of the dates are included in the query results. True False
true
A user can set the security and privacy settings on what is displayed in the Message Bar from the ________ within the options menu. Trust Center General Client Settings Add-ins
trust center
