Access Chapter 2

Which of the following is an INCORRECT wildcard placement? a) *housing market b) *housing market* c) housing*market d) **housing market**

**housing market**

All of the following are comparison operators EXCEPT ________. a) < b) > c) / d) =

/

If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________. a) >= 500 b) => 500 c) <= 500 d) =< 500

>= 500

When multiple criteria must ALL be matched in the query results, a user should use the ________ condition. a) AND b) OR c) IF d) IS NOT NULL

AND

When a user saves a new database with the default .accdb extension, any user can open the file EXCEPT user who has ________. a) Access 2002 b) Access 2007 c) Access 2013 d) Access 2016

Access 2002

________ are the conditions that users can set in a query to identify the specific records they want to return. a) Selection b) Search c) Criteria d) Sort

Criteria

When creating relationships, the 1 and ∞ symbol indicate that ________. a) Cascade Update Related Fields is unchecked b) Cascade Update Related Fields is checked c) Enforce Referential Integrity is unchecked d) Enforce Referential Integrity is checked

Enforce Referential Integrity is checked

To establish table relationships, a user needs to click on Relationships from the Relationship Group on the ________ tab. a) Home b) Create c) External Data d) Database Tools

External Data

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. a) True b) False

False

Query criteria is case sensitive and must match exactly to return the desired results. a) True b) False

False

Users can perform mathematical calculations on number even if they are stored as short text data type. a) True b) False

False

Users can rename a query as long as it is active and open. a) True b) False

False

Users must create a queries from scratch. a) True b) False

False

When a user is creating a relationship between two fields within two tables, both fields must have the same name. a) True b) False

False

When a user is entering input for a parameter query, the text they input is case sensitive. a) True b) False

False

When a user saves a new query, the results of the query are saved in the database for future reference. a) True b) False

False

When creating a calculated field, all values in the expression must come from an existing table field. a) True b) False

False

Wildcards can be applied to all data types in the query criteria. a) True b) False

False

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. a) Is Empty b) Is Not Empty c) Is Null d) Is Not Null

Is Null

When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field. a) Parent b) Child c) Outermost d) Innermost

Outermost

To get the results of a Select Query, the user needs to click ________ from the Results Group in the Design Tab. a) Start b) Run c) Execute d) Search

Run

________ is the process of arranging data in a specific order based on the value in a field. a) Sorting b) Filtering c) Cascading d) Grouping

Sorting

A user can change the sort order of a query from the Datasheet View. a) True b) False

True

A user can sort on more than field within a table. a) True b) False

True

Aggregate functions should be added to the Total row in the Query Design Grid. a) True b) False

True

It is common that a database may have several tables where a user will need to establish relationships. a) True b) False

True

None of the features added to Access since that earlier version will be available in a database saved with backward compatibility. a) True b) 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. a) True b) False

True

To create a many-to-many relationship, a user must create a third table that contains the primary keys of both tables. a) True b) False

True

Typically, tables are not stored with the data sorted, but instead use queries to sort the data used within forms and reports. a) True b) False

True

Users can Save queries and their associated criteria to be run on-demand in the future. a) True b) False

True

Users can apply the OR condition to a single field. a) True b) False

True

Users can combine Grouped By and Aggregate functions in the same query. a) True b) False

True

Users can print and save the relationship report to reference outside of the application. a) True b) False

True

Users can set the sort order from within the Query Design Grid. a) True b) False

True

Users have the ability to move the order of columns within a query. a) True b) 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. a) True b) 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. a) True b) False

True

When users enter currency values as criteria, they do NOT need to type the dollar sign. a) True b) False

True

When using the Between comparison operator for dates, both of the dates are included in the query results. a) True b) False

True

When using a wildcard in a query criteria, a user should substitute a(n) ________ for the missing unknown character(s). a) quotation marks (") b) asterisks (*) c) pound signs (#) d) ampersands (&)

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 ________. a) quotation marks (") b) asterisks (*) c) brackets ([]) d) pound signs (#)

brackets ([])

To establish table relationships, a user will link the primary key of one table to the ________ key of the connected table. a) linked b) source c) destination d) foreign

foreign

To edit an existing relationship, a user will need to right-click on the ________ line. a) link b) connection join destination

join

The most common type of relationship in Access is ________. a) one-to-one b) many-to-many c) one-to-many d) many-to-one

one-to-many

When using the Between comparison operator, Access will add ________ around the date fields to search correctly. a)quotation marks (") b) asterisks (*) c) pound signs (#) d) ampersands (&)

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. a) query b) search c) find d) grouping

query

The Query window is broken into two parts, the table area and the ________. a) field list area b) properties grid c) query list area d) query design grid

query design grid

To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename. a) single-click b) double-click c) triple-click d) right-click

right-click

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. a) show b) hide c) display d) criteria

show