# Computer Quiz Number 4

A mathematical operator for division
/
Either individual criterion must be true in order for the compound criterion to be true.
OR criterion
Use to select values in a list
IN
Represents any individual character.
?
A comparison operator.
NOT
Row that displays in the design grid when aggregate functions are used.
Total
Use to select values in a given range.
Between
Each individual criterion must be true in order for the compound criterion to be true.
AND criterion
Represents any collection of characters
*
An aggregate function
VAR
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.
Show Table
In the accompanying figure, the lower pane in the window where you enter criteria is called the _____.
Design Grid
In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.
Remove Table
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
Criteria
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).
Delete
In the accompanying figure, the criterion from Current Due is 0. The query results for this query will display ____ in the Current Due field.
\$0.00
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.
2000
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.
>1000
In the accompanying figure, Amount Paid is the ____key.
Secondary Sort
Minor
In the accompanying figure, Business Analyst Number is the ____ key.
Major
Primary Sort
The special criteria that can be used in queries are ____.
In
Between
And
A(n) ______ join is the default join in Access.
inner
For group calculations, Microsoft Access supports ____ build-in statistics.
MAX
STDEV
VAR
Less than (<), greater than (>), and NOT (not equal to) are examples of _____.
Comparison Operators.
The arithmetic symbols for use in query calculations are ____.
Asterisk (*)
Slash (/)
The ___ operator allows you to search for a range of values in one field.
Between
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.
Where
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.
Caption
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
Design View
To create a crosstab, click the ___button on the Create tab.
Query Wizard
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.
Query Design
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 ____.
Square Brackets
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 ____.
Zoom
To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.
Join Prperties
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.
External Data
To find all clients whose names begin with Gr, enter ____ in the Criteria row of the Client Name field
Gr*
To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.
Franc?s
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column
MAX
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.
Colon (:)
To include the Total row in the design grid, click the ___ button on the Design tab.
Totals
To indicate grouping in Access, select ___ as the entry in the Total row for the field to be used for grouping.
Group By
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
Yes
Presents information about the database object, the progress of current tasks, and the statues of certain commands and keys.
Status Bar
Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
Memo
View that shows a report on the screen and does not allow changes to the report.
Report view
Field can store a unique sequential number that Access assigns to the record
AutoNumber
A commonly accepted shorthand representation for showing the structure of a relational database.
DBDL
Can include such information as the file’s author, title, or subject.
View that shows a report as it will appear when printed.
Print Preview
Field can contain only monetary data.
Currency
View that shows a report on the screen and allows changes to the report.
Layout View
Field can contain any characters and the total numbers of characters cannot exceed 255.
Text
In the accompanying figure, the Business Analyst Table displays in ____.
Design View
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.
Primary Key.
In the accompanying figure, the small box or bar to left of each field is called the.
Row Selector
A field with a Yes/No data type can store only one of two values. The choices are ____.
Yes/No
True/False
On/Off
File names cannot contain a(n) ______.
Colon (:)
Question Mark (?)
Table names cannot contain_____.
Accent graves (‘)
periods (.)
square brackets []
The Access window consists of a variety of components. These include the ____.
Ribbon
You can create a table in ______.
Design View
Datasheet View
A field whose data type is ______ can contain any characters.
Text
A field whose data type is ______ can store an OLE object, which is an object linked to or embedded in the table.
OLE Object
A field with the _____data type can contain an attached file, such as an image, document, chart, or spreadsheet.
Attachement
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.
AutoNumber
A(n) ______ contains information about a given person, product, or event.
Record
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.
Memo

Need essay sample on "Computer Quiz Number 4"? We will write a custom essay sample specifically for you for only \$ 13.90/page

#### Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Service Open At All Times
|