2nd Year Computer Science Chapter 5 Introduction to Microsoft Access Notes MCQs Bank

computer 12th notes chapter No 5

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


2. Microsoft Access database window include __________ buttons  


3. In Access, the structure of a table can be created in :


4. ___ objects is used to display data as well as to change data of database :


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


6. ___ is the most popular and powerful DBMS : 


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


8. To database object which actually stores data is called 


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


10. ___represents of wizard of DBMS :


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


12. Each set of related items in a table is called. 


13. Which of the following object is used to retrieve data from database and present  in a formatted way : 


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


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


16. The maximum number of tables in a database can be:


17. Which is not included in database wizard 


18. Which of the following are objects in an MS, Access database?


19. ___is not a database object :


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


21. In a table each column represents a 


22. ___is the fundamental property of relational database : 


23. The smallest meaningful unit of data in a database is called:


24. The output of the query is in the form of a


25. ___is not true about a query : 


26. MS-Access is a :


27. A report may be based on 


28. A query is a more flexible way of 


29. An MS Access table contains:


30. A database may contain :


31. In a table each row represents a 


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


33. Microsoft Access saves the database with the extension 


34. To automate repeated tasks __________are used 


35. ___objects is used retrieve data from database and present in a formatted way :


36. The actual data of database is stored in :


37. ___ is element MS-Access application window : 


38. It is very simple to create database using


39. What is displayed in title bar of an open database?


40. ___is true about query : 


41. A database consists of various components called the 


42. A record is a complete set of __________fields 


43. ___is a collection of related data organized in rows and columns : 


44. Which object is used to store data and define structure for the data in a database?


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


46. ___  objects of MS-Access database is used to create user-interface to  perform different operations on database : 


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


Short Questions

1. Define database object.
2. Define form.
3. Define macro?
4. Differentiate between an application window and a database window?
5. How do fields and records differ?
6. How does a database differ from a table?
7. How many methods do create the database?
8. List any five buttons available on Access database window.
9. List any four facilities provided by RDBMS.
10. List any three advantages of reports.
11. What are Forms?
12. What are Queries?
13. What are Reports?
14. What are Scroll Bars?
15. What are Tables?
16. What are the database objects?
17. What are Toolbars?
18. What do you know about MS Access?
19. What do you know about RDBMS?
20. What do you mean by IDE?
21. What is a database wizard?
22. What is a form?
23. What is a module?
24. What is a query?
25. What is a table?
26. What is an IDE?
27. What is Data Redundancy?
28. What is database object?
29. What is database wizard?
30. What is meant by “Microsoft Office Integration”?
31. What is Menu Bar?
32. What is Microsoft Access?
33. What is Program Control Icon?
34. What is Status Bar?
35. What is the use of database window in MS Access?
36. What is the use of reports?
37. What is Title Bar?
38. What is wizard?
39. What will happen if the same name of the database is done?
40. Which database object is used to create and format printed output?
41. Which database object stores the data in the database?
42. Write any four advantages of IDE.
43. Write any three advantages of forms.
44. Write some features/benefits of Access?
45. Write the four major database objects in MS Access.
46. Write the names of any five parts of MS Access application window.

Long Questions

1. What is MS-Access? What are the benefits of using it?
2. Explain the procedure for creating a new database in MS-Access.
3. Explain the procedure to open and exit an existing database.
4. Discuss the MS-Access Application Window, title bar, menu bar, toolbar, scrollbars and status bar in detail.
5. What is database window in the MS-Access? Also discuss different buttons (objects) available in this window.

Leave a Reply

Your email address will not be published. Required fields are marked *