Access 2010

Front 1

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.

Back 1

True

Front 2

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

Back 2

Text filters

Front 3

A(n)____query adds a group of records from one table to the end of another table

Back 3

Append

Front 4

In the Camashaly Design database, a one to many relationship exist between the Business Analyst table and the client table

Back 4

True

Front 5

Restructuring the data base includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Back 5

True

Front 6

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____

Back 6

Delete

Front 7

When you use a split form, you can use add records using the simple form?

Back 7

False

Front 8

To move to the first record using the form in the accompanying figure, click the ___button on the Navigation bar

Back 8

first record

Front 9

One reason to include a foreign key for a table is to eliminate duplicate records.

Back 9

false

Front 10

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.

Back 10

Selection

Front 11

To open a form in Form view from the Navigation pane, right click the form and click Form View on the short cut menu

Back 11

False

Front 12

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.

Back 12

Move Forms

Front 13

You can convert a number field to a Currency field but you cannot convert a currency field to a number field.

Back 13

False

Front 14

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

Back 14

Find

Front 15

To remove a total row that appears in a datasheet, click the _____button on the Home tab.

Back 15

Totals

Front 16

To clear a filter, click the ________-button on the Home tab and then click Clear All Filters

Back 16

Advanced

Front 17

A___field allows the user to select from a list of values

Back 17

Lookup

Front 18

Validation rules are rules that a iser must follow when entering the data

Back 18

True

Front 19

The Unfilter button toggles between filtered and unfiltered displays of the records in a table

Back 19

False

Front 20

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ....

Back 20

Toggle Filter

Front 21

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.

Back 21

True

Front 22

The simplest type of filter is called Filter By Form

Back 22

False

Front 23

To order the records in the client table by City in alphabetical order, use the _____button.

Back 23

Acsending

Front 24

Looking for the client whose number is GF56 is an example if searchng

Back 24

True

Front 25

To find records in one table that have no matching records in another table, use the ____Query Wizard

Back 25

Find Unmatched

Front 26

To create a multivalued field, create a ___field being sure to check the Allow Multiple values check box

Back 26

Lookup

Front 27

When a filter is in effect, you can-redisplay all records by clicking the ____button on the Home tab.

Back 27

Toggle Filter

Front 28

To use filter By Form to filter records, click the _______button on the Home tab and then click Filter By Form

Back 28

Advanced

Front 29

As an alternate to using the find button shown in the accompanying figure, you can press____to search for a specific record

Back 29

CTRL -F

Front 30

You cannot preview the data to be deleted in a delete query before actually performing the deletion.

Back 30

False

Front 31

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field

Back 31

False

Front 32

When You create a calculated field, users can update the field

Back 32

False

Front 33

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.

Back 33

Run

Front 34

To move from Layout view to Form view, click the ___button on the Access Status Bar

Back 34

Form View

Front 35

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_____

Back 35

Zoom

Front 36

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.

Back 36

Colon (:)

Front 37

The question mark (?) wildcard represents any individual character

Back 37

True

Front 38

To save a query, click the Save button on the _____

Back 38

Quick access Toolbar

Front 39

To show the navigation pane if it is hidden, click the ___Button

Back 39

Shutter bar open/close

Front 40

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____

Back 40

Design grid

Front 41

When you sort data in a query, the records in the underlying table are actually rearranged

Back 41

False

Front 42

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

Back 42

View

Front 43

Crosstab queries are useful for summarizing data

Back 43

True

Front 44

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

Back 44

>1000

Front 45

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.

Back 45

Delete

Front 46

To find all individuals whose name is Francis or Frances, enter ____in the Criteria row of the appropriate column

Back 46

Franc?s

Front 47

In the accompanying figure, the criterion for Current Due is 0. The query results for this query will display ____in the Current Due field.

Back 47

$0.00

Front 48

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

Back 48

Criteria

Front 49

A (n)___join is the default join in Access.

Back 49

Inner

Front 50

The field or fields on which records are sorted is called the sort key.

Back 50

True

Front 51

You can include ___in calculations to indicate which calculation should be done first.

Back 51

Parentheses ( )

Front 52

The question mark (?) wildcard represents any individual character

Back 52

True

Front 53

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____

Back 53

Build

Front 54

In the accompanying figure, you can delete the table by right-clicking the field list and clicking____on the shortcut menu.

Back 54

Remove Table

Front 55

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 ______

