Home - Bank Exam - Practice Questions - MS Office Quiz - MS Access

MS Office Quiz - MS Access Online Exam Quiz

Important questions about MS Office Quiz - MS Access. MS Office Quiz - MS Access MCQ questions with answers. MS Office Quiz - MS Access exam questions and answers for students and interviews.

1. In MS-Access to open new database press

Options

A : CTRL+N

B : CTRL+O

C : ALT+F4

D : None of these

2. In MS-Access to Open a combo box

Options

A : F4 or ALT+DOWN ARROW

B : DOWN ARROW

C : PAGE DOWN

D : F9

3. In MS-Access to open an existing database press

Options

A : CTRL+N

B : CTRL+O

C : ALT+F4

D : None of these

4. In MS-Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box

Options

A : F4 or ALT+DOWN ARROW

B : DOWN ARROW

C : PAGE DOWN

D : F9

5. In MS-Access press CTRL+O to

Options

A : Open a new database

B : Open an existing database

C : Exit MS-Access

D : None of these

6. Press the following keys in MS-Access to Cancel Print Preview or Layout Preview

Options

A : CTRL+P

B : P or CTRL+P

C : S

D : C or ESC

7. Press the following keys in MS-Access to Print the current or selected object

Options

A : CTRL+P

B : P or CTRL+P

C : S

D : C or ESC

8. In MS-Access press ALT+F11 to

Options

A : Display the Control menu

B : Display the shortcut menu

C : Close the active window

D : None of these

9. How can you display the relationship in a database?

Options

A : Select View > Relationship from the menu

B : Click the Relationship button on the toolbar

C : Select Edit >Relationship from the menu

D : All the above are true

10. How can you display Pivot Table report summary data in a currency format?

Options

A : Use custom calculation

B : Type in the currency symbol

C : Modify the field settings

D : None of the above

11. A query summarizes information in a grid, organized by regions and months. Which type of query is this?

Options

A : A cross tab query

B : An update query

C : A parameter query

D : An action query

12. What method can you use to add a new table to your database?

Options

A : Use Design View to create a table

B : Enter data directly by using a datasheet

C : Both of the above

D : None of these

13. The filter by selection feature allows you to filter

Options

A : Those records that match an entity in a field

B : Records based on a criterion you specify

C : Records that meet any of several criteria you specify

D : All of the above

14. How can you display sales grouped by country, region, and salesperson, all at the same time?

Options

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

15. What is the memo data type field used for?

Options

A : To add table

B : To store objects created in other programs

C : For long text entries

D : For short text entries of no more than 255 characters

16. The checking operation performed on input data is called the

Options

A : Validation of data

B : Verification of data

C : Cross check

D : Control of data

17. What is the purpose of the description column in Table Design View?

Options

A : To define the data type applied to each field within the table

B : To describe the data that should be entered in each field

C : To enter lookup data that the field should refer to.

D : None of the above

18. To display sales grouped by country, region, and salesperson, all at the same time

Options

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

19. What is the proposal to a sub datasheet?

Options

A : To provide a hierarchical view of related tables or queries in a single window

B : To display grouped data in a report

C : To display summarized data.

D : All of the above

20. The checking operation performed on input data is called the

Options

A : Validation of data

B : Verification of data

C : Cross check

D : Control of data

Bank Exam - Practice Questions more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.60508704185486