Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
120 Cards in this Set
- Front
- Back
You can filter individual fields by clicking the arrow to the right if the field name and using one of the common filters that are available for the field.
|
True
|
|
To use common filter with a field whose data type is Text, click to the right of the field name and point to the ______command ti display the common text filters
|
Text filters
|
|
A(n)____query adds a group of records from one table to the end of another table
|
Append
|
|
In the Camashaly Design database, a one to many relationship exist between the Business Analyst table and the client table
|
True
|
|
Restructuring the data base includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.
|
True
|
|
To delete record GF56 shown in the accompanying figure, click the record selector in the data sheet for the record on which the client number is GF56 and then press____
|
Delete
|
|
When you use a split form, you can use add records using the simple form?
|
False
|
|
To move to the first record using the form in the accompanying figure, click the ___button on the Navigation bar
|
first record
|
|
One reason to include a foreign key for a table is to eliminate duplicate records.
|
false
|
|
To use filter by selection to find all clients located in Burles, click the city field for any record where the city is Burles and then click the _____button on the home tab shown in the accompanying figure.
|
Selection
|
|
To open a form in Form view from the Navigation pane, right click the form and click Form View on the short cut menu
|
False
|
|
To create a split form, select the table in the navigation Pane, click Create on the ribbon, and then click the _____button on the create tab to display a menu and click split Form on the menu.
|
Move Forms
|
|
You can convert a number field to a Currency field but you cannot convert a currency field to a number field.
|
False
|
|
To search for a specific record click the ____button in the Home Tab shown in the accompanying figure to display the Find and Replace dialog box
|
Find
|
|
To remove a total row that appears in a datasheet, click the _____button on the Home tab.
|
Totals
|
|
To clear a filter, click the ________-button on the Home tab and then click Clear All Filters
|
Advanced
|
|
A___field allows the user to select from a list of values
|
Lookup
|
|
Validation rules are rules that a iser must follow when entering the data
|
True
|
|
The Unfilter button toggles between filtered and unfiltered displays of the records in a table
|
False
|
|
When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ....
|
Toggle Filter
|
|
You can filter individual fields by clicking the arrow to the right on the field name and using one of the common filters that are available for the field.
|
True
|
|
The simplest type of filter is called Filter By Form
|
False
|
|
To order the records in the client table by City in alphabetical order, use the _____button.
|
Acsending
|
|
Looking for the client whose number is GF56 is an example if searchng
|
True
|
|
To find records in one table that have no matching records in another table, use the ____Query Wizard
|
Find Unmatched
|
|
To create a multivalued field, create a ___field being sure to check the Allow Multiple values check box
|
Lookup
|
|
When a filter is in effect, you can-redisplay all records by clicking the ____button on the Home tab.
|
Toggle Filter
|
|
To use filter By Form to filter records, click the _______button on the Home tab and then click Filter By Form
|
Advanced
|
|
As an alternate to using the find button shown in the accompanying figure, you can press____to search for a specific record
|
CTRL -F
|
|
You cannot preview the data to be deleted in a delete query before actually performing the deletion.
|
False
|
|
You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field
|
False
|
|
When You create a calculated field, users can update the field
|
False
|
|
To Update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion , and then click the ____button to update the records.
|
Run
|
|
To move from Layout view to Form view, click the ___button on the Access Status Bar
|
Form View
|
|
To display the entire entry for a calculated field, select the column in the field row, right click to display the short cut menu and then click_____
|
Zoom
|
|
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 (:)
|
|
The question mark (?) wildcard represents any individual character
|
True
|
|
To save a query, click the Save button on the _____
|
Quick access Toolbar
|
|
To show the navigation pane if it is hidden, click the ___Button
|
Shutter bar open/close
|
|
In the accompanying figure, the lower pane in the window where you enter criteria is called the ____
|
Design grid
|
|
When you sort data in a query, the records in the underlying table are actually rearranged
|
False
|
|
To print the results of a query that is open , click File on the ribbon, click the _____tab in the Backstage view, and then click quick Print
|
View
|
|
Crosstab queries are useful for summarizing data
|
True
|
|
In the accompanying figure, the criterion for current data is 0. To find all clients who current due amount is greater than $1000.00 erase the o and enter ________in the criteria row for the Current Due column
|
>1000
|
|
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.
|
Delete
|
|
To find all individuals whose name is Francis or Frances, enter ____in the Criteria row of the appropriate column
|
Franc?s
|
|
In the accompanying figure, the criterion for Current Due is 0. The query results for this query will display ____in the Current Due field.
|
$0.00
|
|
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
|
|
A (n)___join is the default join in Access.
|
Inner
|
|
The field or fields on which records are sorted is called the sort key.
|
True
|
|
You can include ___in calculations to indicate which calculation should be done first.
|
Parentheses ( )
|
|
The question mark (?) wildcard represents any individual character
|
True
|
|
To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click____
|
Build
|
|
In the accompanying figure, you can delete the table by right-clicking the field list and clicking____on the shortcut menu.
|
Remove Table
|
|
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 [ ]
|
|
The ___operator allows you to search for a range of values in one field
|
Between
|
|
If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key.
|
False
|
|
When you enter text data in a criterion, you must enclose the text in quotation marks.
|
False
|
|
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
|
True
|
|
A query that prompts for input whenever it is run is a run-time query.
|
False
|
|
To include the Total row in the design grid, click the _____ button on the Design tab.
|
Totals
|
|
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
|
|
The question mark (?) wildcard represents any individual character.
|
True
|
|
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
|
|
If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key
|
False
|
|
To order the records in the answer to a query in a particular way, you ____ the records.
|
Sort
|
|
To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.
|
Gr*
|
|
A query that prompts for input whenever it is run is a run-time query.
|
False
|
|
To use a parameter query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
|
Open
|
|
Last than (<), greater than (>) and NOT ( not equal to ) are examples of ___
|
comparison operators
|
|
enter a number in a criterion, type the number without any dollar signs or commas.
|
True
|
|
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
|
Open
|
|
To create a top-values query, use the Top Values box on the Design tab to change the number of records to be included from All to the desired number.
|
False
|
|
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
|
Design view
|
|
To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
|
True
|
|
IIn the accompanying figure, the lower pane in the window where you enter criteria is called the
|
Design Grid
|
|
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 sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.
|
Sort
|
|
To create a crosstab, click the ____ button on the Create tab.
|
Query Wizard
|
|
In the accompanying figure, the lower pane in the window where you enter criteria is called the ____
|
Design Grid
|
|
To find all clients whose amount paid is greater than $1,000.00 and whose business analyst is analyst 11, enter each criterion on different lines.
|
False
|
|
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
|
|
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
|
|
You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.
|
False
|
|
The button on the Access Status bar that displays a form in Form view is Form View.
|
True
|
|
To add a record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.
|
New (blank) record
|
|
To find duplicate records in a table, use the _____ Query Wizard.
|
Find Dublicates
|
|
To filter records using complex criteria, click the ____ button on the Home tab and then click Advanced Filter/Sort on the menu that appears.
|
Advanced
|
|
To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.
|
Value
|
|
When you create a calculated field, users can update the field.
|
False
|
|
To delete record GF56 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is GF56 and then press ____.
|
Delete
|
|
You can use a filter in either Datasheet view or Form view.
|
True
|
|
You can use a make-table query to create an archive table.
|
True
|
|
Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.
|
True
|
|
You cannot preview the data to be deleted in a delete query before actually performing the deletion.
|
False
|
|
Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.
|
True
|
|
To specify that entries in the Amount Paid field must be between $0.00 and $50,000.00, enter ____ in the Validation Rule property box.
|
>=0 and <=50000
|
|
To search for a specific record click the _____ button on the Home tab shown in the accompanying figure to display the Find and Replace dialog box.
|
Find
|
|
A(n) _____ field is a field that can be computed from other fields.
|
Calculated
|
|
If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.
|
True
|
|
A lookup field allows the user to select from a list of values when updating the contents of a field.
|
True
|
|
To save validation rules, default values, and formats, click the Save button on the ____ to save the changes.
|
Quick access toolbar
|
|
When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.
|
Toggle Filter
|
|
To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.
|
Totals
|
|
As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.
|
CTRL-F
|
|
If a Security Warning appears when you open a database, click the ____ option button.
|
Enable Content
|
|
To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.
|
T?
|
|
To use the shortcut menu to create an update query, right-click any open area in the upper pane, point to ____ on the shortcut menu, and then click Query Type on the submenu that appears.
|
Query Type
|
|
To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.
|
Design
|
|
To order the records in the Client table in reverse alphabetical order by City, click the ____ button.
|
Descending
|
|
To add a new record using Form view, click the New (blank) record button on the Navigation bar.
|
True
|
|
To indicate that the only allowable values for the Client Type field are NON, RET, and SER, enter ____ in the Validation Rule property box.
|
=NON or =RET or =SER
|
|
A ____ field allows the user to select from a list of values.
|
Lookup
|
|
To move to the first record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.
|
First Record
|
|
One reason to include a foreign key for a table is to eliminate duplicate records.
|
False
|
|
To use Filter By Selection to find all clients located in Burles, click the City field for any record where the city is Burles and then click the ____ button on the Home tab shown in the accompanying figure.
|
Selection
|
|
To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.
|
False
|
|
To create a split form, select the table in the Navigation Pane, click Create on the Ribbon, and then click the ____ button on the Create tab to display a menu and click Split Form on the menu.
|
Move Forms
|
|
You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field
|
false
|
|
To search for a specific record click the _____ button on the Home tab shown in the accompanying figure to display the Find and Replace dialog box
|
Find
|