Back 55

Square Brackets [ ]

Front 56

The ___operator allows you to search for a range of values in one field

Back 56

Between

Front 57

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.

Back 57

False

Front 58

When you enter text data in a criterion, you must enclose the text in quotation marks.

Back 58

False

Front 59

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Back 59

True

Front 60

A query that prompts for input whenever it is run is a run-time query.

Back 60

False

Front 61

To include the Total row in the design grid, click the _____ button on the Design tab.

Back 61

Totals

Front 62

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

Back 62

2000

Front 63

The question mark (?) wildcard represents any individual character.

Back 63

True

Front 64

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.

Back 64

Query Design

Front 65

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

Back 65

False

Front 66

To order the records in the answer to a query in a particular way, you ____ the records.

Back 66

Sort

Front 67

To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.

Back 67

Gr*

Front 68

A query that prompts for input whenever it is run is a run-time query.

Back 68

False

Front 69

To use a parameter query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

Back 69

Open

Front 70

Last than (<), greater than (>) and NOT ( not equal to ) are examples of ___

Back 70

comparison operators

Front 71

enter a number in a criterion, type the number without any dollar signs or commas.

Back 71

True

Front 72

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

Back 72

Open

Front 73

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.

Back 73

False

Front 74

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

Back 74

Design view

Front 75

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.

Back 75

True

Front 76

IIn the accompanying figure, the lower pane in the window where you enter criteria is called the

Back 76

Design Grid

Front 77

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.

Back 77

where

Front 78

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.

Back 78

Sort

Front 79

To create a crosstab, click the ____ button on the Create tab.

Back 79

Query Wizard

Front 80

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____

Back 80

Design Grid

Front 81

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.

Back 81

False

Front 82

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.

Back 82

Criteria

Front 83

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.

Back 83

Query Design

Front 84

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

Back 84

False

Front 85

The button on the Access Status bar that displays a form in Form view is Form View.

Back 85

True

Front 86

To add a record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

Back 86

New (blank) record

Front 87

To find duplicate records in a table, use the _____ Query Wizard.

Back 87

Find Dublicates

Front 88

To filter records using complex criteria, click the ____ button on the Home tab and then click Advanced Filter/Sort on the menu that appears.

Back 88

Advanced

Front 89

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

Back 89

Value

Front 90

When you create a calculated field, users can update the field.

Back 90

False

Front 91

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 ____.

Back 91

Delete

Front 92

You can use a filter in either Datasheet view or Form view.

Back 92

True

Front 93

You can use a make-table query to create an archive table.

Back 93

True

Front 94

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

Back 94

True

Front 95

You cannot preview the data to be deleted in a delete query before actually performing the deletion.

Back 95

False

Front 96

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Back 96

True

Front 97

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.

Back 97

>=0 and <=50000

Front 98

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.

Back 98

Find

Front 99

A(n) _____ field is a field that can be computed from other fields.

Back 99

Calculated

Front 100

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.

Back 100

True

Front 101

A lookup field allows the user to select from a list of values when updating the contents of a field.

Back 101

True

Front 102

To save validation rules, default values, and formats, click the Save button on the ____ to save the changes.

Back 102

Quick access toolbar

Front 103

When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.

Back 103

Toggle Filter

Front 104

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.

Back 104

Totals

Front 105

As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

Back 105

CTRL-F

Front 106

If a Security Warning appears when you open a database, click the ____ option button.

Back 106

Enable Content

Front 107

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Back 107

T?

Front 108

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.

Back 108

Query Type

Front 109

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.

Back 109

Design

Front 110

To order the records in the Client table in reverse alphabetical order by City, click the ____ button.

Back 110

Descending

Front 111

To add a new record using Form view, click the New (blank) record button on the Navigation bar.

Back 111

True

Front 112

To indicate that the only allowable values for the Client Type field are NON, RET, and SER, enter ____ in the Validation Rule property box.

Back 112

=NON or =RET or =SER

Front 113

A ____ field allows the user to select from a list of values.

Back 113

Lookup

Front 114

To move to the first record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

Back 114

First Record

Front 115

One reason to include a foreign key for a table is to eliminate duplicate records.

Back 115

False

Front 116

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.

Back 116

Selection

Front 117

To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.

Back 117

False

Front 118

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.

Back 118

Move Forms

Front 119

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field

Back 119

false

Front 120

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

Back 120

Find