Deck 3: Maintaining a Database

Question 1

To move to the first resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

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

Answer 1

C

Question 2

As an alternate to using the Find button, you can press ____ to search for a specific resard and display the Search and Replace dialog box shown in the acsampanying figure.

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

Answer 2

B

Question 3

To delete a field from a table, open the table in ____ view, tap or click the row selector for the field to be deleted, and then press the DELETE key.

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

Answer 3

C

Question 4

To add a resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

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

Question 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

To filter resards using samplex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

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

Question 11

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

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

Question 12

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

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

Question 13

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

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

Question 14

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 tap or click the ____ tab in the Field Properties pane.

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

Question 15

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

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

Question 16

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

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

Question 17

To delete resard PLI22 shown in the acsampanying figure, tap or click the resard selector in the datasheet for the resard on which the client number is PLI22 and then press ____.

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

Question 18

If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.

A) Customize
B) Enable santent
C) Security
D) Unlock

Question 19

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

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

Question 20

To search for a specific resard tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the acsampanying figure.

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

Question 21

To include totals and other statistics at the bottom of a datasheet, tap or 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 exit Access, click the ____ button on the right side of the Access title bar.

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

Question 23

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

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

Question 24

To order the resards in the Customer table by city in alphabetical order, use the ____ button.

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

Question 25

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 26

To order the resards in the Customer table in reverse alphabetical order by City, click the ____ button.

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

Question 27

If the Customer Number field in a resard always should display the three characters in the customer number in uppercase, then the sarrect format for this field is ____.

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

Question 28

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) sampleted

Question 29

To indicate that the only allowable values for the Customer Type field are HS, saM, and UNI, enter ____ in the Validation Rule property box.

A) =HS or =saM or =UNI
B) HS, saM, UNI
C) must be HS, saM, or UNI
D) =HS, =saM, =UNI

Question 30

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

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

Question 31

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

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

Question 32

A(n) ____ query adds resards 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 33

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 34

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

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

Question 35

To update resards using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then tap or click the ____ button to update the resards.

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

Question 36

To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ____ on the shortcut menu, and then tap or click Update Query on the submenu that appears.

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

Question 37

To specify that entries in the Returns 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 38

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

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

Question 39

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

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

Question 40

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

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

Question 41

Modified Multiple Choice Maintaining a database can include ____.

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

Question 42

Modified Multiple Choice Validation rules can indicate a ____.

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

Question 43

Modified Multiple Choice samputations available for the Total row in a salumn that santains currency include ____.

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

Question 44

Filter By Query allows you to filter based on multiple criteria, for example, to find only those customers whose returns are $0.00 and whose book rep number is 42.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

If the TAB key is used to move from field to field in a resard, press F2 to produce an insertion point in a field.

Question 50

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

Question 51

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

Question 52

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

Question 53

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

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

Question 54

You can use the Find button on the HOME tab to search for resards in datasheets, forms, query results, and reports.

Question 55

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

Question 56

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

Question 57

Modified Multiple Choice You can add a resard to a table by ____.

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

Question 58

Looking for the customer whose number is PLI22 is an example of searching.

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

In the Bavant Publishing database, a one-to-many relationship exists between the Book Rep table and the Customer table.

Question 64

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

Question 65

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

Question 66

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

Question 67

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 68

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

Question 69

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, tap or click the ____________________ for the field and then drag the field to the new location.

Question 70

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

Question 71

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

Question 72

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

Question 73

You cannot preview the data to be updated in an update query before actually performing the update.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form .

Question 79

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

Question 80

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