In Designer mode;

55. MS Access. What is the maximum size of the text box?

255 Characters;

56. MS Access. What is the maximum length of the field name?

64 Characters;

57. MS Access. What is the maximum length of the Memo field?

65535

58. MS Access. What type of field of the database table intended for automatic numbering of records?

AutoNumber

59. MS Access. What is the Memo field type for?

A special type for storing large amounts of text

60. MS Access. What is a composite primary key?

Several fields that uniquely determine the entry in the table

61. MS Access. What is a simple primary key?

One field that uniquely identifies a record in the table

62 MS Access. What is the logical type of the field for?

Allows you to store one value from two opposite (True / False)

63. MS Access. The field and the record in the database are respectively?

Column and row

64. MS Access. What is the purpose use of the tables in the database?

To store data

65. MS Access. What determines the structure of the table in the database?

Set of fields

66. MS Access. What does the "one-to-one" ratio mean?

when each records in one table corresponds to a single entry in another table.

67. MS Access. What is the mode of "Cascad Delete Related Records"?

When you delete records in the main table, the related records will be deleted in the subordinate table

68. MS Access. What is the mode of "Cascad Update Related Fields"?

If you change the value of the record field in the main table, the subordinate table will update the data in the related fields

69. Which Access DB object can be the data source for the query?

Table, Query

70. MS Access. What is the query "Select" for?

To select data from one or more tables using condition

71. MS Access. What query is called parametric?

The request for sampling, the values of the selection conditions in which are set in the dialog mode at the request start

72. MS Access. Which query allows you to create an analytical table in which the row headers are the values of one field of the source object, the column headings are the values of another field, and on their intersection the results of statistical processing of the value of the numeric field?

Cross-Tab

73. MS Access. Which function allows you to calculate the number of records in a group?

MS Access. Which function allows you to calculate the arithmetic mean of the values of the numeric field of the group records?

MS Access. Which function allows you to calculate the sum of the field values in a group of records?

COUNT, AVG, SUM

74. MS Access. Which button from the below shows the window "Relationships"? 2

MS Access. Which button from the following allows you to display the selected object in Design mode? 1

MS Access. Which button from the following allows you to execute the query? 4

MS Access. Which button from the following allows you to convert a query into a query with group operations? 5

75. MS Access. Which button from the following shows the window "Builder"? 2

MS Access Which button from the following allows you to convert a query into an update query? 2

MS Access. Which button from the following allows you to convert a query into an addition request? 3

76-79 ТАПСЫРМАЛАР БАЗАДА ЖОҚ

76. MS Access. Tables are given “Types of courses”, “Listeners”. When deleting from the table “Types of courses” of data about courses of “hairdressers (парикмахер)” and “designers (дизайнер)”, which entries from the “Listeners” table will be automatically deleted?

77. MS Access. The tables are “Listeners” and “Payment”. What is the result of the next request?

78. MS Access. To determine the number of listeners at each of the courses, which query is correct?

79. MS Access. What kind of query does the following apply to?

80. What is a Multimedia?

Multimedia is the field concerned with the computer-controlled integration of text, graphics, drawings, still and moving images (Video), animation, audio, and any other media where every type of information can be represented, stored, transmitted and processed digitally.

81. What is a Multimedia Application?

A Multimedia Application is an Application which uses a collection of multiple media sources e.g. text, graphics, images, sound/audio, animation and/or video.

82. What is a Animation?

Animation is a sequential series of still images that create an illusion of motion.

83. What is a Video?