Deck 4: Maintaining a Database

Question 1

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

Answer 1

D

Question 2

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

A) Last record
B) New (blank) record
C) Insert record
D) Blank record

Answer 2

B

Question 3

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 3

D

Question 4

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

A) CTRL+S
B) CTRL+F
C) CTRL+R
D) CTRL+L

Question 5

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

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

Question 6

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 7

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.

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

Question 8

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.

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

Question 9

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 10

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 11

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 12

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

A) Beginning record
B) Start record
C) First record
D) Goto record

Question 13

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

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

Question 14

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

A) Customize
B) Options
C) Security
D) Enable Content

Question 15

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 16

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

A) CTRL+D
B) DELETE
C) CTRL+DELETE
D) CTRL+Y

Question 17

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 18

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

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

Question 19

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.

A) Search
B) Filter
C) Search and Edit
D) Find

Question 20

To use a common filter with a field whose data type is Text, click the arrow to the right of the field name and point to the _____ command to display the common text filters.

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

Question 21

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 22

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 23

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 24

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 25

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.

A) Action
B) Query Type
C) Action Query
D) Run Query

Question 26

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 27

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.

A) >=0, <=50,000
B) >=$0, <=$50,000
C) >=0 and <=50000
D) >=$0 and <=$50,000

Question 28

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 29

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

A) Field
B) Value
C) Unique
D) Distinct

Question 30

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

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

Question 31

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 32

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 33

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 34

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

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

Question 35

To quit Access, click the ____ button on the right side of the Access title bar.

A) Quit
B) Exit
C) Close
D) Done

Question 36

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

A) =NON or =RET or =SER
B) NON, RET, SER
C) must be NON, RET, or SER
D) =NON, =RET, =SER

Question 37

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 38

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 39

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

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

Question 40

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 41

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 42

Looking for the client whose number is GF56 is an example of searching.

Question 43

Modified Multiple Choice Validation rules can indicate a ____.

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

Question 44

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

Question 45

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

Question 46

Modified Multiple Choice 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 on the Ribbon
D) pressing the INSERT key

Question 47

Modified Multiple Choice 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 48

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

Question 49

Filter By Query allows you to filter based on multiple criteria, for example, to find only those clients whose postal code is 27036 and whose amount paid is 0.

Question 50

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

Question 51

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

Question 52

You can filter individual fields by clicking the arrow to the right of the field name and using one of the common filters that are available for the field.

Question 53

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

Question 54

Modified Multiple Choice The wildcard symbols for use with filters are ____.

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

Question 55

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

Question 56

The simplest type of filter is called Filter By Form.

Question 57

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

Question 58

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

Question 59

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

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

Question 60

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

Question 61

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

Question 62

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 63

When the Business Analyst table is related to the Client table, it is possible to view the clients of a given analyst when you are viewing the datasheet for the Business Analyst table. The clients for the analyst will appear below the analyst in a split form .

Question 64

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

Question 65

In the Camashaly Design database, a one-to-many relationship exists between the Business Analyst table and the Client table.

Question 66

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

Question 67

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

Question 68

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

Question 69

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 70

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

Question 71

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

Question 72

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

Question 73

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 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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