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

by
Print/Downlaod pdf

Chapter No 5

Introduction of Microsoft Access

1. A database consists of various components called the 

  1. Tool
  2. Properties
  3. Entities
  4. Objects

2. Which of the following object is used to retrieve data from database and present  in a formatted way choose which one is correct? 

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

3.            is the most popular and powerful DBMS choose which one is correct: 

  1. Ms-word
  2. MS-Access
  3. Ms-Excel
  4. Ms-PowerPoint 

4. MS-Access is a choose which one is correct:

  1. Network Database Management system
  2. Object-oriented database Management system.
  3. Relational database Management system 
  4. All of these

5.          represents of wizard of DBMS choose which one is correct:

  1. Database wizard
  2. Table wizard
  3. Form wizard
  4. All of these

6.            is element MS-Access application window choose which one is correct: 

  1. Title bar
  2. Tool bars 
  3. Scrollbars
  4. All of these

7. Microsoft Access saves the database with the extension 

  1. .mdb
  2. msdb 
  3. madb
  4. None of them 

8. A record is a complete set of __________fields 

  1. Distinct
  2. Related
  3. Designed
  4. All of them 

9. The actual data of database is stored in choose which one is correct:

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

10.           is a collection of related data organized in rows and columns choose which one is correct: 

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

11. In access, the structure of a table is created in ________view 

  1. design view
  2. Datasheet View
  3. a and b both
  4. none of them 

12. In a table each row represents a 

  1. Record
  2. Field
  3. Form
  4. Data saet

13. In a table each column represents a 

  1. Record
  2. Field
  3. Data set
  4. Entity 

14. A query is a more flexible way of 

  1. Selecting records from database
  2. Filtering records from database
  3. Sorting records from database
  4. All of above

15. A step by step procedure to perform a task easily available in a software is called  

  1. Automation
  2. Manual 
  3. Wizard
  4. None of Above

16. Using __________ you can create tables, forms, reports and queries in very short time 

  1. Menus
  2. GUI
  3. Tools
  4. Wizard

17. A place where we can see all the tables and their relationship 

  1. Window
  2. Dialog Box
  3. Relationship Window
  4. All of Above 

18.         is the fundamental property of relational database choose which one is correct: 

  1. It may contain multiple tables. 
  2. It contains only one table. 
  3. It contains no tables. 
  4. None of these 

19. ________ is a statement that extracts specific information database.

  1. Table
  2. Query
  3. Report
  4. All of these

20. To automate repeated tasks __________are used 

  1. Instructions
  2. Wizard
  3. Programming
  4. Macro

21.           is true about query choose which one is correct: 

  1. User can also change data in the database that fulfills certain criteria.
  2. A query also allows performing calculations of different number fields. 
  3. The output of query is also displayed in the form of a table.
  4. All of these

22.           is not true about a query choose which one is correct: 

  1. A query can be used as source of records for Forms and reports 
  2. A query is a stored question or request. 
  3. A query allows to access data of only one table of database. 
  4. None of these 

23.             objects of MS-Access database is used to create user-interface to  perform different operations on database choose which one is correct: 

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

24.            objects is used to display data as well as to change data of database choose which one is correct:

  1. Form
  2. Report 
  3. Both (a) and (b)
  4. None 

25.           objects is used retrieve data from database and present in a formatted way choose which one is correct:

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

26. Which is not included in database wizard 

  1. Template
  2. Selecting Fields
  3. Customizations
  4. Design Database

27. To create a database in file new database there is a button named

  1. Open
  2. Select
  3. Create
  4. None of Above 

28. The bar which identifies the database application you are running in Microsoft Access

  1. Tool Bar
  2. Title Bar
  3. Status Bar
  4. Task Bar

29. In Access, the structure of a table can be created in choose which one is correct:

  1. Design View
  2. Datasheet View
  3. Both (a) and (b)
  4. None 

30.           is not a database object choose which one is correct:

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

31. The bottom most bar in Ms. Access is called 

  1. Tool Bar
  2. Title Bar
  3. Status Bar
  4. Menu Bar 

32. Which bar is used to see that CAPS button on keyboard is on 

  1. Tool Bar
  2. Title Bar
  3. Status Bar
  4. Menu Bar 

33. A window that organizes all objects in the database is called

  1. Window
  2. Database Window
  3. Dialog
  4. Database Dialog

34. A database may contain choose which one is correct:

  1. Only one table
  2. At least two table
  3. Many tables
  4. None

35. A report may be based on a choose which one is correct:

  1. Query
  2. Form
  3. Table
  4. Both (a) & (c)

36. Microsoft Access database window include __________ buttons  

  1. Three
  2. Five 
  3. Four
  4. Seven

37. There are _______ major database objects in Ms. Access 

  1. Two
  2. Four
  3. Three
  4. Five 

38. To database object which actually stores data is called 

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

<Previous Chapter
Take Quiz No 5
Next Chapter >

Post Views: 706