12th Class Class Computer Mcqs Chapter No 7 | 2nd Year Computer Mcqs Chapter Wise Pdf

Print/Downlaod pdf

Chapter No 7

Microsoft Access forms & Reports

1. A form that contains the sub form is called 

  1. Form
  2. Main Form
  3. Report
  4. None of them 

2. How many basic layouts of forms are here in Microsoft Access.

  1. 2
  2. 3
  3. 4
  4. 5

3.         objects is not used to enter data into database choose which one is correct: 

  1. Reports
  2. Tables
  3. Forms
  4. None 

4. A form is an object of choose which one is correct: 

  1. Table
  2. Database 
  3. Report
  4. Query

5. Forms are designed for choose which one is correct: 

  1. Input Data
  2. Display Data
  3. Accepting Change
  4. All of them

6. The forms are the _______ end of our database in Microsoft Access  

  1. Back End
  2. Front End
  3. Both a and b
  4. None of them 

7. A ______ auto form displays one record at a time. 

  1. Tabular
  2. Columnar
  3. Datasheet
  4. Justified

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

  1. Report
  2. Form
  3. Query
  4. Table 

9. Tables are the ______ of our database in Microsoft Access 

  1. Front end
  2. Back end
  3. both a and b
  4. none of above 

10. How many are the layouts of Form in MS-Access choose which one is correct?

  1. 2
  2. 4

11. Which form layout displays multiple records at a time choose which one is correct?

  1. Justified
  2. Datasheet
  3. Columnar
  4. None 

12. Form with in a form is called 

  1. Sub Form
  2. Main Form 
  3. both a and b
  4. none of above 

13. A form with multiple tabs and each tab consisting a page of information  

  1. Parent Form
  2. Sub Form 
  3. Swithboard
  4. multiple page form

14. The different design elements placed on form are called 

  1. Components
  2. Object
  3. Controls
  4. All of Above 

15. Which is not an example of a control element placed on the form  

  1. Text Box
  2. Text
  3. Combo Box
  4. List Box

16. Each of the following is a form layout except. 

  1. Justified
  2. Datasheet
  3. Columnar
  4. Spreadsheet

17. A Form within another form is called choose which one is correct:

  1. Main form
  2. Special form
  3. Dialog box
  4. Sub form

18. The form which contains the subform is known as choose which one is correct: 

  1. Main form
  2. Special form
  3. Dialog box
  4. Child form 

19. If there are small finite number of values for a certain field on a form which  object will be suitable

  1. Text Box
  2. Text Area
  3. Combo Box
  4. List Box

20. In addition to navigate records can be used for __________ 

  1. Change Data
  2. Enter Data
  3. Open Form
  4. None of Above 

21. ___________ report spreads the information for a single record over many rows 

  1. Columnar
  2. Tabular
  3. Datasheet
  4. Justified

22. ___________ report simply provide a column for each field of the records in rows  under the column header 

  1. Columnar
  2. Tabular
  3. Datasheet
  4. Justified

23. A formatting that depends on the control’s value is called

  1. Formatting
  2. Logical Formatting
  3. Data Formatting
  4. Conditional Formatting

24. Report can be printed using _____ menu 

  1. File
  2. Edit 
  3. Print
  4. Tools 

25. A subform can be created using choose which one is correct: 

  1. Form wizard
  2. Subform wizard
  3. Drag and drop method
  4. All

26.          control objects is also called Push button choose which one is correct: 

  1. Radio Button
  2. Command Button
  3. Check Box
  4. None 

27.           is used to display a list of items on the form choose which one is correct:

  1. Check Box
  2. List Box
  3. Combo Box
  4. Both b & c

28.          is used to display options that have values in the form of True/False or  Yes/No choose which one is correct:

  1. Check Box
  2. Option Button 
  3. Combo Box
  4. Both a & b

29. A Form that contains multiple tabs and each tab consists of a page of information  is called choose which one is correct:

  1. Switchboard
  2. Subform 
  3. Parent Form
  4. Multiple page Form

30. The process of using data of another database in current database without copying  it is called __________ 

  1. Attaching
  2. Adding
  3. Shifting
  4. Linking

31. To link a database ________ menu is used 

  1. Add
  2. File
  3. Link
  4. Tools 

32. A form that appears at the start of the application is called 

  1. Start Form
  2. Initial Form
  3. Switch Board
  4. First Form

33. Which menu is used to access switchboard manager 

  1. File
  2. Edit 
  3. Switch
  4. Tools 

34.            is used to retrieve data from one or more tables of database and to  present it to the user in a formatted way choose which one is correct:

  1. Report
  2. Form
  3. Query
  4. Table

35. How many are layouts of report choose which one is correct? 

  1. 2
  2. 4

36. Which type of report can display multiple records on one page choose which one is correct?  

  1. Tabular
  2. Datasheet
  3. columnar
  4. Both (a) & (c)

37. To close the switch board automatically which command can be associated with a  button 

  1. Close
  2. Exit
  3. Stop
  4. Unload 

38.          is not type of report choose which one is correct: 

  1. Tabular
  2. Datasheet
  3. Columnar
  4. None 

39.           is the main function of a report choose which one is correct: 

  1. Edit data
  2. Delete data
  3. Accept data
  4. Displays data