1. B (15Acces-3-7) to Add Records Using Form View, Click the ______Button

mnsc 341 Homework 8

1. b (15Acces-3-7) To add records using Form view, click the ______button.

2. d (15Acces-3-8) To search for a specific record in a table, select the field to search and then click the ______that displays on the toolbar in the accompanying figure.

3. a (15Acces-3-12) To filter records, that is, to have only the record or records that satisfy some criteria display, use the ______that displays on the toolbar in the accompanying figure.

4. b (15Acces-3-14) To delete a record, click the row selector for the record to be deleted, and then press the ______key(s).

5. a (15Acces-3-17) To add a field to a table structure, select the field below where you would like to insert the new field and then press the ______key(s).

6. b (15Acces-3-25) To change the warranty amount of all marinas whose warranty amount is currently $900 to $1,000, create an update query, place the Warranty field in the design grid, enter ______in the Criteria: row.

7. a (15Acces-3-27) To use a delete query to delete all records with the value OH in the State field, create a new query for the Client table, click Delete Query from the Query Type submenu, place the State field in the design grid, and enter OH in the ______row.

8. c (15Acces-3-28) ______are rules that a user must follow when entering data.

9. d (15Acces-3-32) A field has the format > in the Format box. If you type ltd in the field it will display as ______.

10. a (15Acces-3-32) A field has the format < in the Format box. If you type fm22 in the field it will display as ______.

11. d (15Acces-3-38) The property that the value in a foreign key must match that of another table's primary key is called ______integrity.

12. c (15Acces-3-42) To order records in the Marina table in descending order by warranty amount, click the Warranty field, and then click the ______button on the toolbar.

13. d (15Acces-3-46) Indexes ______.

14. a - true (15Acces-3-6) The three basic tasks that are performed to keep data in a database up to date are: adding new records, changing the data in existing records, and deleting existing records.

15. b - false (15Acces-3-7) To add a new record using Form view, click the Append Record button.

16. a - true (15Acces-3-8) To search for a specific record in a table, move the highlight to the field in which you wish to search and click the Find button.

17. b - false (15Acces-3-10) If the status bar displays the letters INS, Access is in Overtype mode.

18. b - false (15Acces-3-14) To delete a record, click the row selector for the record to be deleted, and then press CTRL+D.

19. b - false (15Acces-3-12) To filter records based on values in more than one field, click the Filter By Value button rather than Filter By Selection button.

20. b - false (15Acces-3-17) To change the size of a field, click the row selector for the field, press F8to move to the Field Properties pane in the Table Design window, and enter the new field size.

21. b - false (15Acces-3-19) When changes to the structure of a table are made and saved, the changes are not available until you close the database and then open it again.

22. a - true (15Acces-3-20) To allow Access to determine the best size for a column, double-click the right boundary of the column's field selector.

23. a - true (15Acces-3-25) When an update query is created, an Update To: row displays in the design grid.

24. b - false (15Acces-3-26) To create a delete query, create a new query, click Query Type on the shortcut menu for the upper pane of the Select Query window, and then click Update Query.

25. b - false (15Acces-3-28) Validation rules can indicate a default value field, which is a field in which the user actually must enter data.

26. a - true (15Acces-3-28) Validation text is the message that will display if a user violates the validation rule.

27. a - true (15Acces-3-30) When a default value is specified for a field, it means that Access will automatically enter the value as soon as a new record is added.

28. a - true (15Acces-3-32) To specify that MI, IL and IN are the only legal values for the State field, type =MI or =IL or =IN in the Validation Rule text box in the Table window.

29. b - false (15Acces-3-32) A field has the format > in the Format text box. If 12345A is typed in the field, Access will consider the entry invalid.

30. a - true (15Acces-3-34) When validation rules are saved, Access provides the option of applying validation rules to already existing data in the table.

31. a - true (15Acces-3-38) A foreign key is a field in one table whose values are required to match a primary key in another table.

32. a - true (15Acces-3-38) In Access, to specify referential integrity, define a relationship between the tables by using the Relationships command.

33. a - true (15Acces-3-41) To obtain a printed copy of the relationships within a database, display the Relationships window, click File on the menu bar, and then click Print Relationships.

34. a - true (15Acces-3-41) If there is a one-to-many relationship established between two tables in a database, the many table can display in a subdatasheet while viewing the one table in Datasheet view.

35. b - false (15Acces-3-43) To sort the data that displays in a datasheet on multiple fields, the major key and minor key must be next to each other in the datasheet with the major key to the right.

36. Overtype (15Acces 3-10) If the status bar displays the letters OVR, Access is in ______mode.

37. Datasheet View (15Acces 3-11) To move from Form view to Datasheet view, click the View button arrow and then click ______.

38. Apply Filter (15Acces 3-12) To filter records based on values in more than one field, click the Filter By Form button on the toolbar and then click the ______button.

39. Remove Filter (15Acces 3-13) To remove an existing filter from a table, click the ______button on the toolbar.

40. DELETE (15Acces 3-19) To delete a field from a table, open the table in Design view, click the row selector for the field to select it, and then click the ______key(s).

41. Delete Query (15Acces 3-26) To create a delete query, create a new query, click Query Type on the shortcut menu for the upper pane of the Select Query window, and then click ______.

42. Validation rules (15Acces 3-28) ______are rules that a user must follow when entering data.

43. required (15Acces 3-28) Validation rules can indicate a(n) ______field, which is a field in which the user actually must enter data.

44. Design View (15Acces 3-28) To specify validation rules for a table, right-click the table in the Database window and click ______on the shortcut menu.

45. INC (15Acces 3-32) A field has the format > in the Format text box. If inc is typed in the field it will display as ______.

46. =IWO or =BIR or =RSO (15Acces 3-32) To specify that the only legal values for the Marina Type field are IWO, BIR, or RSO, enter ______in the Validation Rule text box for the Marina Type field.

47. foreign (15Acces 3-38) A(n) ______key is a field in one table whose values are required to match a primary key in another table.

48. one-to-many (15Acces 3-38) The type of relationship between the Technician and Marina tables illustrated in the accompanying figure is a(n) ______relationship.

49. Print Relationships (15Acces 3-41) To obtain a printed copy of the accompanying figure, click File on the menu bar and then click ______.

50. Indexes (15Acces 3-48) To create a multiple-field index, click the ______button on the toolbar.