 |
| Computer Science 12th Chapter 5 - Introduction to Microsoft Access Questions Bank |
Computer Science 2nd Year Chapter 5 - Introduction to Microsoft Access Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. ___ objects of MS-Access database is used to create user-interface to perform different operations on database :
2. ___ is element MS-Access application window :
3. ___ is the most popular and powerful DBMS :
4. ___ objects is used to display data as well as to change data of database :
5. ________ is a statement that extracts specific information database.
6. ___is a collection of related data organized in rows and columns :
7. ___is not a database object :
8. ___is not true about a query :
9. ___is the fundamental property of relational database :
10. ___is true about query :
11. ___objects is used retrieve data from database and present in a formatted way :
12. ___represents of wizard of DBMS :
13. A database consists of various components called the
14. A database may contain :
15. A place where we can see all the tables and their relationship
16. A query is a more flexible way of
17. A record is a complete set of __________fields
18. A report may be based on
19. A step by step procedure to perform a task easily available in a software is called
20. A window that organizes all objects in the database is called
21. An MS Access table contains:
22. Each set of related items in a table is called.
23. In a table each column represents a
24. In a table each row represents a
25. In Access, the structure of a table can be created in :
26. In access, the structure of a table is created in ________view
27. It is very simple to create database using
28. Microsoft Access database window include __________ buttons
29. Microsoft Access saves the database with the extension
30. MS-Access is a :
31. The actual data of database is stored in :
32. The bar which identifies the database application you are running in Microsoft Access
33. The bottom most bar in Ms. Access is called
34. The maximum number of tables in a database can be:
35. The output of the query is in the form of a
36. The smallest meaningful unit of data in a database is called:
37. There are _______ major database objects in Ms. Access
38. To automate repeated tasks __________are used
39. To create a database in file new database there is a button named
40. To database object which actually stores data is called
41. Using __________ you can create tables, forms, reports and queries in very short time
42. What is displayed in title bar of an open database?
43. Which bar is used to see that CAPS button on keyboard is on
44. Which is not included in database wizard
45. Which object is used to store data and define structure for the data in a database?
46. Which of the following are objects in an MS, Access database?
47. Which of the following object is used to retrieve data from database and present in a formatted way :
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.