COSC 4325 Chapter 3

Name: ID:

Email:

COSC 4325 Chapter 3

True/False
Indicate whether the statement is true or false.

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

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

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

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

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.

The Find button is available only in Form view.

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

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

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

10.

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

11.

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.

12.

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

13.

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

14.

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

15.

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

16.

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

17.

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

18.

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

19.

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

20.

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

Multiple Choice
Identify the choice that best completes the statement or answers the question.

21.

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	c.	Tabular Form
b.	Simple Form	d.	Form View

22.

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

a.	Remove Filter	c.	All
b.	Filter	d.	Toggle Filter

23.

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

a.	Filter	c.	Advanced
b.	Remove	d.	Select

24.

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	c.	Advanced
b.	Selection	d.	Toggle Filter

25.

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	c.	Design
b.	Edit	d.	Datasheet

26.

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

a.	List	c.	Combo
b.	Lookup	d.	Value

27.

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

a.	List	c.	Combo
b.	Value	d.	Lookup

28.

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

a.	Query Type	c.	Update
b.	Action	d.	Data Definition

29.

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	c.	Preview
b.	View	d.	Delete View

30.

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	c.	Execute
b.	View	d.	Update

31.

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

a.	insert	c.	add
b.	append	d.	supplement

32.

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

a.	Home tab	c.	Quick Access Toolbar
b.	status bar	d.	Design tab

33.

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	c.	Resize Column
b.	Change Width	d.	Column Width

34.

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	c.	Insert Total
b.	Add Total	d.	Totals

35.

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

a.	Toggle	c.	Statistics
b.	Remove	d.	Totals

36.

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

a.	Field	c.	Unique
b.	Value	d.	Distinct

37.

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

a.	Order Ascending	c.	Sort Ascending
b.	Sort	d.	Ascending

38.

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

a.	Order Descending	c.	Sort Descending
b.	Descending	d.	Sort

39.

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

a.	saving	c.	compacting
b.	repairing	d.	recovering

40.

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	c.	Manage
b.	Database Operations	d.	Maintenance

41.

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	c.	Database Properties
b.	Object Properties	d.	Database Dependencies

42.

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

a.	Remove	c.	Delete
b.	Erase	d.	Remove Object

Completion
Complete each statement.

43.

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

44.

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

45.

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

46.

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

47.

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

48.

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

49.

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

50.

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

Figure 3-3

51.

To open the Relationships window in the accompanying figure, click the _________________________ button on the Database Tools tab.

52.

To add the Client and Recruiter tables to the Relationships window shown in the accompanying figure, click the Add button in the ___________________ dialog box.

53.

In the type of relationship between the Recruiter and Client tables illustrated in the accompanying figure, the infinity symbol indicates that one recruiter is related to _________________________ clients.

54.

The relationship in the accompanying figure was created by clicking the ____________________ check box in the Edit Relationships dialog box.

55.

To print a copy of a relationship, click the _____________________ button shown on the accompanying figure.