Basic Access MCQ
1. When referencing field names within an expression, surround the field name with ____.
Correct Answer:
(parentheses)
Note: This Question is unanswered, help us to find answer for this one
2. Interim testing normally occurs between the ____ and the ____.
Correct Answer:
Beginning of the year under audit; date of the financial statements
Note: This Question is unanswered, help us to find answer for this one
3. Use the field properties pane to create an index for ____.
Correct Answer:
A single field
Note: This Question is unanswered, help us to find answer for this one
4. Vba procedures are created, modified, and displayed in the ____ window.
Correct Answer:
Code
Note: This Question is unanswered, help us to find answer for this one
5. To edit an existing relationship, a user will need to right-click on the ________ line.
Correct Answer:
Join
Note: This Question is unanswered, help us to find answer for this one
6. With a dutch flower auction, ______.
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
7. The trading bloc consisting of 28 trading partners in europe is the ____.
Correct Answer:
European Union
Note: This Question is unanswered, help us to find answer for this one
8. A(n) ____ is a series of actions that access performs when a particular event occurs.
Correct Answer:
Macro
Note: This Question is unanswered, help us to find answer for this one
9. A(n) ____ is a temporary view of the data that is removed when you close the datasheet.
Correct Answer:
Filter
Note: This Question is unanswered, help us to find answer for this one
10. To open the navigation pane, tap or click the ____ button.
Correct Answer:
Shutter Bar Open/Close.
Note: This Question is unanswered, help us to find answer for this one
11. Validation rules are entered in the ____
Correct Answer:
Field Properties pane
Note: This Question is unanswered, help us to find answer for this one
12. To resize an image without changing its proportions, simply drag ____ of the image.
Correct Answer:
Any Corner
Note: This Question is unanswered, help us to find answer for this one
13. Deleting a record in a form will also delete it from the underlying ________.
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
14. The report footer section prints ____.
Correct Answer:
Once for every record
Note: This Question is unanswered, help us to find answer for this one
15. Access does not support the ____ data type.
Correct Answer:
CREATE TABLE.
Note: This Question is unanswered, help us to find answer for this one
16. To avoid the display of a security warning when opening a database, place the database ____.
Correct Answer:
In a trusted folder.
Note: This Question is unanswered, help us to find answer for this one
17. When you create a report using the reports button, access generates the report using a ____ layout.
Correct Answer:
Tabular
Note: This Question is unanswered, help us to find answer for this one
18. ____ shows the form on the screen and allows you to use the form to update data.
Correct Answer:
Form view
Note: This Question is unanswered, help us to find answer for this one
19. A criterion may be negated by using the ____ logical operator.
Correct Answer:
Not
Note: This Question is unanswered, help us to find answer for this one
20. Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.
Correct Answer:
Special Effect
Note: This Question is unanswered, help us to find answer for this one
21. To save a query, click the save button on the ____.
Correct Answer:
Quick Access Toolbar
Note: This Question is unanswered, help us to find answer for this one
22. To find duplicate records in a table, use the _____ query wizard.
Correct Answer:
Find Duplicates
Note: This Question is unanswered, help us to find answer for this one
23. The layout view or the design view may be used to create a ____ form.
Correct Answer:
Custom
Note: This Question is unanswered, help us to find answer for this one
24. When you assign a ____ to a field access
Correct Answer:
Caption
Note: This Question is unanswered, help us to find answer for this one
25. In sql server, you can use the ____ function to obtain today?s date.
Correct Answer:
DATE()
Note: This Question is unanswered, help us to find answer for this one
26. In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.
Correct Answer:
Layout
Note: This Question is unanswered, help us to find answer for this one
27. File names cannot contain a(n) ____
Correct Answer:
Question mark ( )
Note: This Question is unanswered, help us to find answer for this one
28. Use the ____ command to save the current object with a new name.
Correct Answer:
Save As
Note: This Question is unanswered, help us to find answer for this one
29. In addition to standard colors, the font color gallery displays ____ colors.
Correct Answer:
Theme
Note: This Question is unanswered, help us to find answer for this one
30. If you open a field list and the tables do not appear in the field list, click ____.
Correct Answer:
Show all tables
Note: This Question is unanswered, help us to find answer for this one
31. The ____ section appears at the bottom of the form and often is empty.
Correct Answer:
Form Footer
Note: This Question is unanswered, help us to find answer for this one
32. Microsoft access can best be described as ____ software.
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
33. In crosstab query results, the value of a checked yes/no data type field will display as ____.
Correct Answer:
-1
Note: This Question is unanswered, help us to find answer for this one
34. A calculated field created in a query generates results when ____.
Correct Answer:
When the query is run
Note: This Question is unanswered, help us to find answer for this one
35. Statistical information such as totals and averages is calculated using ____.
Correct Answer:
Aggregate functions
Note: This Question is unanswered, help us to find answer for this one
36. To specify that a field is to be required, change the value for the _____ property from no to yes.
Correct Answer:
Required
Note: This Question is unanswered, help us to find answer for this one
37. To sort records based on the selected field in the order z to a, use the _____ button.
Correct Answer:
Descending
Note: This Question is unanswered, help us to find answer for this one
38. To remove a total row that appears in a datasheet, click the ____ button on the home tab.
Correct Answer:
Totals
Note: This Question is unanswered, help us to find answer for this one
39. To print two records from a form, select the ____ option in the print dialog box.
Correct Answer:
Selected Page(s)
Note: This Question is unanswered, help us to find answer for this one
40. To move from layout view to form view, click the ____ button on the access status bar.
Correct Answer:
Form view
Note: This Question is unanswered, help us to find answer for this one
41. To modify a report while viewing actual report data, use the ____ view.
Correct Answer:
Layout
Note: This Question is unanswered, help us to find answer for this one
42. To display a field list in design view, click the ____ button on the form design tools design tab.
Correct Answer:
Add existing fields
Note: This Question is unanswered, help us to find answer for this one
43. To create a table in design view, click the ____ button on the create tab.
Correct Answer:
Table Design
Note: This Question is unanswered, help us to find answer for this one
44. To create a form using the form tool, click the ____ button in the forms group on the create tab.
Correct Answer:
Form
Note: This Question is unanswered, help us to find answer for this one
45. To change the report margins, click the margins button on the report design tools ____ tab.
Correct Answer:
PAGE SETUP
Note: This Question is unanswered, help us to find answer for this one
46. The value of a field containing no information is a ____ value.
Correct Answer:
Null
Note: This Question is unanswered, help us to find answer for this one
47. The line tool is accessed using the more button in the ____ group on the design tab.
Correct Answer:
Controls
Note: This Question is unanswered, help us to find answer for this one
48. The contents of the ____ section are printed before the records in a particular group.
Correct Answer:
Group header
Note: This Question is unanswered, help us to find answer for this one
49. One way to create a table, is to click ____ on the ribbon and then click the table button.
Correct Answer:
Create
Note: This Question is unanswered, help us to find answer for this one
50. You have a microsoft account if you use any of the following except ____.
Correct Answer:
A paid stand-alone copy of Microsoft Office
Note: This Question is unanswered, help us to find answer for this one
51. When you display objects in ____ windows, each database object appears in its own window.
Correct Answer:
Overlapping
Note: This Question is unanswered, help us to find answer for this one
52. When you change the font color using the ribbon, you click the ____ button.
Correct Answer:
Font color
Note: This Question is unanswered, help us to find answer for this one
53. When the sort field data for each record in a database is different, the sort field is ____.
Correct Answer:
Unique
Note: This Question is unanswered, help us to find answer for this one
54. When access opens a form or report, the ____ event occurs.
Correct Answer:
Load
Note: This Question is unanswered, help us to find answer for this one
55. With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.
Correct Answer:
Combo box
Note: This Question is unanswered, help us to find answer for this one
56. The group header section prints ____.
Correct Answer:
Before every group of records
Note: This Question is unanswered, help us to find answer for this one
57. Field names ____.
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
58. You can include ____ in calculations to indicate which calculation should be done first
Correct Answer:
Parentheses ( )
Note: This Question is unanswered, help us to find answer for this one
59. Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?
Correct Answer:
Reserved words
Note: This Question is unanswered, help us to find answer for this one
60. What does the expression Now() evaluate to?
Correct Answer:
The current system date and time
Note: This Question is unanswered, help us to find answer for this one
61. Which combo box property defines what values appear when the user clicks the drop-down arrow?
Correct Answer:
Row Source
Note: This Question is unanswered, help us to find answer for this one
62. How can you run a submacro saved in a macro?
Correct Answer:
Use a RunMacro or OnError macro action.
Note: This Question is unanswered, help us to find answer for this one
63. When would you use a left join query?
Correct Answer:
When you want to retrieve every record from the left table, plus any matching information from the right table where it exists
Note: This Question is unanswered, help us to find answer for this one
64. Which section of a report appears at the top of every page in the printed report?
Correct Answer:
Page header
Note: This Question is unanswered, help us to find answer for this one
65. The expression values <=, <>, and > are found in what expression category?
Correct Answer:
Comparison operators
Note: This Question is unanswered, help us to find answer for this one
66. Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?
Correct Answer:
ControlTip Text
Note: This Question is unanswered, help us to find answer for this one
67. 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?
Correct Answer:
Caption
Note: This Question is unanswered, help us to find answer for this one
68. When backing up an Access database, what is added to the file name automatically?
Correct Answer:
The current date, such as "_2019-08-21"
Note: This Question is unanswered, help us to find answer for this one
69. 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?
Correct Answer:
Table Analyzer Wizard
Note: This Question is unanswered, help us to find answer for this one
70. How can you ensure that each value saved in a particular field is unique from all other values in the field?
Correct Answer:
Set the Indexed property to Yes (No Duplicates)
Note: This Question is unanswered, help us to find answer for this one
71. Which data type is a modern replacement for the OLE Object data type?
Correct Answer:
Attachment
Note: This Question is unanswered, help us to find answer for this one
72. The display for numerical data defaults to a **_alignment, and text data defaults to **_aligntment
Correct Answer:
Right; left
Note: This Question is unanswered, help us to find answer for this one
73. What program flow function evaluates a condition and either returns a truepart or a falsepart?
Correct Answer:
IIf()
Note: This Question is unanswered, help us to find answer for this one
74. When you add a group to a report, what automatically gets added to the structure?
Correct Answer:
A group header
Note: This Question is unanswered, help us to find answer for this one
75. 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?
Correct Answer:
Before Change
Note: This Question is unanswered, help us to find answer for this one
76. What tool builds a report containing detailed information about the object in the database?
Correct Answer:
Database documenter
Note: This Question is unanswered, help us to find answer for this one
77. In Design view, which area of a form is the primary location for text boxes, buttons, and other control objects?
Correct Answer:
Detail section
Note: This Question is unanswered, help us to find answer for this one
78. You want a form to appear automatically, whenever the database starts. How do you do this?
Correct Answer:
Open the form you want to display automatically in Design view. Then in the property sheet, set Open on Launch to true
Note: This Question is unanswered, help us to find answer for this one
79. In Access Option > Current Database, what does turning off the Allow Full Menus option do?
Correct Answer:
Removes the Design view contextual tabs, which forces most design changes to be made in Layout view
Note: This Question is unanswered, help us to find answer for this one
80. What currency format displays a thousand separator, but not a currency symbol, such as $ or €?
Correct Answer:
Standard
Note: This Question is unanswered, help us to find answer for this one
81. What kind of query will display data with both column headers and row headers?
Correct Answer:
Crosstab
Note: This Question is unanswered, help us to find answer for this one
82. The relationship field in this table has been created with what feature?
Correct Answer:
Lookup
Note: This Question is unanswered, help us to find answer for this one
83. 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?
Correct Answer:
Group on month number, then sort on month number
Note: This Question is unanswered, help us to find answer for this one
84. What is the Access string operator that joins or concatenates text strings together?
Correct Answer:
&
Note: This Question is unanswered, help us to find answer for this one
85. Which form view mode allows you to preview live data while you work on the design of the form?
Correct Answer:
Layout view
Note: This Question is unanswered, help us to find answer for this one
86. The ____ lists macro actions organized by type.
Correct Answer:
Action Catalog
Note: This Question is unanswered, help us to find answer for this one
87. Controls placed in the ____ form section print only once at the top of the printout.
Correct Answer:
Form Header
Note: This Question is unanswered, help us to find answer for this one
88. Before applying a conditional format in a report, the ____ box must be selected.
Correct Answer:
Field value
Note: This Question is unanswered, help us to find answer for this one
89. A(n) ________ is used to change settings such as formatting and captions.
Correct Answer:
Property sheet
Note: This Question is unanswered, help us to find answer for this one
90. A(n) ____ layout arranges controls vertically with the labels to the left of the control.
Correct Answer:
Tabular
Note: This Question is unanswered, help us to find answer for this one
91. A(n) ____ is a saved object within the datasheet.
Correct Answer:
Query
Note: This Question is unanswered, help us to find answer for this one
92. A file created in ____ is called a database and has an .accdb extension.
Correct Answer:
Access
Note: This Question is unanswered, help us to find answer for this one
93. A calculated field is formatted using the ____ for the field
Correct Answer:
Property Sheet
Note: This Question is unanswered, help us to find answer for this one
94. A ________ query is used to summarize data organized by field values.
Correct Answer:
Grouping
Note: This Question is unanswered, help us to find answer for this one
95. A _____ view shows the content of multiple records on one page.
Correct Answer:
List
Note: This Question is unanswered, help us to find answer for this one
96. The autofilter sort method works on a(n)____ field(s).
Correct Answer:
Single
Note: This Question is unanswered, help us to find answer for this one
97. The _____ data type is compatible with number.
Correct Answer:
SMALLINT
Note: This Question is unanswered, help us to find answer for this one
98. Microsoft access 2016 can best be described as ____ software.
Correct Answer:
Database
Note: This Question is unanswered, help us to find answer for this one
99. Two of the basic forms of sales promotion are ____ sales promotion and ____ sales promotion.
Correct Answer:
Trade-market; consumer-market
Note: This Question is unanswered, help us to find answer for this one
100. ________ advertising is used when introducing a new product.
Correct Answer:
Informative
Note: This Question is unanswered, help us to find answer for this one
101. Referential integrity prevents the creation of ____ records.
Correct Answer:
Orphan
Note: This Question is unanswered, help us to find answer for this one
102. Date criteria are automatically enclosed in ____ when entered in a query design.
Correct Answer:
Number signs
Note: This Question is unanswered, help us to find answer for this one
103. Access uses ____ as the source program to create a graph when the chart wizard is used.
Correct Answer:
Microsoft Graph
Note: This Question is unanswered, help us to find answer for this one
104. ____ is the default entry for each field in the total row of the query design grid.
Correct Answer:
Group By
Note: This Question is unanswered, help us to find answer for this one
105. When creating a query using the query design command, first you must ____________.
Correct Answer:
Select the table(s) you want to get criteria from
Note: This Question is unanswered, help us to find answer for this one
106. To show the navigation pane if it is hidden, click the ____ button.
Correct Answer:
Shutter Bar Open/Close
Note: This Question is unanswered, help us to find answer for this one
107. To save the changes to the layout of a table, tap or click the save button on the ____.
Correct Answer:
Quick Access Toolbar
Note: This Question is unanswered, help us to find answer for this one
108. To include the total row in the design grid, click the ____ button on the design tab.
Correct Answer:
Totals
Note: This Question is unanswered, help us to find answer for this one
109. Billboard advertising is most effective for __________ advertising
Correct Answer:
Reinforcement
Note: This Question is unanswered, help us to find answer for this one
110. When you double-click a field in a field list in query design view, it is ____.
Correct Answer:
Added to the next available position in the query design grid
Note: This Question is unanswered, help us to find answer for this one
111. New records can be added to an access table in either datasheet view or ____ view.
Correct Answer:
Form
Note: This Question is unanswered, help us to find answer for this one
112. A summary query calculates statistics about ____.
Correct Answer:
Groups of records
Note: This Question is unanswered, help us to find answer for this one
113. A report formatted where the page is taller than it is wide is formatted in ____.
Correct Answer:
Portrait orientation
Note: This Question is unanswered, help us to find answer for this one
114. The _____ function returns the current system date in ms access.
Correct Answer:
DATE()
Note: This Question is unanswered, help us to find answer for this one
115. A(n) ________ is the data used by a function to produce a result.
Correct Answer:
Argument.
Note: This Question is unanswered, help us to find answer for this one
116. To place a subform on a form, use the subform/subreport tool on the ____ tab.
Correct Answer:
FORM DESIGN TOOLS DESIGN
Note: This Question is unanswered, help us to find answer for this one
117. Another name for an input in a function is a(n) ________.
Correct Answer:
Argument
Note: This Question is unanswered, help us to find answer for this one
118. Access is a ____.
Correct Answer:
Database management system;
Note: This Question is unanswered, help us to find answer for this one
119. The special criteria that can be used in queries are ____.
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
120. The format for a label is displayed in the prototype label box when using the ____.
Correct Answer:
Label Wizard
Note: This Question is unanswered, help us to find answer for this one
121. The default join type for table relationships in access is a(n) ____ join.
Correct Answer:
Inner
Note: This Question is unanswered, help us to find answer for this one
122. The data type that allows both sequential and random numbering is the ____ data type.
Correct Answer:
AutoNumber
Note: This Question is unanswered, help us to find answer for this one
123. The comparison operator, < >, is used to insert a condition that means ____.
Correct Answer:
Not equal to
Note: This Question is unanswered, help us to find answer for this one
124. The _____ instructs access to carry out the instructions and display the results.
Correct Answer:
Run command
Note: This Question is unanswered, help us to find answer for this one
125. The ____ option in the tab order dialog box allows a tab order of left-to-right or top-to-bottom.
Correct Answer:
Auto Order
Note: This Question is unanswered, help us to find answer for this one
126. The ____ operator allows you to search for a range of values in one field.
Correct Answer:
Between
Note: This Question is unanswered, help us to find answer for this one
127. Tables queries and forms are examples of access ____
Correct Answer:
Objects
Note: This Question is unanswered, help us to find answer for this one
128. You create a macro in access by entering a specific series of actions in the ____ window.
Correct Answer:
Macro Builder
Note: This Question is unanswered, help us to find answer for this one
129. You can create or modify a table's field names and data types in ________ view.
Correct Answer:
Design
Note: This Question is unanswered, help us to find answer for this one
130. Records may be added to a table by using the ___________.
Correct Answer:
Datasheet View
Note: This Question is unanswered, help us to find answer for this one
131. Query design view presents the fields you can use for a query in small windows called field ____.
Correct Answer:
Lists.
Note: This Question is unanswered, help us to find answer for this one
132. Queries based on more than one table, must have a ____ field.
Correct Answer:
Common.
Note: This Question is unanswered, help us to find answer for this one
133. Only a field name or an expression may be used for the ____ property in a calculated control.
Correct Answer:
Control Source
Note: This Question is unanswered, help us to find answer for this one
134. Input ____ are templates that make it easier for users to enter data.
Correct Answer:
Masks
Note: This Question is unanswered, help us to find answer for this one
135. In an access table, each row is one ____ in the table.
Correct Answer:
Record
Note: This Question is unanswered, help us to find answer for this one
136. In access, table and field names can be up to ____ characters in length.
Correct Answer:
64
Note: This Question is unanswered, help us to find answer for this one
137. In a table, a characteristic of the data is called ________.
Correct Answer:
Field
Note: This Question is unanswered, help us to find answer for this one
138. In ____ you cannot update the data, but you can make changes to the layout of the form.
Correct Answer:
Layout view
Note: This Question is unanswered, help us to find answer for this one
139. If more users move to an access point, this decreases ________.
Correct Answer:
Individual throughput
Note: This Question is unanswered, help us to find answer for this one
140. Formatting date/time fields changes only the way data is displayed, not the field ____.
Correct Answer:
Values
Note: This Question is unanswered, help us to find answer for this one
141. Data in a form may only be modified in ____ view.
Correct Answer:
Form
Note: This Question is unanswered, help us to find answer for this one
142. Criteria ____ is the term for rules by which criteria must be entered in a query.
Correct Answer:
Syntax
Note: This Question is unanswered, help us to find answer for this one
143. Changing the order of fields in a database table is an example of changing a table’s ____.
Correct Answer:
Structure
Note: This Question is unanswered, help us to find answer for this one
144. A query based on more than one table is a(n) ____ query
Correct Answer:
Multitable
Note: This Question is unanswered, help us to find answer for this one
145. A primary key index is indicated when the index property - primary - has a setting of ____.
Correct Answer:
Yes
Note: This Question is unanswered, help us to find answer for this one
146. A modem is required for ________________ internet access.
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
147. A join line is also called a(n) ____ line.
Correct Answer:
Link
Note: This Question is unanswered, help us to find answer for this one
148. A field with a yes/no data type can store only one of two values. the choices are ____.
Correct Answer:
a,c,d
Note: This Question is unanswered, help us to find answer for this one
149. A field whose data type is ____ can store text that can be used as a hyperlink address
Correct Answer:
Hyperlink
Note: This Question is unanswered, help us to find answer for this one
150. A field whose data type is ____ can contain any characters.
Correct Answer:
Short Text
Note: This Question is unanswered, help us to find answer for this one
151. A field used to connect one table logically with another table is called a ____ field.
Correct Answer:
Common
Note: This Question is unanswered, help us to find answer for this one
152. A field in an access database table that has no value is determined by access to have a ____ value.
Correct Answer:
Null
Note: This Question is unanswered, help us to find answer for this one
153. Which of the following is NOT possible when you link to an Excel worksheet from within Access?
Correct Answer:
You can append data to an existing table.
Note: This Question is unanswered, help us to find answer for this one
154. What can you do in Report View that you cannot do in Print Preview in Microsoft Access 2010 Reports?
Correct Answer:
You can Filter, Copy, Search, etc.
Note: This Question is unanswered, help us to find answer for this one
155. Which of the following conditions should be satisfied to create a one-to-one relationship between tables?
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
156.
This question is based upon the figure shown below
Correct Answer:
Access displays numbers as Access displays numbers as
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
157. Which of the following is not true regarding Information Rights Management (IRM) for e-mail messages in Microsoft Access 2010?
Correct Answer:
It restricts the e-mail content from being copied by using third-party screen-capture programs.
Note: This Question is unanswered, help us to find answer for this one
158. Which text box property in Microsoft Access 2010 Reports allows the text box to be expanded so that all the text can be fit into it?
Correct Answer:
CanGrow
Note: This Question is unanswered, help us to find answer for this one
159.
This question is based upon the figure shown below
Correct Answer:
unit;name
Note: This Question is unanswered, help us to find answer for this one
160. Suppose you want to use data from two tables in a query: tblCustomer and tblOrder. The two tables both have a field, CustomerID, that identifies a customer. Each record in the tblCustomer table may have one or more corresponding records in the tblOrder table, and the corresponding values can be determined by values in the CustomerID field. You now want to join the tables so that the query combines the records from the tables, excluding records from either table if there is no corresponding record in the other table. Which of the following FROM clauses will you use?
Correct Answer:
FROM [tblCustomer] INNER JOIN [tblOrder] ON [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
Note: This Question is unanswered, help us to find answer for this one
161. When you run the Compatibility Checker in Microsoft Access 2010, in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
162. Using the Package and Sign tool, how many databases can you add to a package that you want to distribute to other users in Microsoft Access?
Correct Answer:
1
Note: This Question is unanswered, help us to find answer for this one
163. Which of the following is true of the Ribbon interface?
Correct Answer:
Ribbons can be minimized or collapsed.
Note: This Question is unanswered, help us to find answer for this one
164. Which of the following statements is not true about the Work Offline option in an Access database linked to SharePoint?
Correct Answer:
Within Microsoft Access, data is visible to only those users who have permission to view it on SharePoint.
Note: This Question is unanswered, help us to find answer for this one
165. Microsoft Access 2010 does not support more than ____________ fields in a table.
Correct Answer:
255
Note: This Question is unanswered, help us to find answer for this one
166. Which textbox property in Microsoft Access 2010 determines that the text box is bound, unbound or calculated?
Correct Answer:
ControlSource
Note: This Question is unanswered, help us to find answer for this one
167.
This question is based upon the figure shown below
Correct Answer:
This command executes an action one at a time.
Note: This Question is unanswered, help us to find answer for this one
168. Which of the following are reserved for use by SharePoint and is not supported on the Web?
Correct Answer:
Solutions
Docs
Lists
UserInfo
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
169. Which of the following is correct regarding Crosstab queries?
Correct Answer:
Multiple Row headings can be specified.
Note: This Question is unanswered, help us to find answer for this one
170. What is the purpose of Option Explicit?
Correct Answer:
Requires variable declarations.
Note: This Question is unanswered, help us to find answer for this one
171. How do you start a Microsoft Access application so that the user can't see or use the Navigation Pane (or database container)?
Correct Answer:
Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11.
Note: This Question is unanswered, help us to find answer for this one
172. Password protected databases offer:
Correct Answer:
Only one password with full rights.
Note: This Question is unanswered, help us to find answer for this one
173. What is the purpose of the Application Parts option in Microsoft Access 2010?
Correct Answer:
It turns portions of your database into reusable templates.
Note: This Question is unanswered, help us to find answer for this one
174. Which of the following is true about a.accde file in Microsoft Access 2010?
Correct Answer:
It contains compiled VBA code to prevent users from viewing the code.
Note: This Question is unanswered, help us to find answer for this one
175.
This question is based upon the figure shown below
Correct Answer:
It allows users to preview how a formatting option will appear.
Note: This Question is unanswered, help us to find answer for this one
176.
This question is based upon the figure shown below
Correct Answer:
CREATE TABLE Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)
Note: This Question is unanswered, help us to find answer for this one
177. How do you create a report for a Crosstab Query if certain column values are missing?
Correct Answer:
Set the Pivot list in the Crosstab.
Note: This Question is unanswered, help us to find answer for this one
178. In a report with grouping, how can you display the count of records in each group?
Correct Answer:
Add a text box to the group's footer section and set its control source to =Count(*).
Note: This Question is unanswered, help us to find answer for this one
179. How can you share common objects between multiple projects in Microsoft Access 2010?
Correct Answer:
By creating Application Parts.
Note: This Question is unanswered, help us to find answer for this one
180. Suppose you have a table named Cars with fields that store the name, year, price, and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?
Correct Answer:
CREATE INDEX YearIndex ON Cars (Year)
Note: This Question is unanswered, help us to find answer for this one
181.
This question is based upon the figure shown below
Correct Answer:
Delete
Note: This Question is unanswered, help us to find answer for this one
182.
Consider the following tables:
Books
---------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the Popularity of the book on a scale of 1 to 10)
Language(such as French, English, German etc)
What is the query to determine which German books (if any) are more popular than all the French books?
Correct Answer:
Select bookname from books where language='German' and popularityrating > (Select max(popularityrating) from books where language='French')
Note: This Question is unanswered, help us to find answer for this one
183. Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?
Correct Answer:
Input Mask
Note: This Question is unanswered, help us to find answer for this one
184.
This question is based upon the figure shown below
Correct Answer:
Expression Builder will pop up.
Note: This Question is unanswered, help us to find answer for this one
185.
What will be the result of the following?
InStr(1, "John Smith", "S")
Correct Answer:
6
Note: This Question is unanswered, help us to find answer for this one
186. Which form property determines whether the current record has been modified since it was last saved?
Correct Answer:
Dirty property
Note: This Question is unanswered, help us to find answer for this one
187. Which of the following is not a Relationship and Lookup error?
Correct Answer:
A table with more than 220 fields is incompatible with the Web.
Note: This Question is unanswered, help us to find answer for this one
188.
This question is based upon the figure shown below
Correct Answer:
Tabular format
Note: This Question is unanswered, help us to find answer for this one
189. What could be the problem when an error message "#Error" is received in a query?
Correct Answer:
The denominator of a calculated field is zero.
Note: This Question is unanswered, help us to find answer for this one
190. Which of the following Aggregates expressions is not allowed in Query Columns context of a Web database?
Correct Answer:
Like
Note: This Question is unanswered, help us to find answer for this one
191. How can you tell if a report has no records to display or print in Microsoft Access 2010?
Correct Answer:
By using the report's NoData event.
Note: This Question is unanswered, help us to find answer for this one
192. Which feature in Microsoft Access 2010 can be used to ensure consistency in appearance between forms and reports?
Correct Answer:
Office Themes
Note: This Question is unanswered, help us to find answer for this one
193. Microsoft Access uses indexes in a table to find data. Which of the following field types cannot be indexed?
Correct Answer:
OLE Object
Attachment
Calculated
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
194. Which of the following Microsoft Access 2010 components can pose security risks in an untrusted database?
Correct Answer:
Action queries (queries that insert, delete, or change data)
Macros
VBA code
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
195. For what reason(s) can a digital signature or certificate be regarded as invalid?
Correct Answer:
All of the above.
Note: This Question is unanswered, help us to find answer for this one
196. Which of the following is incorrect about the Quick Access Toolbar?
Correct Answer:
Toolbar can be minimized or collapsed.
Note: This Question is unanswered, help us to find answer for this one
197. Which of the following rules apply when you use referential integrity?
Correct Answer:
You cannot delete a record from the primary table if matching records exist in the related table.
You cannot enter a value in the foreign key field of the related table that does not exist in the primary key of the primary table.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
198. A query that uses the BETWEEN operator for two numbers is identical to:
Correct Answer:
>= and <=
Note: This Question is unanswered, help us to find answer for this one
199. Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields, with a space between them.Which of the following expressions will you enter in the Expression Builder?
Correct Answer:
[firstName] &" "& [lastName]
Note: This Question is unanswered, help us to find answer for this one
200. Which of the following describes the Data Execution Prevention (DEP) support for Office applications?
Correct Answer:
It is a hardware and software technology that helps harden the attack surface by preventing viruses and worms that exploit buffer overflow vulnerabilities from running.
Note: This Question is unanswered, help us to find answer for this one
201. Which of the following elements are mandatory for the CREATE INDEX command?
Correct Answer:
All of the above.
Note: This Question is unanswered, help us to find answer for this one
202. What is the advantage of a Class Module versus a Standard Module?
Correct Answer:
Encapsulation, Inheritance
Note: This Question is unanswered, help us to find answer for this one
203. Which one of the following correctly selects rows from the students table that have null in column1?
Correct Answer:
Select * from students where column1 is null
Note: This Question is unanswered, help us to find answer for this one
204. Which of the following functions determines if a phrase exists in a longer string?
Correct Answer:
InStr
Note: This Question is unanswered, help us to find answer for this one
205.
This question is based upon the figure shown below
Correct Answer:
Select lastname from students where lastname like '[A,O, Y]*'
Note: This Question is unanswered, help us to find answer for this one
206. Using which of the following Microsoft Access 2010 database file formats, can we use the Package and Sign tool?
Correct Answer:
.accdb
.accdc
.accde
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
207. Which of the following is not done when you compact a database?
Correct Answer:
Databases linked to the compacted database are compacted and repaired.
Note: This Question is unanswered, help us to find answer for this one
208. If you want to encrypt a database by using a password, then the database must be opened in ________ mode.
Correct Answer:
Open Exclusive
Note: This Question is unanswered, help us to find answer for this one
209. What happens when a user has a database open in Exclusive mode and another user attempts to open it?
Correct Answer:
The second user receives a 'File already in use' message.
Note: This Question is unanswered, help us to find answer for this one
210. What is the purpose of time stamping a digital signature in Microsoft 2010?
Correct Answer:
It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
Note: This Question is unanswered, help us to find answer for this one
211. Which of the following functions returns an array, when a string is split using a delimiter?
Correct Answer:
Split function
Note: This Question is unanswered, help us to find answer for this one
212. A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables.
If the Products table is deleted, what will happen when users run Query1?
Correct Answer:
An error will be generated.
Note: This Question is unanswered, help us to find answer for this one
213. Which of the following table properties defines criteria to display only matching rows in the Datasheet view?
Correct Answer:
ValidationRule
Note: This Question is unanswered, help us to find answer for this one
214. When a report is opened in Design view, which of the following statements is true:
Correct Answer:
Sub-reports contained in the report can be modified in the same window as the parent report.
Note: This Question is unanswered, help us to find answer for this one
215. The Database Splitter is one of the database utilities. Which of the following is true about the Database Splitter?
Correct Answer:
This utility segregates the tables from the queries, forms, reports, macros, modules, and shortcuts to the Data Access Pages
Note: This Question is unanswered, help us to find answer for this one
216. What type of query do you use to modify existing records
Correct Answer:
Update query
Note: This Question is unanswered, help us to find answer for this one
217. Which type of Control Layout does the given picture display?
Correct Answer:
Stacked
Note: This Question is unanswered, help us to find answer for this one
218. On which event do you place code to validate the entry of an entire record?
Correct Answer:
BeforeUpdate
Note: This Question is unanswered, help us to find answer for this one
219. In the given picture, a total is accumulated from record to record across a group. Which feature has been used to achieve this result?
Correct Answer:
Running sum property
Note: This Question is unanswered, help us to find answer for this one
220. State whether true or false.
In Access 2007, a Checkbox cannot be used as a calculated control
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
221. What does an Access Data Projects (ADP) offer that an MDB/ACCDB doesn't?
Correct Answer:
It is tied directly to one SQL Server database and can create and modify SQL Server objects
Note: This Question is unanswered, help us to find answer for this one
222. Which of the following options clears a sort order without affecting the current filter?
Correct Answer:
"Clear All Sorts" button on the Home tab, in the Sort and Filter group.
Note: This Question is unanswered, help us to find answer for this one
223. By using ADO or DAO, how can you fetch the records from a recordset?
Correct Answer:
By using a Do..Loop with MoveNext, while checking for EOF
Note: This Question is unanswered, help us to find answer for this one
224. How many databases can be opened at one time in a single instance of Access 2007?
Correct Answer:
One
Note: This Question is unanswered, help us to find answer for this one
225. How do you import a portion of an Excel spreadsheet into Access?
Correct Answer:
TransferSpreadsheet Method
Note: This Question is unanswered, help us to find answer for this one
226. How do you prevent a user from skipping the startup routines when opening an application?
Correct Answer:
Set the database's AllowBypassKey property to False
Note: This Question is unanswered, help us to find answer for this one
227. You want to create a table that includes a Description field. If you want to ensure that the Description field accepts rich text formatting, which datatypes should you use?
Correct Answer:
Memo
Note: This Question is unanswered, help us to find answer for this one
228. Which datatype would be the most suitable to store a Hyperlink in a field of an Access 2007 table?
Correct Answer:
hyperlink
Note: This Question is unanswered, help us to find answer for this one
229. When does the Switch function return a value that is Null?
Correct Answer:
Both a and b
Note: This Question is unanswered, help us to find answer for this one
230. Which of the following placeholders and literal characters can be used in an input mask?
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
231. How do you customize the text on a form or report's window frame or tab?
Correct Answer:
Caption Property
Note: This Question is unanswered, help us to find answer for this one
232. Which of the following options lets you resize multiple controls at the same time to maximum fitted control size?
Correct Answer:
Select the controls, click on the Arrange tab, and click the "To Widest" button in the Size group
Note: This Question is unanswered, help us to find answer for this one
233. A calculated control may be applied to a field by using:
Correct Answer:
ControlSource
Note: This Question is unanswered, help us to find answer for this one
234. Which of the following is not true regarding naming a file?
Correct Answer:
File names are case sensitive
Note: This Question is unanswered, help us to find answer for this one
235. State whether the following statement is true or false:
By default, Access deletes the related data when records from a table are deleted.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
236. Which of the following is not a section of a report?
Correct Answer:
Summary
Note: This Question is unanswered, help us to find answer for this one
237. Out of the following, which one can be used as a comparison operator?
Correct Answer:
&
Note: This Question is unanswered, help us to find answer for this one
238. State whether true or false.
OLE Object fields cannot be searched.
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
239. Which condition should be satisfied to help create a one-to-one relationship between tables?
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
240. What does an MDB/ACCDB offer that isn't available in an ADP?
Correct Answer:
It can perform heterogeneous queries across a variety of data sources
Note: This Question is unanswered, help us to find answer for this one
241. From Access 2007 you can link to SharePoint and:
Correct Answer:
can view and edit data
Note: This Question is unanswered, help us to find answer for this one
242. Which of the following is the easiest and fastest method to manipulate records on a subform?
Correct Answer:
Using a RecordSetClone Property
Note: This Question is unanswered, help us to find answer for this one
243. Which one of the following correctly selects rows from the table myTable that have null in column1?
Correct Answer:
Select * from myTable where column1 is null
Note: This Question is unanswered, help us to find answer for this one
244. Which of the following clauses is not allowed in a sub-query?
Correct Answer:
order by
Note: This Question is unanswered, help us to find answer for this one
245. In which of the following form sections is a Title control placed?
Correct Answer:
Page Header
Note: This Question is unanswered, help us to find answer for this one
246. Which of the following table views allows editing of records in a table?
Correct Answer:
Datasheet
Note: This Question is unanswered, help us to find answer for this one
247. If you want an image on a report to stay the same size, regardless of the size of the image control, what value should you choose for the Size Mode property?
Correct Answer:
Clip
Note: This Question is unanswered, help us to find answer for this one
248. A query that uses the BETWEEN syntax for two numbers is identical to:
Correct Answer:
>= and <=
Note: This Question is unanswered, help us to find answer for this one
249. What will be the output of the following query in Access 2007?
select 10/0
Correct Answer:
#Error
Note: This Question is unanswered, help us to find answer for this one
250. Which of the following data types does bound text box support?
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
251. Which lookup field property determines the value from the RowSource that is stored in the lookup column?
Correct Answer:
Bound Column
Note: This Question is unanswered, help us to find answer for this one
252. How does a column with the AutoNumber data type make a good primary key?
Correct Answer:
It ensures that no IDs are the same
Note: This Question is unanswered, help us to find answer for this one
253. In Microsoft Access 2016, which of the following options are available when you click on the SharePoint Lists button on the ribbon under the Create tab?
Correct Answer:
Contacts
Emails
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
254. Which of the following statements is/are incorrect regarding DISTINCT keyword in Microsoft Access queries?
Correct Answer:
DISTINCT checks for all the fields in the table that is being queried.
DISTINCT eliminates the duplicate rows.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
255. In Microsoft Access 2016, which of the following statements are correct regarding the Delete query?
Correct Answer:
We can delete all the records with a specific value in a field.
We can delete records that are based on criteria in multiple fields.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
256. While importing data in Microsoft Access 2016 database. which of the following statements is/are incorrect?
Correct Answer:
We cannot change the design of an imported table.
Note: This Question is unanswered, help us to find answer for this one
257. While linking to data in another database in Microsoft Access 2016, which of the following statements is/are correct?
Correct Answer:
Changes to the data in a linked table will affect the source.
Changes to the source data will affect the linked data.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
258. In Microsoft Access 2016, which of the following options are the comparison operators?
Correct Answer:
>
<=
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
259. In Microsoft Access 2016. which of the following operators divides the first number by the second number and returns only the quotient?
Correct Answer:
\
/
^
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
260. With regard to Attachment data type. which of the following kinds of attached files are blocked by Microsoft Access 2016?
Correct Answer:
.mde
.mdw
.mdb
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
261. In relation to Join() function in Microsoft Access 2016, which of the following options is/are the valid parameters of this function?
Correct Answer:
sourcearray
delimiter
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
262. While using a diagram pane in Microsoft Access 2016. which of the given keys can be pressed on the keyboard to remove the selected data column from the query output?
Correct Answer:
Spacebar key
Minus Sign (-) key
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
263. With regard to the functions in Microsoft Access 2016, which of the following options are the valid optional parameters of the Filter function?
Correct Answer:
include
compare
Match
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
264. In Microsoft Access 2016, which of the following functions are related to the Arrays category?
Correct Answer:
Splitf()
UBound()
Join()
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
265. With regard to Val() function in Microsoft Access 2016, which of the following statements is/are correct?
Correct Answer:
var1 = Val(“ 6 45 1
Note: This Question is unanswered, help us to find answer for this one
266. Sam is working with Microsoft Access 2016 database and he wants to store some graphic files in the database with the help of Attachment data type. Which of the following graphic file formats are supported by Access 2016 that can be stored in the database without the need for any additional software?
Correct Answer:
.bmp files
.dib files
.tiff files
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
267. While setting the table properties in a desktop database in Microsoft Access 2016. the Default View property can be set to which of the following options when we open the table?
Correct Answer:
Datasheet
PivotTable
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
268. Which of the following options are the correct logical operators that can be used in Microsoft Access 2016?
Correct Answer:
Xor
And
Or
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
269. With regard to the wildcard patterns in Access 2016. which of the following options are the valid patterns that can be used in expressions?
Correct Answer:
[charList]
[!charLisl]
[Z-A]
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
270. Which of the following keyboard shortcuts can be used in Microsoft Access 2016. if you want to save a database object?
Correct Answer:
Ctrl +S
Shift + F12
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
271. In Microsoft Access 2016. which of the following statements is/are correct for naming a table?
Correct Answer:
A table name can include exclamation point (l), an accent grave O, and brackets ().
A table name cannot begin with leading spaces.
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
272.
What will be the output of the following query in Microsoft Access?
SELECT Company_name
FROM Consumer
INNER JOIN Order ON Consumer.Conle = Order.ConsID;
Correct Answer:
Company_name ANG, Inc. ANG, Inc. ANG, Inc. WBC, Ltd.
Note: This Question is unanswered, help us to find answer for this one
273.
The DDEO function in Microsoft Access 2016 can be used in the ControlSource property of which of the following options?
a)Text box
b)Option group
c)Check box
d)Combo box
Correct Answer:
All options 1, 2, 3, and 4.
Note: This Question is unanswered, help us to find answer for this one
274. When you are using Currency data type in Microsoft Access 2016, the monetary data is stored in the database with how many decimal places of precision?
Correct Answer:
4 decimal places
Note: This Question is unanswered, help us to find answer for this one
275.
In Microsoft Access 2016, which of the following options are the valid parameters of DDESend () function?
1. application
2. topic
3. item
4. data
Correct Answer:
All options 1, 2, 3, and 4.
Note: This Question is unanswered, help us to find answer for this one
276. Suppose you are working with Microsoft Access 2016 and you want to switch from the Edit mode (with)insertion point displayed)to the Navigation mode in a data sheet, which of the following keyboard shortcuts will you use?
Correct Answer:
F2
Note: This Question is unanswered, help us to find answer for this one
277. In Microsoft Access 2016, which of the following options is a correct wildcard character that can be used to match any single numeric character in an expression?
Correct Answer:
#
Note: This Question is unanswered, help us to find answer for this one
278. Which of the following operators is used for matching string values in Access 2016?
Correct Answer:
Like
Note: This Question is unanswered, help us to find answer for this one
279.
While creating reports in Microsoft Access 2016, which of the following types of controls are supported?
1. Bound control
2. Unbound control
3. Calculated control
Correct Answer:
All options 1, 2, and 3.
Note: This Question is unanswered, help us to find answer for this one
280. In Microsoft Access 2016, which of the following is NOT a valid option for Macro Settings under the Trust Center in Access Options?
Correct Answer:
Disable all macros including digitally signed macros.
Note: This Question is unanswered, help us to find answer for this one
281.
The security department of Sam's organization has decided that only digitally signed macros will be allowed in Microsoft Access. Which of the following options is the correct way to restrict the unsigned macros?
Correct Answer:
Go to the File tab -> Click on Options -> Click on Trust Center under the Access Options dialog box -> Click on Trust Center Settings -> Click on Macro Settings -> Select: Disable all macros except digitally signed macros.
Note: This Question is unanswered, help us to find answer for this one
282. in Microsoft Access 2016. which of the following options is the correct operator that raises a number to the power of an exponent?
Correct Answer:
^
Note: This Question is unanswered, help us to find answer for this one
283. In Microsoft Access 2016. which of the following options is the correct operator that returns true when the first value is not equal to the second value?
Correct Answer:
<>
Note: This Question is unanswered, help us to find answer for this one
284. Suppose Diana is working with the Visual Basic Editor in Microsoft Access 2016. If she wants to switch from the Visual Basic Editor back to report Design view, then which of the following keyboard shortcuts will she use?
Correct Answer:
Alt + F11
Note: This Question is unanswered, help us to find answer for this one
285. Suppose you are working with a grid pane in Microsoft Access 2016. If you want to select an entire grid column. then which of the following keyboard shortcuts will you use?
Correct Answer:
Ctrl + Spacebar
Note: This Question is unanswered, help us to find answer for this one
286.
Which of the following options is the correct SQL syntax of the UPDATE query?
Correct Answer:
UPDATE table [join] SET newvalue WHERE criteria
Note: This Question is unanswered, help us to find answer for this one
287. In Microsoft Access 2016. which of the following options is the correct syntax of the CreateObject function?
Correct Answer:
CreateObject ( class [. servername])
Note: This Question is unanswered, help us to find answer for this one
288. In Microsoft Access 2016. which of the following keyboard shortcuts is used to expand or collapse the ribbon?
Correct Answer:
Ctrl + F1
Note: This Question is unanswered, help us to find answer for this one
289.
Choose True or False.
An AutoNumber field in Microsoft Access 2016 database cannot be used as a primary key of a table.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
290. With regard to the Shell function in Microsoft Access 2016, which of the following values of windowstyle argument is used to maximize the window with focus?
Correct Answer:
3
Note: This Question is unanswered, help us to find answer for this one
291. After opening a table in Datasheet View in Microsoft Access 2016 database. which of the following keyboard shortcuts is used to display the Field List pane?
Correct Answer:
Alt+F8
Note: This Question is unanswered, help us to find answer for this one
292.
Which of the following statements is/are correct about using the input masks in Microsoft Access 2016?
1. Input masks do not allow exceptions.
2. Input masks are compatible with the Date Picker control.
Correct Answer:
Only statement 1 is correct.
Note: This Question is unanswered, help us to find answer for this one
293. While using the input masks in Microsoft Access 2016. which of the following characters represents that a user must enter either a space or a character?
Correct Answer:
&
Note: This Question is unanswered, help us to find answer for this one
294. While using the input masks in Microsoft Access 2016. which of the following characters represents that a user can enter a digit, space, plus or minus sign?
Correct Answer:
#
Note: This Question is unanswered, help us to find answer for this one
295. Ethen is working with Microsoft Access 2016 database. If Ethen wants to turn on the Resize mode for the active window (which is not maximized), then which of the following keyboard shortcuts will he use?
Correct Answer:
Ctrl + F8
Note: This Question is unanswered, help us to find answer for this one
296.
In Microsoft Access 2016. Which of the given operators can be used?
1. Is Not Null
2. In
3. Like
4. Between
Correct Answer:
All options 1, 2, 3, and 4.
Note: This Question is unanswered, help us to find answer for this one
297.
Read the following information and identify the correct operator from the given options.
This operator, when used with two numbers. both the numbers are rounded to integers, first number is divided with the second number. and then the result is truncated to an integer.
Correct Answer:
\
Note: This Question is unanswered, help us to find answer for this one
298. In Microsoft Access 2016, which of the following options is the correct operator that divides the first number by the second number and returns only the remainder?
Correct Answer:
Mod
Note: This Question is unanswered, help us to find answer for this one
299. Rocky wants to set relationships between three tables in Microsoft Access 2016 database. Which of the following tabs will he use to set the relationships?
Correct Answer:
Database Tools
Note: This Question is unanswered, help us to find answer for this one
300.
Which of the following options is/are not available in Access apps?
1. A delete query.
2. An update query.
3. An append query.
Correct Answer:
All options 1. 2, and 3.
Note: This Question is unanswered, help us to find answer for this one
301.
In Microsoft Access 2016. which of the given values is returned by the following function?
chr(70)
Correct Answer:
F
Note: This Question is unanswered, help us to find answer for this one
302.
In Microsoft Access 2016, which of the given statements is True about the following operator?
Xor
Correct Answer:
It returns True when either of the two expressions is true, but not both.
Note: This Question is unanswered, help us to find answer for this one
303. With regard to the interval argument of the DatePart () function, which of the following settings is used to return a weekday?
Correct Answer:
w
Note: This Question is unanswered, help us to find answer for this one
304. In Microsoft Access 2016 database, OLE Object data type is used to store graphs. pictures, or ActiveX objects. What is the maximum size of this data type?
Correct Answer:
1 GB
Note: This Question is unanswered, help us to find answer for this one
305. While working with a report in Design view. which of the following Microsoft Access 2016 keyboard shortcuts can be used to show/hide the Field List pane?
Correct Answer:
Alt + F8
Note: This Question is unanswered, help us to find answer for this one
306.
In the context of UBoundO function in Microsoft Access 2016, consider the following line.
Dim B(1 T0100. 0 To 3, -3 To 4)
Which of the following values will be returned by the function UBound(B, 2)?
Correct Answer:
3
Note: This Question is unanswered, help us to find answer for this one
307.
Consider the given tables and answer the question that follows.
What will be the output of the following query in Microsoft Access?
SELECT DISTINCTROW Company_name
FROM Consumer
INNER JOIN Order ON Consumer.Conle = Order.Conle;
Correct Answer:
Company_name ANG, Inc. ANG. Inc. WBC, Ltd.
Note: This Question is unanswered, help us to find answer for this one
308. In Microsoft Access 2016. what is the size of the Large Number data type?
Correct Answer:
8 bytes
Note: This Question is unanswered, help us to find answer for this one
309.
In Microsoft Access 2016, which of the following dates is returned by the following function?
DateSeriaI(2016 -10, 7 - 3.1 - 1)
Correct Answer:
Mar 31, 2006
Note: This Question is unanswered, help us to find answer for this one
310. While working with the datasheet in Microsoft Access 2016 database, which of the following keyboard shortcuts is used to insert the current time in a datasheet?
Correct Answer:
Ctrl+$hift+CoIon (z)
Note: This Question is unanswered, help us to find answer for this one
311.
Which of the following options are the benefits of using relationships in Microsoft Access 2016 database?
1. Consistency
2. Efficiency
3. Comprehensibility
Correct Answer:
All options 1, 2. and 3.
Note: This Question is unanswered, help us to find answer for this one
312. If you are working with the form Design view in Microsoft Access 2016 and want to switch to Form view, which one of the given keyboard shortcuts will you use?
Correct Answer:
F5
Note: This Question is unanswered, help us to find answer for this one
313.
Choose True or False.
In Microsoft Access 2016, a primary key of a table consists of only one field that is used to identify each record uniquely.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
314. While creating a database in Microsoft Access 2016, how many foreign keys can be there in a table?
Correct Answer:
Any number of foreign keys can be there in a table in the database.
Note: This Question is unanswered, help us to find answer for this one
315. With regard to the Shell function in Microsoft Access 2016, which of the following parameters is/are mandatory?
Correct Answer:
Both options a and b are mandatory.
Note: This Question is unanswered, help us to find answer for this one
316. In Microsoft Access 2016, which of the following keyboard shortcuts is used to show or hide the navigation pane?
Correct Answer:
F11
Note: This Question is unanswered, help us to find answer for this one
317. In Microsoft Access 2016, which of the following options can be used as a valid decimal separator in the Val () function?
Correct Answer:
Period (.)
Note: This Question is unanswered, help us to find answer for this one
318. In Microsoft Access 2016, which of the following operators when used with two expressions, returns True if both the expressions are true, or both the expressions are false?
Correct Answer:
Xor
Note: This Question is unanswered, help us to find answer for this one
319.
Choose True or false.
We can edit data in an Excel worksheet by using a linked table in Microsoft Access 2016.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
320.
In Microsoft Access 2016. we can create a table by importing or linking to data stored on different locations. We can import or link to data in which of the following options?
1. A Windows SharePoint Services list.
2. An Excel worksheet.
3. A Microsoft Outlook folder.
4. An XML file.
Correct Answer:
All options 1, 2, 3, and 4.
Note: This Question is unanswered, help us to find answer for this one
321.
In an Access app. which of the following aggregate functions cannot be used?
1. Avg
2. Count
3. StDev
4. VarP
Correct Answer:
All options 1. 2, 3. and 4.
Note: This Question is unanswered, help us to find answer for this one
322.
Choose True or False.
We can create a parameter query in an Access app.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
323. In Microsoft Access 2016. which of the following functions can be used to return zero. a zero-length string (" “), or any other specified value?
Correct Answer:
Nz()
Note: This Question is unanswered, help us to find answer for this one
324. While working with objects in Microsoft Access 2016 database, which one of the following options is the correct functional key that can be used to rename the closed object?
Correct Answer:
F2
Note: This Question is unanswered, help us to find answer for this one
325. While working with the datasheet in Microsoft Access 2016 database. which of the following keyboard shortcuts is used to insert the current date in a datasheet?
Correct Answer:
Ctrl+Semicolon (;)
Note: This Question is unanswered, help us to find answer for this one
326. In Microsoft Access 2016, which of the following options is the correct operator that combines two strings to form one string?
Correct Answer:
&
Note: This Question is unanswered, help us to find answer for this one
327. In Microsoft Access 2016. which of the following options is the correct operator that can be used to combine two strings to form a single string and propagates null values (ie if one of the values is Null, then the whole expression evaluates to Null)?
Correct Answer:
+
Note: This Question is unanswered, help us to find answer for this one
328. Logan is working with the tables in Microsoft Access 2016 database. If he wants to show/hide the property sheet. then which of the following keyboard shortcuts will he use?
Correct Answer:
F4
Note: This Question is unanswered, help us to find answer for this one
329. In Microsoft Access 2016 database. which of the following keyboard shortcuts will you use to check the spellings?
Correct Answer:
F7
Note: This Question is unanswered, help us to find answer for this one
330.
Which of the following fields marked in the given image represents a foreign key?
Correct Answer:
2 (Customer ID)
Note: This Question is unanswered, help us to find answer for this one
331.
In order to enforce referential integrity in Microsoft Access 2016 database, which of the following statements are correct?
1. In the primary table, the common field must be a primary key or have a unique index.
2. The common fields in both the tables must be of the same data type.
3. Referential integrity can be enforced on linked tables.
Correct Answer:
Only statements1 and 2 are correct
Note: This Question is unanswered, help us to find answer for this one
332.
Which of the following types of table relationships are supported in Microsoft Access 2016?
1. A one-to-one relationship.
2. A one-to-many relationship.
3. A many-to-many relationship.
Correct Answer:
All options 1, 2, and 3.
Note: This Question is unanswered, help us to find answer for this one
333. In which of the following relationships in Microsoft Access 2016 database, the Indexed property of a primary key and foreign key fields must be set to Yes (No Duplicates)?
Correct Answer:
A one-to-one relationship.
Note: This Question is unanswered, help us to find answer for this one
334. While working with the Microsoft Access 2016 database, which of the following keyboard shortcuts is used to copy a screenshot of the current/active window to the Clipboard?
Correct Answer:
Alt+Print Screen
Note: This Question is unanswered, help us to find answer for this one
335. If you convert a database to an .accde file using Microsoft Office Access 2010, which versions of Microsoft Access can you open it in?
Correct Answer:
2010 and 2013
Note: This Question is unanswered, help us to find answer for this one
336. When writing a query, how do you force a numeric field to be 0 if it has no value?
Correct Answer:
NZ(fieldName,0)
Note: This Question is unanswered, help us to find answer for this one
337. How do you disable security alerts in the message bar when first opening a database
Correct Answer:
Click Upper Left Windows icon, Options, Trust Center, Trust Center Settings
Note: This Question is unanswered, help us to find answer for this one
338. You can specify a startup form to launch when Access begins?
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
339. What would Instr(1,"Tech on the Net","n") return?
Correct Answer:
7
Note: This Question is unanswered, help us to find answer for this one
340. You wish to filter data on a report before printing without changing the design of the report. How do you do this?
Correct Answer:
In Layout view, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on
Note: This Question is unanswered, help us to find answer for this one
341. What type of database is Access?
Correct Answer:
File server database
Note: This Question is unanswered, help us to find answer for this one
342. What does a group header or group footer do?
Correct Answer:
Displays the field label of grouped data on the top or bottom of a report
Note: This Question is unanswered, help us to find answer for this one
343. Which of these statements is true?
Correct Answer:
You do not need to put a $ in front of numbers in criteria
Note: This Question is unanswered, help us to find answer for this one
344. Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Correct Answer:
Datasheet Views cannot have code modules associated with them.
Note: This Question is unanswered, help us to find answer for this one
345. Which of these can you apply conditional formating to?
Correct Answer:
Form
Note: This Question is unanswered, help us to find answer for this one
346. How do you print a database?
Correct Answer:
Use the print option after clicking the Microsoft button
Note: This Question is unanswered, help us to find answer for this one
347. To adjust the length of fields in a report while displaying data you would use:
Correct Answer:
Layout View
Note: This Question is unanswered, help us to find answer for this one
348. What would Instr(20,"Tech on the Net","t") return?
Correct Answer:
0
Note: This Question is unanswered, help us to find answer for this one
349. Which is not a benefit of upsizing to an SQL server?
Correct Answer:
Time delayed recoverability
Note: This Question is unanswered, help us to find answer for this one
350. What key displays the Database Window?
Correct Answer:
F11
Note: This Question is unanswered, help us to find answer for this one
351. Which of the following is considered an "Unsafe Action" in an Access 2010 macro and would require you to "Show All Actions" in order to use it in Macro Design?
Correct Answer:
SaveObject
Note: This Question is unanswered, help us to find answer for this one
352. You can add your company logo to a form in:
Correct Answer:
Design & Layout Views
Note: This Question is unanswered, help us to find answer for this one
353. To query two tables that are unrelated you:
Correct Answer:
Create a junction table which contains fields common to both tables
Note: This Question is unanswered, help us to find answer for this one
354. On printing a report you find that the Comments field is printing </div> for every record in the Comments field. How do you rectify this?
Correct Answer:
Change the text format property for the field to Rich Text
Note: This Question is unanswered, help us to find answer for this one
355. You need to create a lookup field where more than one option can be chosen. Where would you do this?
Correct Answer:
In the Lookup Wizard check "Allow Multiple Values"
Note: This Question is unanswered, help us to find answer for this one
356. What is typically displayed on a Relationship Report?
Correct Answer:
The current date and database name
Note: This Question is unanswered, help us to find answer for this one
357. How do you widen the columns in the design grid?
Correct Answer:
Double-Click on the right border of the top of the column
Note: This Question is unanswered, help us to find answer for this one
358. Concerning the code below, which of the following statement is False? Dim rst as ADODb.Recordset
Correct Answer:
Recordset variables must always be named 'rst'.
Note: This Question is unanswered, help us to find answer for this one
359. What are the three wildcard characters Access allows you to use when searching?
Correct Answer:
*, #, ?
Note: This Question is unanswered, help us to find answer for this one
360. What would Format("0.981", "Percent") return?
Correct Answer:
98.10%
Note: This Question is unanswered, help us to find answer for this one
361. Which of the following Access 2010 macro actions does not require you to select "Show All Actions" in order to use it in Macro Design?
Correct Answer:
RunCode
Note: This Question is unanswered, help us to find answer for this one
362. What is the "iif" function named?
Correct Answer:
Immediate If
Note: This Question is unanswered, help us to find answer for this one
363. Which of these statements are false?
Correct Answer:
It is not possible to sort query results.
Note: This Question is unanswered, help us to find answer for this one
364. Field selectors are located...
Correct Answer:
at the top of a table
Note: This Question is unanswered, help us to find answer for this one
365. When you open an Access Form, what is the second event that fires?
Correct Answer:
On Load
Note: This Question is unanswered, help us to find answer for this one
366. In the design view of an update query the top row, labeled field is:
Correct Answer:
The field name from the table being updated.
Note: This Question is unanswered, help us to find answer for this one
367. What would Format("210.6", "Standard") return?
Correct Answer:
210.60
Note: This Question is unanswered, help us to find answer for this one
368. What must be the same for a relationship to work?
Correct Answer:
Must have same data type and field size
Note: This Question is unanswered, help us to find answer for this one
369. How is the Blank Web Database template different from the Blank Database Template?
Correct Answer:
The Blank Web Database allows users to publish their database via Access Services to SharePoint.
Note: This Question is unanswered, help us to find answer for this one
370. Which of the following is not included in the Access Built-In Functions for SQL Aggregate
Correct Answer:
Median(«expression»)
Note: This Question is unanswered, help us to find answer for this one
371. You are creating a Macro and you require the SetValue Action, but it does not exist. What do you do?
Correct Answer:
Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon
Note: This Question is unanswered, help us to find answer for this one
372. Is it possible to use the record MACRO function in Access?
Correct Answer:
No, this is not supported in Access
Note: This Question is unanswered, help us to find answer for this one
373. The Yes of a Yes/No data type field equates to which?
Correct Answer:
-1
Note: This Question is unanswered, help us to find answer for this one
374. You put the following code near the top of an Access form: Global rs10 As DAO.Recordset The code causes an error because?
Correct Answer:
Global Variables cannot be declared in Form Objects
Note: This Question is unanswered, help us to find answer for this one
375. "Yes/No" answers in Access are commonly stored as:
Correct Answer:
0 or -1
Note: This Question is unanswered, help us to find answer for this one
376. To filter a table in Datasheet view, what do you use?
Correct Answer:
Filter by Selection
Note: This Question is unanswered, help us to find answer for this one
377. What does a Pass-Through Query do?
Correct Answer:
Sends a SQL statement to a remote server for execution.
Note: This Question is unanswered, help us to find answer for this one
378. Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
Correct Answer:
255
Note: This Question is unanswered, help us to find answer for this one
379. Which of the following are views that a table can be changed to?
Correct Answer:
Datasheet
Note: This Question is unanswered, help us to find answer for this one
380. True or False: Union Queries must be created by manually writing the SQL.
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
381. Which of the following is NOT a type of query in Access?
Correct Answer:
CrossSelect
Note: This Question is unanswered, help us to find answer for this one
382. What does DAO stand for?
Correct Answer:
Data Access Objects
Note: This Question is unanswered, help us to find answer for this one
383. Access is available for a Mac.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
384. Which of these aspects of a Linked Table cannot be changed?
Correct Answer:
Table definition
Note: This Question is unanswered, help us to find answer for this one
385. When editing a relationship in the Relationships screen, which of these is not an option?
Correct Answer:
Disable Referential Integrity
Note: This Question is unanswered, help us to find answer for this one
386. In Design View, what is the first step to create a query?
Correct Answer:
Create->Query Design-> Double-click on table name
Note: This Question is unanswered, help us to find answer for this one
387. What is the maximum size of Microsoft Access 2010 database file?
Correct Answer:
2 GB, minus the space needed for system objects
Note: This Question is unanswered, help us to find answer for this one
388. What keyboard shortcut will bypass autoexec macros when opening an Access database?
Correct Answer:
Hold down Shift while opening the database
Note: This Question is unanswered, help us to find answer for this one
389. What format must the filename be in to be protected?
Correct Answer:
.ACCDE
Note: This Question is unanswered, help us to find answer for this one
390. When creating or editing a table in design view, the 'Required' field property default value is 'No'.
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
391. Double Clicking the Active Tab on the Ribbon will:
Correct Answer:
Hide or Unhide the Ribbon
Note: This Question is unanswered, help us to find answer for this one
392. What would RTrim("Tech on the Net ") return?
Correct Answer:
"Tech on the Net"
Note: This Question is unanswered, help us to find answer for this one
393. How do you copy a record?
Correct Answer:
Right-click the start of a row and click copy
Note: This Question is unanswered, help us to find answer for this one
394. True or False: You can upgrade a 2003 or earlier Access file (.mdb) to a 2007 or later Access file (.accdb) while a database password is configured.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
395. What is one way to run a macro when opening an Access Database?
Correct Answer:
Create a Macro named AutoExec
Note: This Question is unanswered, help us to find answer for this one
396. Which one listed below is not a valid version of MS Access?
Correct Answer:
2005
Note: This Question is unanswered, help us to find answer for this one
397. What does the Run button do?
Correct Answer:
Executes and renders the results of the query in a new tab
Note: This Question is unanswered, help us to find answer for this one
398. In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
Correct Answer:
The code continues executing but Access appears to hang.
Note: This Question is unanswered, help us to find answer for this one
399. Which of the following helps to study the information in a table and then make changes to streamline the data?
Correct Answer:
Table Analyzer Wizard
Note: This Question is unanswered, help us to find answer for this one
400. How do you password protect your database?
Correct Answer:
Open Database in exclusive mode->Database Tools-> Encrypt with Password
Note: This Question is unanswered, help us to find answer for this one
401. What does it mean to enforce referential integrity.
Correct Answer:
You can't update the data to violate the record's relationship.
Note: This Question is unanswered, help us to find answer for this one
402. What does an Action Query do?
Correct Answer:
Modifies data in some way.
Note: This Question is unanswered, help us to find answer for this one
403. What happens when Best Fit is used?
Correct Answer:
Text is formatted to fit the cell better
Note: This Question is unanswered, help us to find answer for this one
404. How do you create a switchboard?
Correct Answer:
Database Tools -> Switchboard Manager
Note: This Question is unanswered, help us to find answer for this one
405. How would one bypass the the execution of AutoExec Macro when you open Microsoft Office Access database?
Correct Answer:
Press and hold Shift Key
Note: This Question is unanswered, help us to find answer for this one
406. What would Mid("Alphabet", 3, 10) return?
Correct Answer:
phabet
Note: This Question is unanswered, help us to find answer for this one
407. Each sales person has many customers. Each customer can have many orders. In building a query for how much in sales a salesperson is generating, what kind of relationship will exist between customer and orders?
Correct Answer:
One-to-many
Note: This Question is unanswered, help us to find answer for this one
408. If the "Row Source" property on a combo box was set to "Beginner";"Intermediate";"Advanced", what value would you assign to the "Row Source Type" property on that combo box?
Correct Answer:
Value List
Note: This Question is unanswered, help us to find answer for this one
409. You require a Grand total to be printed on a Report. You create a calculated field and place the control in which section on the report?
Correct Answer:
Report Footer
Note: This Question is unanswered, help us to find answer for this one
410. In which row of the query design grid do you specify what is used to filter the results?
Correct Answer:
Criteria
Note: This Question is unanswered, help us to find answer for this one
411. Which term is used to refer to a single piece of data stored in a field?
Correct Answer:
Value
Note: This Question is unanswered, help us to find answer for this one
412. You require a form control that provides a text box to which a drop-down list is attached. Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?
Correct Answer:
Combo Box control
Note: This Question is unanswered, help us to find answer for this one
413. You want to create a flexible query that prompts the user for additional criteria. What will you create?
Correct Answer:
Parameter Query
Note: This Question is unanswered, help us to find answer for this one
414. When do you use the Lookup Wizard?
Correct Answer:
You want to lookup the value of a field from another table or create a list of values to choose from
Note: This Question is unanswered, help us to find answer for this one
415. Normalization is the process of:
Correct Answer:
organizing data in a database to produce optimized table structures
Note: This Question is unanswered, help us to find answer for this one
416. To create a table relationship you would click on...
Correct Answer:
Database Tools, Relationships
Note: This Question is unanswered, help us to find answer for this one
417. Which of the following is not a valid view for an Access Form?
Correct Answer:
Edit View
Note: This Question is unanswered, help us to find answer for this one
418. You have imported data from Excel. You want Access to help you split your data into different tables. What do you do?
Correct Answer:
Use the Analyze Table tool
Note: This Question is unanswered, help us to find answer for this one
419. When you run a query to find records in related tables, Access, by default, uses...
Correct Answer:
an Inner Join
Note: This Question is unanswered, help us to find answer for this one
420. How do you resize a column?
Correct Answer:
Click and drag along the right border of a field
Note: This Question is unanswered, help us to find answer for this one
421. What would Replace("alphabet", "bet", "hydro") return?
Correct Answer:
alphahydro
Note: This Question is unanswered, help us to find answer for this one
422. Where can you find the # of results in a Query?
Correct Answer:
Lower left of the screen
Note: This Question is unanswered, help us to find answer for this one
423. You want to limit what people can enter on a Form. The easiest way is to:
Correct Answer:
Use a drop down menu
Note: This Question is unanswered, help us to find answer for this one
424. How does changing the appearance of a datasheet affect the underlying table structure?
Correct Answer:
It does not change the structure
Note: This Question is unanswered, help us to find answer for this one
425. Do you have to have relationships set up in Access?
Correct Answer:
No, but it is a good practice.
Note: This Question is unanswered, help us to find answer for this one
426. Choose the correct criteria to enter when prompting a user for the Customer Name in a Query.
Correct Answer:
[Enter the Customer Name]
Note: This Question is unanswered, help us to find answer for this one
427. Which of these is not a valid aggregate function for a query search?
Correct Answer:
Quo
Note: This Question is unanswered, help us to find answer for this one
428. An Input Mask is:
Correct Answer:
A data pattern which dictates how users can enter data into a field
Note: This Question is unanswered, help us to find answer for this one
429. You can use SQL to write Queries.
Correct Answer:
Yes.
Note: This Question is unanswered, help us to find answer for this one
430. What are the 3 buttons for sorting data?
Correct Answer:
Ascending, descending, clear all sorts
Note: This Question is unanswered, help us to find answer for this one
431. What is the name of a query to which you can add records?
Correct Answer:
append query
Note: This Question is unanswered, help us to find answer for this one
432. A best practice in managing a relational database such as the Access Jet database engine is:
Correct Answer:
Normalizing the data
Note: This Question is unanswered, help us to find answer for this one
433. Can you modify information while viewing a report?
Correct Answer:
No, you can only view information with a report
Note: This Question is unanswered, help us to find answer for this one
434. True or False: To hide repeating data in a column on a report you would set the Hide Duplicates Property to "No."
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
435. Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?
Correct Answer:
Use the Object Dependencies Task Pane
Note: This Question is unanswered, help us to find answer for this one
436. If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?
Correct Answer:
Append Query
Note: This Question is unanswered, help us to find answer for this one
437. What is the difference between regular version and runtime version of Microsoft Access?
Correct Answer:
The runtime version allows users to use the Access application but they cannot use its design surfaces.
Note: This Question is unanswered, help us to find answer for this one
438. What would Len("124ABCd") return?
Correct Answer:
7
Note: This Question is unanswered, help us to find answer for this one
439. To find records within two dates you use
Correct Answer:
The BETWEEN and AND operator
Note: This Question is unanswered, help us to find answer for this one
440. The Input Mask Wizard is used to....
Correct Answer:
Format data being entered into a table
Note: This Question is unanswered, help us to find answer for this one
441. When you use the Max function, you are searching for...
Correct Answer:
The largest value in a field
Note: This Question is unanswered, help us to find answer for this one
442. In Microsoft Office Access 2010, which "Filter By Group" Options available in database objects pane:
Correct Answer:
All of Them
Note: This Question is unanswered, help us to find answer for this one
443. What type of query is used to show data but that does not alter data on the table?
Correct Answer:
Select
Note: This Question is unanswered, help us to find answer for this one
444. Access will allow Joins between two linked tables on different servers.
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
445. How do you move to the last record in a table?
Correct Answer:
All are correct
Note: This Question is unanswered, help us to find answer for this one
446. In query design, if you want to find all records where the CITY field begins with the letter D you would enter:
Correct Answer:
Like "D*"
Note: This Question is unanswered, help us to find answer for this one
447. True or false: In the 2007 and later versions of Access, databases are not encrypted when a database password is applied.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
448. What are relationships for?
Correct Answer:
To ensure referential integrity
Note: This Question is unanswered, help us to find answer for this one
449. What are two ways to enter data into your database?
Correct Answer:
Via a form and directly into a table.
Note: This Question is unanswered, help us to find answer for this one
450. Where in an Access window can you search for a specific record?
Correct Answer:
2 of these are correct
Note: This Question is unanswered, help us to find answer for this one
451. Name the object that is linked to a table that is used to enter data?
Correct Answer:
Form
Note: This Question is unanswered, help us to find answer for this one
452. If you wanted to create a query that removed records from an existing table, what kind of query would you create?
Correct Answer:
Delete Query
Note: This Question is unanswered, help us to find answer for this one
453. Which Database Tool allows you to identify tables with repeating information and suggest a more normalized table design?
Correct Answer:
Analyze Table
Note: This Question is unanswered, help us to find answer for this one
454. What is each column in a table called?
Correct Answer:
An attribute.
Note: This Question is unanswered, help us to find answer for this one
455. Which of these is considered a record?
Correct Answer:
1 row of data
Note: This Question is unanswered, help us to find answer for this one
456. What would Len("Tech on the Net") return?
Correct Answer:
15
Note: This Question is unanswered, help us to find answer for this one
457. Your sales entry form does not tab through in the order you want between fields. You should:
Correct Answer:
Manually set tab sequence on the form
Note: This Question is unanswered, help us to find answer for this one
458. You need a shortcut on a form to print a specific report. Which form design tool do you use?
Correct Answer:
Command Button
Note: This Question is unanswered, help us to find answer for this one
459. What keyboard shortcut key do you press to get help?
Correct Answer:
F1
Note: This Question is unanswered, help us to find answer for this one
460. Access _____ the saved query each time it is opened.
Correct Answer:
runs
Note: This Question is unanswered, help us to find answer for this one
461. What is the file extension of an Access 2010 database?
Correct Answer:
.accdb
Note: This Question is unanswered, help us to find answer for this one
462. What is the shortcut key combination for stopping the execution of a query?
Correct Answer:
CTRL+Break
Note: This Question is unanswered, help us to find answer for this one
463. How do you create a new table by importing an Excel Spreadsheet?
Correct Answer:
External Data tab->Excel button in Import group
Note: This Question is unanswered, help us to find answer for this one
464. Which of the following takes you through the process of creating a table
Correct Answer:
Wizard
Note: This Question is unanswered, help us to find answer for this one
465. What language is used to extend and automate MS Access?
Correct Answer:
Visual Basic for Applications
Note: This Question is unanswered, help us to find answer for this one
466. Which two objects can a report object be based on?
Correct Answer:
Table and Query
Note: This Question is unanswered, help us to find answer for this one
467. When you press the Tab key, which way does the insertion point go?
Correct Answer:
The adjacent field
Note: This Question is unanswered, help us to find answer for this one
468. Why should you enter sample data in tables after creating them?
Correct Answer:
To check for potential data maintenance problems
Note: This Question is unanswered, help us to find answer for this one
469. How do you make sure that a field from a query is displayed in the results?
Correct Answer:
The "Show" checkbox is checked
Note: This Question is unanswered, help us to find answer for this one
470. Which of these would be a proper way to type a parameter?
Correct Answer:
[Where was this shipped to?]
Note: This Question is unanswered, help us to find answer for this one
471. What do you call a value that is automatically entered in a filed for new records?
Correct Answer:
Default value.
Note: This Question is unanswered, help us to find answer for this one
472. If you delete a field from a table:
Correct Answer:
Both the field and the data are erased
Note: This Question is unanswered, help us to find answer for this one
473. To ensure a value no greater than 30 is entered into a field you would use:
Correct Answer:
A validation rule
Note: This Question is unanswered, help us to find answer for this one
474. What is a caption?
Correct Answer:
The label for a field when used on a form.
Note: This Question is unanswered, help us to find answer for this one
475. A good feature for having a unique primary key is:
Correct Answer:
Use the AutoNumber feature
Note: This Question is unanswered, help us to find answer for this one
476. What does field size do?
Correct Answer:
Restricts the number of characters in a field to a preset amount.
Note: This Question is unanswered, help us to find answer for this one
477. Can relationships be between primary keys and non-primary keys?
Correct Answer:
Yes
Note: This Question is unanswered, help us to find answer for this one
478. Which of these is a proper example of how to write an equation for a query?
Correct Answer:
[Amount]+[Field Name]
Note: This Question is unanswered, help us to find answer for this one
479. Why use a database instead of a spreadsheet?
Correct Answer:
Multiple data from various tables are needed.
Note: This Question is unanswered, help us to find answer for this one
480. How do you ensure that a field is filled out in a table?
Correct Answer:
Set the "Required" setting to "Yes"
Note: This Question is unanswered, help us to find answer for this one
481. Which of the following is NOT a valid data type in an Access table?
Correct Answer:
AutoIncrement
Note: This Question is unanswered, help us to find answer for this one
482. What character do you use to concatenate two character strings?
Correct Answer:
& (Ampersand Operator)
Note: This Question is unanswered, help us to find answer for this one
483. You can edit the field size for allowable characters in:
Correct Answer:
Design View
Note: This Question is unanswered, help us to find answer for this one
484. To edit how a form looks, you go to:
Correct Answer:
Design view
Note: This Question is unanswered, help us to find answer for this one
485. Which database object acts as a storage container for the data?
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
486. True or False: You cannot assign a Macro to a Command Button.
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
487. Which data type allows for text and numbers to be added to a field?
Correct Answer:
Text
Note: This Question is unanswered, help us to find answer for this one
488. What is a form?
Correct Answer:
An Access object where you can enter, edit or display data from a table or query
Note: This Question is unanswered, help us to find answer for this one
489. What is the best way to view and print the results of a query?
Correct Answer:
Report
Note: This Question is unanswered, help us to find answer for this one
490. What is a primary key?
Correct Answer:
It uniquely identifies each record in a table.
Note: This Question is unanswered, help us to find answer for this one
491. Which query can you delete records?
Correct Answer:
Delete Query
Note: This Question is unanswered, help us to find answer for this one
492. The functions of Avg, Sum, Count, etc. can be found in which tool group?
Correct Answer:
Totals
Note: This Question is unanswered, help us to find answer for this one
493. This holds data in a database:
Correct Answer:
Table
Note: This Question is unanswered, help us to find answer for this one
494. In an Access Query, if you would like your result to display blank values, what criteria would you use?
Correct Answer:
is null
Note: This Question is unanswered, help us to find answer for this one
495. What happens when you freeze a column?
Correct Answer:
It prevents the column from moving positions
Note: This Question is unanswered, help us to find answer for this one
496. Before you split a database, you should:
Correct Answer:
Back up the database file
Note: This Question is unanswered, help us to find answer for this one
497. To change the type of data input for a specific field, you:
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
498. Can a primary key be used as a non-primary key in another table?
Correct Answer:
Yes
Note: This Question is unanswered, help us to find answer for this one
499. What would LCase("124ABCd") return?
Correct Answer:
124abcd
Note: This Question is unanswered, help us to find answer for this one
500. The Is Null criteria searches for fields that are ____.
Correct Answer:
empty
Note: This Question is unanswered, help us to find answer for this one
501. A primary key can be described as:
Correct Answer:
A field or a combination of fields that contain unique values
Note: This Question is unanswered, help us to find answer for this one
502. If tables are for storing data, what are queries used for?
Correct Answer:
Retrieving the data you want from the tables.
Note: This Question is unanswered, help us to find answer for this one
503. What is the maximum number of indexes that you can create on an Access table?
Correct Answer:
32
Note: This Question is unanswered, help us to find answer for this one
504. How to you ensure that a field is filled out properly?
Correct Answer:
Use a validation rule.
Note: This Question is unanswered, help us to find answer for this one
505. What is a report?
Correct Answer:
The best method for printing the results of data in a database.
Note: This Question is unanswered, help us to find answer for this one
506. What would Format("1267.5", "Currency") return?
Correct Answer:
$1,267.50
Note: This Question is unanswered, help us to find answer for this one
507. How can you define how various tables of information are related?
Correct Answer:
Use the Relationships property to define them.
Note: This Question is unanswered, help us to find answer for this one
508. True or False: Embedded macros can be attached to the event property of a form, report or control.
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
Access MCQs | Topic-wise
