Microsoft Access Quick Study Episode- 09

Test your knowledge now with our Online Quizzes, Q&A and MCQs! Microsoft Access Quick Study Episode- 09. Take part in an interactive quiz experience with our online quizzes, Q&A and MCQs. Try it out now Online Quiz, Q&A & MCQ.

Table of Contents

1. When a picture or other graphic image is placed in the report header section it will appear____

a. Once in the beginning of the report

b. At the top of every page

c. Every after record break

d. On the 1st and last pages of the report

1. When a picture or other graphic image is placed in the report header section it will appear____

2. Cascade delete option

3. This data type allows alphanumeric characters and special symbols.

4. Query design window has two parts. The upper part shows

5. In a database table, the category of information is called

6. To create a new table, in which method you don’t need to specify the field type and size?

7. Which of the following is not a database object?

8. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______

9. The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables

10. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

11. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

12. The two form layout types will display multiple records at one time are tabular and___

13. The size of a field with Number data type can not be

14. A small button with three dots usually displayed at the right of field properties box

15. The size of Yes No field is always

16. This key uniquely identifies each record

17. The command center of access file that appears when you create or open the MS Access database file.

18. A database language concerned with the definition of the whole database structure and schema is ________

19. When creating a new table which method can be used to choose fields from standard databases and tables

20. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

21. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

22. To sort records in a table

23. To create relationship between two tables

24. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

25. To duplicate a controls formatting you can use___

26. Which field type will you select when creating a new table if you require to enter long text in that field?

27. In table design view what are the first column of buttons used for

28. What does the show check box in query design window indicate

29. Which of the following is not a type of relationship that can be applied in Access database

30. This option allows you to build a new table by entering data directly into the datasheet.

31. To create queries in Access

32. Following is not a database model

33. In table design view, which key can be used to switch between the field names and properties panels?

34. Which of the following is NOT a type of Microsoft Access database object?

35. Which of the field has width 8 bytes?

36. Which is not a view to display a table in Access?

37. Which of the following database object hold data?

38. The__ button on the tool box display data from a related table

39. The expression builder is an access tool that controls an expression___ for entering an expression

40. A __________ enables you to view data from a table based on a specific criterion

41. Which of the following database object produces the final result to present?

42. The default and maximum size of text field in Access

43. Cascade update option

44. You can set a controls border type to make the border invisible.

45. The database language that allows you to access or maintain data in a database

46. Referential integrity means

47. A __ name must be unique within a database

48. It is an association established between common fields of two tables.

49. Which of the following is not a field type in Access

50. When entering field name, how many characters you can type in maximum?

51. It is a database object to view, change, and analyze data in different ways

52. Which of the following creates a drop down list of values to choose from a list?

53. To achieve AND effect when you are entering criteria in a query design window

54. A search value can be an exact value or it can be

55. What are the columns in a Microsoft Access table called?

56. What is a form in MS Access

57. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view

58. It is a sign or symbol that specifies, operator, and values that produce a result

59. We can remove a relationship defined between two tables by

60. Unlike text data type, this can store up to maximum of 65, 535 characters.

61. The___ operator will cause a record to be selected only if two or more conditions are satisfied

62. Which field type can store photos?

63. Queries in Access can be used as

64. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

65. Which of the following is a method to create a new table in MS Access?

66. It is most common type of query. It retrieves records from one or more tables and then displays the

67. What is the difference between ‘Open’ and ‘Open Exclusively’?

68. Which of the following statement is true

69. It is a query that when run displays its own dialog box prompting you for information, such as

70. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,

71. What is the maximum length a text field can be?

72. Which of the following statement is true?

73. Microsoft Access is a

74. If you need to edit a relationship

75. DCL provides commands to perform actions like

76. Which of the following store command to retrieve data from database?

77. Both conditions display on the same row in the design grid when ___operator is in use

78. If you write criteria values vertically (one in a row) it will mean

79. The key uniquely identifies each record in a table.

80. What do you mean by one to many relationship between Student and Class table?

8. In one-to-many relationship the table in ‘one’ side is called _ and on ‘many’ side is called _