16. A specialist in charge of the database of an organization select the best fit for answer
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
17. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
18. ….. presents data in a way similar to an excel spreadsheet
a. Datasheet view
b. Design view
c. Print preview
d. Layout preview
Correct Answer: a

19. What method can you 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
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
20. Which action do you use in a 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
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
21. 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 above
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
22. 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
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
23. A form defines
a. Wqhere data is placed on the screen
b. The width of each field
c. Both a and b
d. All of the above
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl

24. How do you 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
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
25. The Fill/Back Color button on the formatting toolbar applies color to:
a. The border fo the selected control
b. The text in the selected control
c. All aspects of the control
d. The background of the selected control
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
26. Which type of query extract the data and put them into separate table?
a. A parameter query
b. A make-table query
c. An update query
d. A crosstab query
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
27. Which of the following criterion is NOT written using the proper syntax?
a. “Haris”
b. <500
c. NO VALUE
d. Between #1/1/2000# and #12/31/2000#
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
28. IIF [Age]>65, “Senior”,”Adult&rdquo 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
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
29. Which 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
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
30. How can 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 frm the shortcut menu
c. Double click the form selector box in the upper left corner of the form
d. All of the above
Correct Answer: b