MS - ACCESS Important Questions and Answers Set - 4
11. Which of the following is not a selection technique ?
A. To select a word , double click the word
B. To select an entire table click the empty box to the left of the field names
C. To select a row , click the record selector box to the left of the row
D. To select a column , double click anywhere in the column
Ans- D. To select a column , double click anywhere in the column
12. How can you display Pivot Table report summary data in a currency format ?
A. Use custom calculation
B. Type in the currency symbol
C. Modify the field settings
D. None of the above
Ans- C. Modify the field settings
13. What method can you use to add a new table to your database ?
A. Use design view create a table
B. Enter data directly by using a datasheet
C. Both of the above
D. All of the above
Ans- C. Both of the above
14. Which action do you use in a macro to automatically send a report snapshot in an email message ?
A. Use mail
B. Send object
C. Run macro
D. All of the above
Ans- B. Send object
15. How can you display sales grouped by country , region and salesperson , all at the same time ?
A. Use the Sort Descending command
B. Use the Pivot table view command
C. Use the find command on specified groups
D. All of the above
Ans-B. Use the Pivot table view command
16. The checking operation performed on input data is called the
A. Validation of data
B. Verification of data
C. Cross check
D. Control of data
Ans - A. Validation of data
17. A form defines
A. Where data is placed on the screen
B. The width of each field
C. Both A and B
D. All of the above
Ans- C. Both A and B
18. The following method you can use to add a new table to your database ?
A. Use design view to create a table
B. Enter data directly by using a datasheet
C. Both of above
D. All of the above
Ans- C. Both of above
19. The following you can use in a macro to automatically send a report snapshot in an email message
A. Use mail
B. Send object
C. Run macro
D. All of the above
Ans- B. Send object
20. To insert a graphic of your company’s logo on a report
A. Click the image button on the toolbox and drag on the report to draw a
place holder for the graphics
B. You can’t . Microsoft Access won’t let you insert graphics files
C. Select insert > Picture from the menu
D. Select tools > Insert picture from the menu
Ans- A. Click the image button on the toolbox and drag on the report to
draw a place holder for the graphics
21. The Fill/ Back color button on the formatting toolbar applies color to :
A. The border for the selected control
B. The text in the selected control
C. All aspects of the control
D. The background of the selected control
Ans- B. The text in the selected control
22. The type of query extract data and put them into separate table
A. A parameter query
B. A make - table query
C. An update query
D. A cross tab query
Ans- B. A make - table query
23. The following criterion is NOT written using proper syntax ?
A. “Haris”
B. <500
C. No value
D. Between #1/1/2000# and #12/31/2000#
Ans- C. No value
24. ( IF [ Age] > 65 , “ Senior” , “ Adult”) This expression is an example of :
A. A conditional expression
B. Algebraic expression
C. Something that belongs in a Microsoft Excel book
D. A financial expression
Ans- A. A conditional expression
25 The following property determines what is displayed in a control
A. The control source property
B. The display property
C. The comes from property
D. The data property
Ans- A. The control source property
26.You view the properties of a form
A. Select view > Form properties form the menu
B. Right click anywhere on the form and select properties from the shortcut
menu
C. Double click the form selector box in the upper left corner of the form
D. All of the above
Ans - B. Right click anywhere on the form and select properties from the
shortcut menu
27. You can keep the sum ( [ Sales] ) to calculate the totals for each month in
A. The report footer section
B. The page footer section
C. The month group footer section
D. The summary section
Ans- C. The month group footer section
28. The procedure for selecting multiple controls on a report ?
A. Hold down the shift key as you click each object that you want to select
B. If the controls are aligned along a horizontal or vertical line , click the
horizontal or vertical ruler above or to the left of the controls
C. Hold down the Ctrl key as you click each object that you want to select
D. All of these above are true
Ans - A. Hold down the shift key as you click each object that you want
to select
29. The following database object can you import from one Microsoft Access
database to another ?
A. Queries
B. Tables
C. Forms
D. All of the above
Ans - D. All of the above
30. What field type is used to store picture in a table ?
A. Memo
B. OLE
C. Hyperlink
D. None
Ans- B. OLE
