1. When referencing field names within an expression, surround the field name with ____.

2. Interim testing normally occurs between the ____ and the ____.

3. Use the field properties pane to create an index for ____.

4. Vba procedures are created, modified, and displayed in the ____ window.

5. To edit an existing relationship, a user will need to right-click on the ________ line.

6. With a dutch flower auction, ______.

7. The trading bloc consisting of 28 trading partners in europe is the ____.

8. A(n) ____ is a series of actions that access performs when a particular event occurs.

9. A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

10. To open the navigation pane, tap or click the ____ button.

11. Validation rules are entered in the ____

12. To resize an image without changing its proportions, simply drag ____ of the image.

13. Deleting a record in a form will also delete it from the underlying ________.

14. The report footer section prints ____.

15. Access does not support the ____ data type.

16. To avoid the display of a security warning when opening a database, place the database ____.

17. When you create a report using the reports button, access generates the report using a ____ layout.

18. ____ shows the form on the screen and allows you to use the form to update data.

19. A criterion may be negated by using the ____ logical operator.

20. Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.

21. To save a query, click the save button on the ____.

22. To find duplicate records in a table, use the _____ query wizard.

23. The layout view or the design view may be used to create a ____ form.

24. When you assign a ____ to a field access

25. In sql server, you can use the ____ function to obtain today?s date.

26. In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

27. File names cannot contain a(n) ____

28. Use the ____ command to save the current object with a new name.

29. In addition to standard colors, the font color gallery displays ____ colors.

30. If you open a field list and the tables do not appear in the field list, click ____.

31. The ____ section appears at the bottom of the form and often is empty.

32. Microsoft access can best be described as ____ software.

33. In crosstab query results, the value of a checked yes/no data type field will display as ____.

34. A calculated field created in a query generates results when ____.

35. Statistical information such as totals and averages is calculated using ____.

36. To specify that a field is to be required, change the value for the _____ property from no to yes.

37. To sort records based on the selected field in the order z to a, use the _____ button.

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

39. To print two records from a form, select the ____ option in the print dialog box.

40. To move from layout view to form view, click the ____ button on the access status bar.

41. To modify a report while viewing actual report data, use the ____ view.

42. To display a field list in design view, click the ____ button on the form design tools design tab.

43. To create a table in design view, click the ____ button on the create tab.

44. To create a form using the form tool, click the ____ button in the forms group on the create tab.

45. To change the report margins, click the margins button on the report design tools ____ tab.

46. The value of a field containing no information is a ____ value.

47. The line tool is accessed using the more button in the ____ group on the design tab.

48. The contents of the ____ section are printed before the records in a particular group.

49. One way to create a table, is to click ____ on the ribbon and then click the table button.

50. You have a microsoft account if you use any of the following except ____.

51. When you display objects in ____ windows, each database object appears in its own window.

52. When you change the font color using the ribbon, you click the ____ button.

53. When the sort field data for each record in a database is different, the sort field is ____.

54. When access opens a form or report, the ____ event occurs.

55. With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

56. The group header section prints ____.

57. Rounded corners were first introduced in both the webkit and ____ browser extensions.

58. Field names ____.

59. You can include ____ in calculations to indicate which calculation should be done first

60. Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?

61. What does the expression Now() evaluate to?

62. Which combo box property defines what values appear when the user clicks the drop-down arrow?

63. How can you run a submacro saved in a macro?

64. When would you use a left join query?

65. Which section of a report appears at the top of every page in the printed report?

66. The expression values <=, <>, and > are found in what expression category?

67. Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

68. Which table field property, if supplied, will display instead of the field name as a column header when viewing the datasheet of as a label when the field is added toa form or report?

69. When backing up an Access database, what is added to the file name automatically?

70. Which Access database tool will help you split a single, large, unnormalized data table into multiple related tables that follow the best practices of good database design?

71. How can you ensure that each value saved in a particular field is unique from all other values in the field?

72. Which data type is a modern replacement for the OLE Object data type?

73. The display for numerical data defaults to a **_alignment, and text data defaults to **_aligntment

74. What program flow function evaluates a condition and either returns a truepart or a falsepart?

75. When you add a group to a report, what automatically gets added to the structure?

76. You want to validate a proposed modification to a record's value before the table is saved to the database. What data macro can you add to the table to do this?

77. What tool builds a report containing detailed information about the object in the database?

78. In Design view, which area of a form is the primary location for text boxes, buttons, and other control objects?

79. You want a form to appear automatically, whenever the database starts. How do you do this?

80. In Access Option > Current Database, what does turning off the Allow Full Menus option do?

81. What currency format displays a thousand separator, but not a currency symbol, such as $ or €?

82. What kind of query will display data with both column headers and row headers?

83. The relationship field in this table has been created with what feature?

84. On a report, you want to display a header for each change in month name. How should you set up the Group and Sort options so that they are in the proper chronological order?

85. What is the Access string operator that joins or concatenates text strings together?

86. Which form view mode allows you to preview live data while you work on the design of the form?

87. The ____ lists macro actions organized by type.

88. Controls placed in the ____ form section print only once at the top of the printout.

89. Before applying a conditional format in a report, the ____ box must be selected.

90. A(n) ________ is used to change settings such as formatting and captions.

91. A(n) ____ layout arranges controls vertically with the labels to the left of the control.

92. A(n) ____ is a saved object within the datasheet.

93. A file created in ____ is called a database and has an .accdb extension.

94. A calculated field is formatted using the ____ for the field

95. A ________ query is used to summarize data organized by field values.

96. A _____ view shows the content of multiple records on one page.

97. The autofilter sort method works on a(n)____ field(s).

98. The _____ data type is compatible with number.

99. Microsoft access 2016 can best be described as ____ software.

100. Two of the basic forms of sales promotion are ____ sales promotion and ____ sales promotion.