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

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

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

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

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

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

7. The group header section prints ____.

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

9. Field names ____.

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

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

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

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

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

15. When would you use a left join query?

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

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

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

19. 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?

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

21. 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?

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

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

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

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

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

27. 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?

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

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

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

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

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

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

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

35. 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?

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

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

38. The ____ lists macro actions organized by type.

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

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

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

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

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

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

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

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

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

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

49. The _____ data type is compatible with number.

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

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

52. ________ advertising is used when introducing a new product.

53. Referential integrity prevents the creation of ____ records.

54. Date criteria are automatically enclosed in ____ when entered in a query design.

55. Access uses ____ as the source program to create a graph when the chart wizard is used.

56. ____ is the default entry for each field in the total row of the query design grid.

57. When creating a query using the query design command, first you must ____________.

58. To show the navigation pane if it is hidden, click the ____ button.

59. To save the changes to the layout of a table, tap or click the save button on the ____.

60. To include the total row in the design grid, click the ____ button on the design tab.

61. Billboard advertising is most effective for __________ advertising

62. When you double-click a field in a field list in query design view, it is ____.

63. New records can be added to an access table in either datasheet view or ____ view.

64. A summary query calculates statistics about ____.

65. A report formatted where the page is taller than it is wide is formatted in ____.

66. The _____ function returns the current system date in ms access.

67. A(n) ________ is the data used by a function to produce a result.

68. To place a subform on a form, use the subform/subreport tool on the ____ tab.

69. Another name for an input in a function is a(n) ________.

70. Access is a ____.

71. The special criteria that can be used in queries are ____.

72. The format for a label is displayed in the prototype label box when using the ____.

73. The default join type for table relationships in access is a(n) ____ join.

74. The data type that allows both sequential and random numbering is the ____ data type.

75. The comparison operator, < >, is used to insert a condition that means ____.

76. The _____ instructs access to carry out the instructions and display the results.

77. The ____ option in the tab order dialog box allows a tab order of left-to-right or top-to-bottom.

78. The ____ operator allows you to search for a range of values in one field.

79. Tables queries and forms are examples of access ____

80. You create a macro in access by entering a specific series of actions in the ____ window.

81. You can create or modify a table's field names and data types in ________ view.

82. Records may be added to a table by using the ___________.

83. Query design view presents the fields you can use for a query in small windows called field ____.

84. Queries based on more than one table, must have a ____ field.

85. Only a field name or an expression may be used for the ____ property in a calculated control.

86. Microsoft access is an example of _____ in an information system.

87. Input ____ are templates that make it easier for users to enter data.

88. In an access table, each row is one ____ in the table.

89. In access, table and field names can be up to ____ characters in length.

90. In a table, a characteristic of the data is called ________.

91. In ____ you cannot update the data, but you can make changes to the layout of the form.

92. If more users move to an access point, this decreases ________.

93. Formatting date/time fields changes only the way data is displayed, not the field ____.

94. Data in a form may only be modified in ____ view.

95. Criteria ____ is the term for rules by which criteria must be entered in a query.

96. Changing the order of fields in a database table is an example of changing a table’s ____.

97. A query based on more than one table is a(n) ____ query

98. A primary key index is indicated when the index property - primary - has a setting of ____.

99. A modem is required for ________________ internet access.

100. A join line is also called a(n) ____ line.