 |
| Computer Science 12th Chapter 7 - MS Access Forms and Reports Questions Bank |
Computer Science 2nd Year Chapter 7 - MS Access Forms and Reports Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. A form that contains the sub form is called
2. ___ is used to retrieve data from one or more tables of database and to present it to the user in a formatted way :
3. ___________ report simply provide a column for each field of the records in rows under the column header
4. ___________ report spreads the information for a single record over many rows
5. ___control objects is also called Push button :
6. ___is not type of report :
7. ___is the main function of a report :
8. ___is used to display a list of items on the form :
9. ___is used to display options that have values in the form of True/False or Yes/No :
10. ___objects is not used to enter data into database :
11. A ______ auto form displays one record at a time.
12. A form is an object of :
13. A form that appears at the start of the application is called
14. A form that contains a sub form is called
15. A Form that contains multiple tabs and each tab consists of a page of information is called :
16. A form with multiple tabs and each tab consisting a page of information
17. A form within another form is called:
18. A formatting that depends on the control’s value is called
19. A report may be based on:
20. A report that provides a column for each field of the records in rows under the column header is known as:
21. A single report can display data from:
22. A subform can be created using :
23. Each of the following is a form layout except.
24. Form with in a form is called
25. Forms are designed for :
26. How many are layouts of report :
27. How many are the layouts of Form in MS-Access :
28. How many basic layouts of forms are here in Microsoft Access.
29. How many form layouts are provided by MS Access?
30. If there are small finite number of values for a certain field on a form which object will be suitable
31. In addition to navigate records can be used for __________
32. Report can be printed using _____ menu
33. Tables are the ______ of our database in Microsoft Access
34. The different design elements placed on form are called
35. The form which contains the subform is known as :
36. The forms are the _______ end of our database in Microsoft Access
37. The process of using data of another database in current database without copying it is called __________
38. To close the switch board automatically which command can be associated with a button
39. To link a database ________ menu is used
40. What is the function of a Form in MS Access?
41. When displaying a sub-form within a main form, which form is based on the Primary table?
42. Which Auto form displays one record at a time?
43. Which form layout displays multiple records at a time :
44. Which is not an example of a control element placed on the form
45. Which menu is used to access switchboard manager
46. Which of the following is used to display a list of items in forms?
47. Which of the following is used to retrieve data from database and represent it to the user in a formatted way?
48. Which of the following is used to retrieve data from one or more tables of database and to present it to the user in a formatted way.
49. Which type of report can display multiple records on one page :
50. Which view can be used to enter or modify data in the underlying table?
51. You can drag bar to move property sheet window around screen:
Short Questions
1. Are sub-forms useful?
2. Can you apply the formatting that depends on control's value?
3. Define Combo Box?
4. Define Command Button control?
5. Define desktop?
6. Define event?
7. Define Form Layout?
8. Define Form Wizard?
9. Define Multitasking?
10. Define Report?
11. Define some uses of clipboard?
12. Define sub-form.
13. Differentiate between Check Boxes and Radio Buttons?
14. Differentiate between combo box and list box
15. Differentiate between form and report?
16. Distinguish between checkbox and radio button.
17. How is a form constructed?
18. How is combo box used?
19. List different objects of Windows Operating System?
20. List different types of forms in MS Access.
21. List out some uses of form.
22. List some activities of Control Panel?
23. List two advantages of Report?
24. State the purpose of Sub-Form?
25. What are check boxes?
26. What are Control Objects of Form?
27. What are reports?
28. What are the different Operating systems?
29. What is a Switchboard?
30. What is Access Form?
31. What is Columnar Form?
32. What is Columnar Report?
33. What is Conditional Formatting?
34. What is Datasheet Form?
35. What is File Management?
36. What is form?
37. What is Hierarchical Form / Master/Detail Form, or Parent/Child Form?
38. What is linking?
39. What is List Box control?
40. What is meant by GUI?
41. What is meant by primary partition?
42. What is Password Text Field?
43. What is primary and extended partition?
44. What is Tabular Form?
45. What is Tabular Report?
46. What is the purpose of radio button?
47. What is the purpose of Recycle Bin?
48. What is the use of columnar form?
49. What is the use of Control Panel?
50. What is Windows Explorer?
51. What Justified Form?
52. Which control is used to execute commands in MS Access forms?
53. Which type of form is used to navigate database?
54. Why computer needs an Operation System?
55. Why is a list box used in forms?
56. Write any three advantages of form.
57. Write any three uses of reports.
58. Write the use of datasheet form.
59. Write the use of tabular form.
60. Write two types of reports in MS Access?
Long Questions
1. What is a form? Also discuss its uses and advantages.
2. Write down the procedure of creating form using wizard.
3. Discuss different layouts of a form in MS-Access.
4. Write down the procedure of creating form using design view.
5. How to add list and combo boxes on a form?
6. How to add check boxes and radio buttons on a form?
7. How to add command button on a form?
8. How to create the form using wizard?
9. How to implement multiple page form using tabs, conditional formatting, password text fields, change control type and composite primary key?
10. What is a report? Also discuss its different types and their uses.
11. How to create a report using Wizard?
12. How to create a report using Design View? Also discuss how to print a report?
13. Differentiate between form and report.
14. What is the linking process in MS-Access?
15. What is a switchboard? Also write down the steps of creating a switch board.
16. What is a toolbox briefly describe the controls available on the toolbox?