Deck 5: Access: Maintaining a Database

Question 1

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

Answer 1

False

Question 2

Maintaining the database means modifying the data to keep it up-to-date, such as adding new records, changing the data for existing records, and deleting records.

Answer 2

True

Question 3

The Find button is available only in Form view.

Answer 3

False

Question 4

A change in outside regulations could cause changes to the structure of a table.

Question 5

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

Question 6

When you use an update query, you must enter a criterion.

Question 7

Access includes only three types of action queries: delete, update, and append.

Question 8

Backing up the database as well as compacting and repairing a database are database maintenance tasks.

Question 9

The simplest type of filter is called Filter By Form.

Question 10

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

Question 11

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

Question 12

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

Question 13

The command on the shortcut menu that displays data in Form view is Form View.

Question 14

To add a field to a table structure, click the row selector for the field that will follow the new field, and then press the INSERT key to insert a blank row.

Question 15

To add a new record using Form view, click the Add Record button on the Navigation bar.

Question 16

If you plan to move your data to SQL Server at a later date, do not use multivalued fields.

Question 17

You cannot apply a filter to the results of a query.

Question 18

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

Question 19

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

Question 20

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 21

To redisplay all records after using a filter, click the ____ button on the Home tab.

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

Question 22

To create a simple form, select the table in the Navigation Pane, click Create on the Ribbon and then click the ____ button on the Create tab.

A)Form
B)Simple Form
C)Tabular Form
D)Form View

Question 23

Figure 3-2 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 24

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

A)Customize
B)Options
C)Security
D)Warning

Question 25

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

Question 26

Figure 3-2 To use Filter By Selection to find all clients located in Berridge, click the City field for any record where the city is Berridge 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 27

Figure 3-1 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 28

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

Question 29

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

Question 30

Figure 3-2 To delete record EA45 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is EA45 and then press ____.

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

Question 31

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

Question 32

Changing a column width changes the format , or design, of a table.

Question 33

When the Recruiter table is related to the Client table, it is possible to view the clients of a given recruiter when you are viewing the datasheet for the Recruiter table. The clients for the recruiter will appear below the recruiter in a subdatasheet .

Question 34

Figure 3-1 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

Question 35

In the JSP Recruiters database, a one-to-many relationship exists between the Recruiter table and the Client table.

Question 36

Figure 3-2 To search for a specific record click the Find button on the Home tab shown in the accompanying figure to display the ____ dialog box.

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

Question 37

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

Question 38

When you use a make-table query to add records to a new table, Access creates the table as part of the process.

Question 39

To move from Layout view to Form view, click the ____ button.

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

Question 40

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 41

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 42

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

A)List
B)Lookup
C)Combo
D)Value

Question 43

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 44

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 45

To resize a column in a datasheet, you can double-click the right boundary selector of the field to be resized or you can right-click the field name and then click ____.

A)Resize
B)Change Width
C)Resize Column
D)Column Width

Question 46

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 47

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 48

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 49

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 50

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 51

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 52

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 53

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 54

To preview data to be deleted in a delete query, click the ____ button after you create the query, but before you run it.

A)Data
B)View
C)Preview
D)Delete View

Question 55

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 56

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 57

To specify that entries in the Amount Paid field must be between $0.00 and $100,000.00, enter ____ in the Validation Rule property box.

A)>=0,
B)>=$0,
C)>=0 and
D)>=$0 and

Question 58

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 59

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 60

To indicate that the only allowable values for the Client Type field are MED, DNT, and LAB, enter ____ in the Validation Rule property box.

A)=MED or =DNT or =LAB
B)MED, DNT, LAB
C)must be MED, DNT, or LAB
D)=MED, =DNT, =LAB

Question 61

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

Question 62

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 63

To back up a database, open the database to be backed up, click the Office Button, point to ____ on the Office Button menu, and then click Back Up Database on the submenu that appears.

A)Database Tools
B)Database Operations
C)Manage
D)Maintenance

Question 64

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 65

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

Question 66

To delete a field in a table, the table must be opened in ____________________ view.

Question 67

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 68

When a database is damaged, you must return the database to a correct state. This process is called ____.

A)saving
B)repairing
C)compacting
D)recovering

Question 69

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

Question 70

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 71

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

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

Question 72

To delete a table or other object, right-click the object and then click ____ on the shortcut menu.

A)Remove
B)Erase
C)Delete
D)Remove Object

Question 73

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

Question 74

To check for dependent objects, select the object that you want to check, click Database Tools on the Ribbon, and then click the ____ button on the Database Tools tab.

A)Object Dependencies
B)Object Properties
C)Database Properties
D)Database Dependencies

Question 75

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

Question 76

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

Question 77

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

Question 78

To open another database, click the Office Button, click ____ on the Office Button menu, select the database to be opened, and then click the Open button.

A)Another Database
B)Browse
C)Locate
D)Open

Question 79

To close a database without exiting Access, click the Office Button and then click ____ on the Office Button menu.

A)Exit Database Only
B)Close Database
C)Database Options
D)Quit Database Only

Question 80

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