A mathematical operator for division
Either individual criterion must be true in order for the compound criterion to be true.
Use to select values in a list
Represents any individual character.
A comparison operator.
Row that displays in the design grid when aggregate functions are used.
Use to select values in a given range.
Each individual criterion must be true in order for the compound criterion to be true.
Represents any collection of characters
An aggregate function
In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.
In the accompanying figure, the lower pane in the window where you enter criteria is called the _____.
In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.
In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76
In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the _____key(s).
In the accompanying figure, the criterion from Current Due is 0. The query results for this query will display ____ in the Current Due field.
In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter ___ in the Criteria row of the Amount Paid column.
In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $1,000.00, erase the 0 and enter ____ in the Criteria row of the Current Due column.
In the accompanying figure, Amount Paid is the ____key.
In the accompanying figure, Business Analyst Number is the ____ key.
The special criteria that can be used in queries are ____.
A(n) ______ join is the default join in Access.
For group calculations, Microsoft Access supports ____ build-in statistics.
Less than (<), greater than (>), and NOT (not equal to) are examples of _____.
The arithmetic symbols for use in query calculations are ____.
The ___ operator allows you to search for a range of values in one field.
To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.
To change the caption for a field in a query, click the field in the design grid, click the ___ button on the Design tab, click the Caption box, and enter the new caption.
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
To create a crosstab, click the ___button on the Create tab.
To create a new query in Design view, click create on the Ribbon to display the Create tab and then click the ____ button to create a new query.
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.
To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the Ribbon, and then click the Excel button.
To find all clients whose names begin with Gr, enter ____ in the Criteria row of the Client Name field
To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column
To include calculated fields in queries, enter a name for the calculated field, a (n) ____, and then the expression in one of the columns in the Field row.
To include the Total row in the design grid, click the ___ button on the Design tab.
To indicate grouping in Access, select ___ as the entry in the Total row for the field to be used for grouping.
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
Presents information about the database object, the progress of current tasks, and the statues of certain commands and keys.
Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
View that shows a report on the screen and does not allow changes to the report.
Field can store a unique sequential number that Access assigns to the record
A commonly accepted shorthand representation for showing the structure of a relational database.
Can include such information as the file’s author, title, or subject.
View that shows a report as it will appear when printed.
Field can contain only monetary data.
View that shows a report on the screen and allows changes to the report.
Field can contain any characters and the total numbers of characters cannot exceed 255.
In the accompanying figure, the Business Analyst Table displays in ____.
In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.
In the accompanying figure, the small box or bar to left of each field is called the.
A field with a Yes/No data type can store only one of two values. The choices are ____.
File names cannot contain a(n) ______.
Question Mark (?)
Table names cannot contain_____.
Accent graves (‘)
square brackets 
The Access window consists of a variety of components. These include the ____.
Quick Access Toolbar
You can create a table in ______.
A field whose data type is ______ can contain any characters.
A field whose data type is ______ can store an OLE object, which is an object linked to or embedded in the table.
A field with the _____data type can contain an attached file, such as an image, document, chart, or spreadsheet.
A field with the _____data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
A(n) ______ contains information about a given person, product, or event.
A(n) _____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
Need essay sample on "Computer Quiz Number 4"? We will write a custom essay sample specifically for you for only $ 13.90/page