1. In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Correct : A. Microsoft Office button
2. Which of the following is the file extension for an Extensible Markup Language?
Correct : C. XML
3. A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
Correct : C. XSD
4. A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
Correct : D. text
5. A(n) _____ is an image control that displays in the background of a page on a form or report.
Correct : D. watermark
6. Which colors are used to define a custom color?
Correct : B. Red, Green, Blue
7. If a color property contains "#336699", how many blue units are in the color?
Correct : C. 99
8. The _____ function returns a string that has been converted to uppercase text.
Correct : B. UCase
9. Which part of the IIF expression is the action performed if the true condition exists?
Correct : C. second
10. If you need a calculation in an unbound control, you can create a custom _____.
Correct : B. expression
11. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
Correct : A. Color
12. Which function evaluates a "true/false" expression and then performs one of two actions?
Correct : C. IIF
13. When adding an image, which size mode will change the height or width of the image fit the control?
Correct : B. Stretch
14. The three parts of an IIF function are separated by _____.
Correct : D. commas
15. A Smart Tag can be set using the _____ tab in the property sheet.
Correct : D. Data
16. A(n) _____ is a control that, when clicked, executes an action or series of actions.
Correct : D. command button
17. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
Correct : A. txt
18. How can a user open the Expression Builder dialog box?
Correct : D. By clicking the Build button of the Control Source property in the Data tab
19. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
Correct : A. cbo
20. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
Correct : C. Form Header
21. The Allow _____ property controls whether new records can be added through the form.
Correct : A. Additions
22. The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
Correct : A. Date
23. The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
Correct : C. Financial
24. Which of the following is NOT true about background images?
Correct : C. They do not print when a form or a report is print
25. In a query, what symbol is used to surround a parameter\'s user prompt?
Correct : A. [ ]
26. A(n) _______________ query locates data from one or more tables.
Correct : A. select
27. Which function extracts the name of the month from a date/time value?
Correct : B. MonthName
28. Which of the following queries prompts users for input data by displaying dialog boxes?
Correct : C. Parameter
29. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
Correct : D. action
30. Which of the following queries modifies fields not records?
Correct : D. Update
31. A summary query can be created by adding which row to the design grid of a select query?
Correct : D. Total
32. Which of the following functions is used to all the values in a numeric field?
Correct : B. Count
33. Which of the following queries can create a table?
Correct : C. Make-Table
34. In a query, which row do you need to place wildcards to affect a parameter?
Correct : B. Criteria
35. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Correct : C. 24
36. Which of the following types of joins displays records with the same value in the common field?
Correct : A. Inner join
37. A global join will be created automatically when using tables in a(n) _____.
Correct : B. report
38. Which of the following is the default join between two recordsets?
Correct : A. Inner join
39. In a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
Correct : B. The relationship between the two tables locally
40. What is an index?
Correct : C. A sort order for records, which is identified in the table design
41. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
Correct : C. 60
42. Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
Correct : A. Edit Relationships
43. In a junction table, the _____ field consists of the foreign key from both the linked tables.
Correct : C. foreign key
44. What does an inner join display?
Correct : C. Records that have the same value in the common field
45. The page count of a report can be determined by clicking the _______ button.
Correct : D. Last Page
46. When you add fields in ____, a Field List pane displays.
Correct : B. Layout View
47. Any report, including a basic report, can be modified in __.
Correct : B. Layout View
48. A ____ often display summary data such as totals or counts.
Correct : B. Group Footer
49. Which of the following can a Report Wizard NOT do?
Correct : C. Group fields into more than one Control Layout
50. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
Correct : B. Layout View
51. Which report section prints once at the bottom of every printed page?
Correct : C. Page Footer
52. Which report section only prints one time at the end of the report?
Correct : C. Report Footer
53. Which of the following database objects can have more than one Group Header/Footer section?
Correct : C. Reports
54. Which of the following statements about the Label Wizard is NOT true?
Correct : A. Adding groups can help organize the labels.
55. Which of the following views enables users to create and modify the sections of a form?
Correct : B. Design
56. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Correct : D. Tabular
57. Which Form tool creates a new form that show both a form and datasheet views?
Correct : D. Split Form
58. Which of the following statements about tab order setting is NOT true?
Correct : C. The tab order setting is usually right-to-left and top-to-bottom.
59. What type of controls are text boxes when data from the recordset is visible?
Correct : B. Bound
60. When increasing the Control Padding, space is added where?
Correct : B. Between all controls
61. Which of the following is NOT possible when printing Forms?
Correct : A. Print page 1, 3, and 5
62. To apply an AutoFormat to an entire Form, what must you select first?
Correct : A. Form Selector
63. Which is NOT an option of the Picture Size Mode property?
Correct : B. Fit
64. Which mode sizes an image to fit the control while maintaining the proportions of the original image?
Correct : D. Zoom
65. Which of the following views is used to graphically summarize and analyze data in a recordset?
Correct : C. PivotChart
66. Which of the following statements about criteria in a query is NOT true?
Correct : C. Criteria cannot be specified as an expression.
67. Which of the following statements does NOT hold true for the Top Values property?
Correct : A. The Top Values property displays only the highest values from the query.
68. Which of the following statements about calculated fields is NOT true?
Correct : C. Data contained in a calculated field is created the first time a query is run.
69. Using the keyword _______________ will return records in which the field value equals a defined text.
Correct : C. Like
70. What is the process of eliminating redundant fields by separating data into tables called?
Correct : C. Normalization
71. Which of the following statements about PivotChart View is NOT true?
Correct : D. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.
72. Which of the following search criteria is invalid?
Correct : A. $45*
73. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Correct : A. Between
74. Which of the following database objects extracts information from one or more tables or queries?
Correct : B. Queries
75. Referential integrity cannot be set for _______________ relationships.
Correct : B. Indeterminate
76. A relationship is created between how many tables?
Correct : B. Two
77. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
Correct : A. primary, foreign
78. Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Correct : D. tables
79. In the Relationship window, related fields from each table are connected by a(n) _______________.
Correct : D. join line
80. Relationships between tables can be graphically viewed in the _______________ window.
Correct : C. Relationships
81. A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
Correct : D. None
82. In the Field List of a table, the primary key appears _______________.
Correct : D. with key icon
83. What type of relationship is created when you select a primary key in both related tables?
Correct : A. One-To-One
84. The Table _______________ Wizard analyzes a database and recommends changes for normalization.
Correct : A. Analyzer
85. The Input Mask wizard does NOT include the ability to do which of the following?
Correct : A. Force all uppercase
86. Which of the following field properties enforces the use of parentheses when keying an area code?
Correct : C. Input Mask
87. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Correct : D. Validation Rule
88. In Datasheet View, what appears at the top of each column?
Correct : C. Field name
89. Which is NOT a method of creating a table?
Correct : C. Layout View
90. Which of the following views displays the field name, description, and properties of a table?
Correct : B. Design View
91. Which of the following properties identifies the type of information stored in a field?
Correct : A. Data type
92. Which of the following field properties displays a model or pattern for entering data?
Correct : C. Input Mask
93. Which of the following data types automatically generates a consecutive number?
Correct : A. Autonumber
94. Database properties do NOT include ___________.
Correct : D. size
95. To remove all Sorts in a table you can click the ______ command.
Correct : A. Clear All Sorts
96. A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
Correct : C. aggregate function
97. The content and application of the Search tool CANNOT be retained when you ______.
Correct : D. close an object
98. The Search tool CANNOT be used on which major Access object?
Correct : C. Reports
99. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Correct : D. record
100. The ______ is a wild card that represents one or more characters.