Deck 13: Access_Module_3

Question 1

When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab.

A)Remove Filter
B)Filter
C)All
D)Toggle Filter

Answer 1

D

Question 2

To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

A)Text Filters
B)Character Filters
C)Common Filters
D)Common Character Filters

Answer 2

A

Question 3

To create a split form, select the table in the Navigation Pane, click CREATE on the ribbon, click the ____ button on the CREATE tab to display a menu, and then click Split Form on the menu.

A)All Forms
B)More Forms
C)Tabular Forms
D)Forms View

Answer 3

B

Question 4

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and click the ____ tab in the Field Properties pane.

A)Modify
B)Change
C)Edit
D)Lookup

Question 5

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.

A)Change
B)Edit
C)Design
D)Datasheet

Question 6

To create an update query, create a new query and then click the ____ button on the DESIGN tab.

A)Query Type
B)Action
C)Update
D)Data Definition

Question 7

To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.

A)Filter
B)Remove
C)Advanced
D)Select

Question 8

To move from Layout view to Form view, click the ____ button on the Access status bar.

A)Open Form
B)Edit View
C)Data View
D)Form View

Question 9

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

A)aggregate
B)combined
C)total
D)calculated

Question 10

To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.

A)Selection
B)Filter By Selection
C)Find
D)Replace

Question 11

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

A)Filter
B)Find
C)Selection
D)Advanced

Question 12

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.

A)Run
B)View
C)Execute
D)Update

Question 13

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

A)list
B)value
C)combo
D)lookup

Question 14

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

A)insert-table
B)new-table
C)add-table
D)make-table

Question 15

To use Filter By Form to filter records, click the ____ button on the HOME tab and then click Filter By Form.

A)Advanced
B)Filter
C)Selection
D)Find

Question 16

To specify that a field is to be required, change the value for the _____ property from No to Yes.

A)Required
B)No Blanks
C)Necessary
D)Completed

Question 17

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

A)insert
B)append
C)add
D)supplement

Question 18

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

A)list
B)lookup
C)combo
D)value

Question 19

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the HOME tab to view the results.

A)Filter
B)Selection
C)Advanced
D)Toggle Filter

Question 20

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

A)Apply Filter
B)Filter
C)Toggle Filter
D)Select

Question 21

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.

A)Statistics
B)Add Total
C)Insert Total
D)Totals

Question 22

To find records in one table that have no matching records in another table, use the _____ Query Wizard.

A)No Matches
B)No Records
C)Find Unmatched
D)Find Records

Question 23

To specify that entries in the current due field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

A)>=0, <=30,000
B)>=$0, <=$30,000
C)>=0 and <=30000
D)>=$0 and <=$30,000

Question 24

Maintaining a database can include ____.

A)filtering records
B)changing the appearance of a datasheet
C)adding new records
D)changing the data for existing records

Question 25

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

Question 26

To remove a total row that appears in a datasheet, click the ____ button on the HOME tab.

A)Toggle
B)Remove
C)Statistics
D)Totals

Question 27

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

A)HOME tab
B)status bar
C)Quick Access Toolbar
D)DESIGN tab

Question 28

Computations available for the Total row in a column that contains currency include ____.

A)Sum
B)Square Root
C)Average
D)Count

Question 29

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

A)T*
B)T%
C)T>
D)T?

Question 30

To order the records in the Account table by city in alphabetical order, use the ____ button.

A)Order Ascending
B)Sort
C)Sort Ascending
D)Ascending

Question 31

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

A)Duplicate Records
B)Same Records
C)Duplicate Primary Key
D)Find Duplicates

Question 32

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

Question 33

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

Question 34

If the Account Number field in a record always should display the three characters in the account number in uppercase, then the correct format for this field is ____.

A)<
B)&
C)%
D)>

Question 35

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Question 36

You can add a record to a table by ____.

A)clicking the New (blank) record button on the Navigation bar
B)pressing CTRL+PLUS SIGN (+)
C)clicking the New button
D)pressing the INSERT key

Question 37

Validation rules can indicate a ____.

A)required field
B)default value
C)lookup field
D)range of values

Question 38

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

Question 39

The wildcard symbols for use with filters are ____.

A)asterisk (*)
B)dollar sign ($)
C)question mark (?)
D)caret symbol (^)

Question 40

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

A)Order Descending
B)Descending
C)Sort Descending
D)Sort

Question 41

Filter By Query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38.

Question 42

The Remove Filter command on the Advanced menu clears all filters.

Question 43

In the PrattLast Associates database, a one-to-many relationship exists between the Account Manager table and the Account table.

Question 44

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

Question 45

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

Question 46

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

Question 47

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

Question 48

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

Question 49

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

Question 50

To display the Total row in a datasheet, click the Sum button on the ribbon. ____________________

Question 51

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

Question 52

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

Question 53

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.

Question 54

Looking for the account whose number is LI268 is an example of searching.

Question 55

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record. ____________________

Question 56

Validation rules are rules that a user must follow when entering the data.

Question 57

A multilookup field is a field that contains more than one value. ____________________

Question 58

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

Question 59

A secondary key is a field in one table whose values are required to match the primary key of another table. ____________________

Question 60

You can search for a record in Form view but not in Datasheet view.

Question 61

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

Question 62

To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values check box.

Question 63

Case 3-2
​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes.
Bavant would like to move the Account Type field in the Account table. The field should appear before the Account Manager field. What do you need to do to move the field?

Question 64

To create a lookup field, select ____________________ from the menu of available data types.

Question 65

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, click the ____________________ for the field and then drag the field to the new location.

Question 66

Case 3-2
​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes.
Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

Question 67

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and click the ____________________ button on the HOME tab.

Question 68

A(n) ____________________ query adds, deletes, or changes data in a table.

Question 69

Case 3-1
PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules.
PrattLast would like to make sure that if a manager enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

Question 70

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

Question 71

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Question 72

When an update query is created, a(n) _________________________ row displays in the design grid.

Question 73

The property that the value in a foreign key must match another table's primary key is called _________________________.

Question 74

A(n) _________________________ is a field in one table whose values are required to match a primary key in another table.

Question 75

Case 3-1
PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules.
Because many of the accounts that PrattLast Associates services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?