➨ MS Access Multiple Choice Questions and Answers

1. In MS-Access press CTRL+O to

A. Open a new database B. Open an existing database C. Exit MS-Access D. None of these - Answer&Explanation Answer:Option B Explanation : No answer description available for this question. View Answer

2. 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

A. F4 or ALT+DOWN ARROW B. DOWN ARROW C. PAGE DOWN D. F9 - Answer&Explanation Answer:Option D Explanation : No answer description available for this question. View Answer

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

A. CTRL+N B. CTRL+O C. ALT+F4 D. None of these - Answer&Explanation Answer:Option B Explanation : No answer description available for this question. View Answer

4. In MS-Access to Open a combo box

A. F4 or ALT+DOWN ARROW B. DOWN ARROW C. PAGE DOWN D. F9 - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

5. In MS-Access to open new database press

A. CTRL+N B. CTRL+O C. ALT+F4 D. None of these - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

6. Which symbol must all formula begin with:

A. @ B. = C. + D. % - Answer&Explanation Answer:Option B Explanation : No answer description available for this question. View Answer

7. In an excel sheet the active cell is indicated by:

A. A blinking border B. A dotted border C. A dark wide boarder D. None of These - Answer&Explanation Answer:Option C Explanation : No answer description available for this question. View Answer

8. To add two cells (A1 and A2) together you use the following formula:

A. A1 plus A2 B. =A1 + A2 C. =Add(A1+A2) D. =together(A1:A2) - Answer&Explanation Answer:Option B Explanation : No answer description available for this question. View Answer

9. You can create hyperlinks from the Excel workbook to

A. A webpage on company internet B. A web page on the internet C. Other office 97 application documents D. All of the above - Answer&Explanation Answer:Option D Explanation : No answer description available for this question. View Answer

10. The advantage of using a spreadsheet is

A. Calculations can be done automatically B. Changing data automatically updates calculations C. More flexibility D. All of the above - Answer&Explanation Answer:Option D Explanation : No answer description available for this question. View Answer

11. There are three types of data found in a spreadsheet:

A. Numbers, formulas, labels B. Data, words, numbers C. Words, numbers, labels D. Equations, data, numbers - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

12. To merge the cells which tab do you use from the format, cells menu?

A. Merge tab B. Number tab C. Alignment tab D. Font tab - Answer&Explanation Answer:Option C Explanation : No answer description available for this question. View Answer

13. How do you rearrange the date in ascending or descending order?

A. Data, table B. Data, sort C. Data, form D. Data, subtotals - Answer&Explanation Answer:Option B Explanation : No answer description available for this question. View Answer

14. Which of the following is not a data base application?

A. Access B. dBase C. edit D. FoxPro - Answer&Explanation Answer:Option C Explanation : No answer description available for this question. View Answer

15. How many save as option in MS Access 2007?

A. 1 B. 2 C. 3 D. 4 - Answer&Explanation Answer:Option C Explanation : No answer description available for this question. View Answer

16. How we save database file in MS Access 2007 for Ms Access 2000?

A. Save As MS Access 2000 Database B. Save Only C. Save Object As D. - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer