1. What is 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
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
2..Which of the following database object can you import from one Microsoft Access database to another? (Select All that apply)
a. Queries
b. Tables
c. Forms
d. All of the above
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
3.What field type is used to store picture in a table?
a. Memo
b. OLE
c. Hyperlink
d. None
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
4.How can you add a table to the query design window?
a. Select Edit>Add Table from the menu
b. Select Tools>Add table from the menu
c. Click the Show Table button on the toolbar
d. Select the table from the Table list on the toolbar
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
5.Which of the following type s of queries are action queries?
a. Update queries.
b. Crosstab Queries
c. Parameter queries
d. Append Queries
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
6.A query prompts a user for a data and then displays only records that contain the specified date. Which type of of query is this?
a. A parameter query
b. A crosstab query
c. An update query
d. An action query
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
7.Which of the following is NOT a report section?
a. Report Header section
b. Summary section
c. Page header section
d. Details section
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
8.You can display a database Object in design view by
a. Opening the database object and clicking the view button on the toolbar
b. Selecting the database object and clicking the design button on the database window
c. Selecting the database object and press Ctrl + V
d. Opening the database object and selecting Tools>Design view
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
9.How can you display the relationship in a database?
a. Select View > Relationship form the menu
b. Click the Relationship button on the toolbar
c. Select Edit >Relationship from the menu
d. Click the Relationship button in the Database window
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
10.If you are creating a cross tab query, what must table you are querying contain?
a. Lots of confusing information
b. More than 100 records
c. At least one field
d. All of the above
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl
11.A query summarizes information in a grid, organized by regions and months. Which type of query is this?
a. An update query
b. A parameter query
c. An action query
d. A cross tab query
Correct Answer: d
  Microsoft Access Multiple Choice Questions (MCQs) published on http://www.harjotmann.page.tl