Question 1

When you sort text in A to Z order,you are using a(n)________ sorting option.

Accepted Answer

When you sort text in A to Z order, you are arranging the data in ascending order based on the alphabetical order of the first letter in each cell. Therefore, the correct sorting option is ascending, which is represented by the letter D.

Question 2

A complex query designed by combining search criteria and aggregate functions in a single query can make it more difficult to ________ the query if it does not work.

Accepted Answer

When a complex query is designed by combining search criteria and aggregate functions in a single query, it can become difficult to troubleshoot the query if it does not work as intended. Troubleshooting involves identifying and fixing errors in the query, which can be a challenging task when dealing with complex queries.

Question 3

LIKE,IN,and BETWEEN are called ________.

Accepted Answer

LIKE, IN, and BETWEEN are considered special operators in SQL used for pattern matching, checking if a value is within a set, and checking if a value is within a range, respectively.

Question 4

To calculate multiple functions on the same field,you must add the field to the ________ multiple times.

Accepted Answer

To calculate multiple functions on the same field, you must add the field to the grid multiple times, as the grid allows you to specify different calculations for each instance of the field.

Question 5

In Query Design view,you can select up to ________ fields to sort by.

Accepted Answer

In Query Design view, you can select up to 10 fields to sort by in Microsoft Access.

Question 6

One method to increase the width of columns in a query result to best fit the data is to double-click the ________.

Accepted Answer

The correct method to increase the width of columns in a query result to best fit the data is to double-click the column selector bar, which is the boundary area on the right side of the column header.

Question 7

An Access tool that helps you format your calculated fields correctly is called ________.

Accepted Answer

The Expression Builder is a tool within Access that assists users in correctly formatting calculated fields by providing a graphical interface for building expressions. The Formula Builder, Expression Designer, and Calculation Designer are not actual Access tools.

Question 8

If you forget to put ________ around a date,Access will add them for you.

Accepted Answer

In Microsoft Access, when you forget to enclose a date value in any delimiters, Access automatically adds pound signs (#) around the date to properly format it as a date value.

Question 9

Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.

Accepted Answer

The query design grid is where users specify the fields, criteria, and sorting for their queries in Access. Changing field names in the query does not affect the underlying field names in the tables; hence, the original field names must remain consistent in the query design grid for Access to correctly perform calculations.

Question 10

In the expression Total Tax:[Invoice!QtySold]*[Tax!Rate] the exclamation mark is used to indicate that the columns are located on different ________.

Accepted Answer

The exclamation mark is used to separate the table name from the column name in the expression. This suggests that the columns are located in different tables, not in queries, forms, or reports.

Question 11

Rearranging records in a specific order is called ________.

Accepted Answer

Sorting involves arranging records in a specific or desired order based on specific criteria, such as alphabetical, numerical, or chronological order. Categorizing and classifying, on the other hand, involve grouping records based on shared characteristics or attributes, while moving involves physically relocating records from one place to another. Therefore, option A, sorting, is the most accurate choice.

Question 12

When you sort numbers in highest to lowest order,you are using a(n)________ sorting option.

Accepted Answer

When you sort numbers in highest to lowest order, you are arranging them in a decreasing order, which is the purpose of the descending sorting option. The ascending option, on the other hand, sorts numbers from lowest to highest. The sloping and reverse options are not valid sorting options.

Question 13

The ________ operator will return results that include and fall within the criteria you enter.

Accepted Answer

The BETWEEN operator is used to retrieve values within a range, including the endpoints. This would cover the requirements stated in the question.

Question 14

Before opening the Expression Builder to create a(n)________ field,you should save your query first.

Accepted Answer

Before opening the Expression Builder to create a calculated field, it is recommended to save your query first. This is because the calculated field is a new field that you are adding to the query and it involves using expressions that may affect the content of the query. If you save the query beforehand, you can easily undo any changes if needed. Totals, new, and aggregate fields do not require the use of the Expression Builder, and thus do not require you to save the query before creating them.

Question 15

When you sort by multiple fields,the first field you select to sort on is called the ________ sort field.

Accepted Answer

The first field you select to sort on is considered the primary sort field. This is because it is given the highest priority when sorting the data. Any subsequent fields chosen for sorting is considered secondary or tertiary sort fields, and they are used to further refine the sort order established by the primary sort field.

Question 16

A field may be sorted in either ascending order or ________ order.

Accepted Answer

The opposite of ascending is descending, so the correct choice is B: descending. Reverse is not always used to describe sorting, and inclining and sloping are not generally used to describe the order of a field.

Question 17

To format query fields in the query grid,you use the ________ properties sheet.

Accepted Answer

The Field properties sheet allows you to format query fields in the query grid. It provides options for setting field properties such as the format, caption, and width. The Database properties sheet is used to set database properties, the Query properties sheet is used to set query properties, and the Form properties sheet is used to set form properties.

Question 18

The view that allows you to view all records in a table at one time is the design view.

Accepted Answer

The view that allows you to view all records in a table at one time is the datasheet view, not the design view. The design view is used to create and modify the structure of a table, including defining fields and their properties.

Question 19

When you add a total row to a table or a query in datasheet view,you are using a(n)________.

Accepted Answer

The addition of a total row in a table or query in datasheet view is using an aggregate function, which performs calculations on groups of data and returns a single value.

Question 20

To show aggregate functions for one or more fields at the end of a datasheet,you would use the ________.

Accepted Answer

The total row is used to display aggregate functions at the end of a datasheet. It can display various functions such as sum, average, minimum, maximum, and count for one or more fields in the datasheet. The aggregate row and total column options do not exist in Access. The sum row option is a subset of the total row option, and therefore, Total row is the best choice.

Quiz 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

When you sort text in A to Z order,you are using a(n) ________ sorting option.