DBMS MCQs Part - 6 [ MS Access MCQs ] [ Database Management System Multiple Choice Questions ]
personAnil Pandit
October 19, 2024
0
share
1. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
2. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
3. What is the memo data type field used for?
4. What is the purpose of the description column in table design view?
5. What is the purpose of a subdatasheet?
6. Queries can be created in Access by
7. Relationship can be establish between two tables by
8. What is the use of Cascade Delete Option in MS Access?
9. Macros can recover from _______ in a controlled manner.
10. A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
11. The VB Name used to display the warning message icon is _______.
12. What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
13. A(n) _______ is major object that completes an action or a set of actions.
14. By default, what is the name of a new module in the Modules folder of the Project pane called?
15. To assign a macro to an _______, users need to open the form in Design View.
16. In a module, the VB Name used to display a warning query icon is _______.
17. In a module, a(n) _______ is a series of commands and properties that perform a specific task.
18. A(n)_______ is a major object that can run independent of a control.
19. Which of the following statements about option group is incorrect?
20. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these files?
21. What data type should you choose for a zip code field in a table?
22. In order to use DBMS, it is important to understand:
23. A list consists of last names, first names, addresses, and pin codes. If all people in the list have the same last name and the same pin code, a useful key would be:
24. What happens when you add the asterisk (*) from any field list to a query?
25. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
26. Which editor was provided for use with Access Basic?
27. The Filter By Selection feature allows you to filter:
28. In the Relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
29. How can you add a table to the relationship window?
30. In MS Access, Text Data type may contain a maximum of how many characters?
31. For _____ data to be useful, both the sender and the receiver need to be able to read and use the data.
32. It is a sign or symbol that specifies, operator, and values that produce a result:
33. Which of the following database objects is created first before any other?
34. This type of database contains multiple tables that are connected to produce combined output from all tables:
35. The Filter By Selection feature allows you to filter:
36. The operation of checking input data against specified criteria is known as:
37. Some rules are set in databases to check and permit only correct values. What is this feature called?
38. Database access levels are specified so as to define who can access what in a database. It is identified through:
39. What is it called to present information in a particular order based on numeric or alphabetical value?
40. A collection of related records in a database is known as a:
41. A part of a database that stores complete information about an entity such as employee, sales, orders, etc.:
42. Which part of the IIF expression is the action performed if the true condition exists?
43. If you need a calculation in an unbound control, you can create a custom _____.
44. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
45. Which function evaluates a “true/false” expression and then performs one of two actions?
46. When adding an image, which size mode will change the height or width of the image to fit the control?
47. The three parts of an IIF function are separated by _____.
48. A Smart Tag can be set using the _____ tab in the property sheet.
49. A(n) _____ is a control that, when clicked, executes an action or series of actions.
50. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
