Chapter No 7
Microsoft Access forms & Reports
1. A form that contains the sub form is called
- Form
- Main Form
- Report
- None of them
2. How many basic layouts of forms are here in Microsoft Access.
- 2
- 3
- 4
- 5
3. objects is not used to enter data into database choose which one is correct:
- Reports
- Tables
- Forms
- None
4. A form is an object of choose which one is correct:
- Table
- Database
- Report
- Query
5. Forms are designed for choose which one is correct:
- Input Data
- Display Data
- Accepting Change
- All of them
6. The forms are the _______ end of our database in Microsoft Access
- Back End
- Front End
- Both a and b
- None of them
7. A ______ auto form displays one record at a time.
- Tabular
- Columnar
- Datasheet
- 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.
- Report
- Form
- Query
- Table
9. Tables are the ______ of our database in Microsoft Access
- Front end
- Back end
- both a and b
- none of above
10. How many are the layouts of Form in MS-Access choose which one is correct?
- 2
- 3
- 4
- 5
11. Which form layout displays multiple records at a time choose which one is correct?
- Justified
- Datasheet
- Columnar
- None
12. Form with in a form is called
- Sub Form
- Main Form
- both a and b
- none of above
13. A form with multiple tabs and each tab consisting a page of information
- Parent Form
- Sub Form
- Swithboard
- multiple page form
14. The different design elements placed on form are called
- Components
- Object
- Controls
- All of Above
15. Which is not an example of a control element placed on the form
- Text Box
- Text
- Combo Box
- List Box
16. Each of the following is a form layout except.
- Justified
- Datasheet
- Columnar
- Spreadsheet
17. A Form within another form is called choose which one is correct:
- Main form
- Special form
- Dialog box
- Sub form
18. The form which contains the subform is known as choose which one is correct:
- Main form
- Special form
- Dialog box
- Child form
19. If there are small finite number of values for a certain field on a form which object will be suitable
- Text Box
- Text Area
- Combo Box
- List Box
20. In addition to navigate records can be used for __________
- Change Data
- Enter Data
- Open Form
- None of Above
21. ___________ report spreads the information for a single record over many rows
- Columnar
- Tabular
- Datasheet
- Justified
22. ___________ report simply provide a column for each field of the records in rows under the column header
- Columnar
- Tabular
- Datasheet
- Justified
23. A formatting that depends on the control’s value is called
- Formatting
- Logical Formatting
- Data Formatting
- Conditional Formatting
24. Report can be printed using _____ menu
- File
- Edit
- Tools
25. A subform can be created using choose which one is correct:
- Form wizard
- Subform wizard
- Drag and drop method
- All
26. control objects is also called Push button choose which one is correct:
- Radio Button
- Command Button
- Check Box
- None
27. is used to display a list of items on the form choose which one is correct:
- Check Box
- List Box
- Combo Box
- 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:
- Check Box
- Option Button
- Combo Box
- 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:
- Switchboard
- Subform
- Parent Form
- Multiple page Form
30. The process of using data of another database in current database without copying it is called __________
- Attaching
- Adding
- Shifting
- Linking
31. To link a database ________ menu is used
- Add
- File
- Link
- Tools
32. A form that appears at the start of the application is called
- Start Form
- Initial Form
- Switch Board
- First Form
33. Which menu is used to access switchboard manager
- File
- Edit
- Switch
- 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:
- Report
- Form
- Query
- Table
35. How many are layouts of report choose which one is correct?
- 2
- 3
- 4
- 5
36. Which type of report can display multiple records on one page choose which one is correct?
- Tabular
- Datasheet
- columnar
- Both (a) & (c)
37. To close the switch board automatically which command can be associated with a button
- Close
- Exit
- Stop
- Unload
38. is not type of report choose which one is correct:
- Tabular
- Datasheet
- Columnar
- None
39. is the main function of a report choose which one is correct:
- Edit data
- Delete data
- Accept data
- Displays data