DATABASE MANAGEMENT SYSTEMS - Practice Mode
1) What is the maximum number of characters allowed in text field is access?
Explanation:
.
2) What is the expansion of OLE in Access?
Explanation:
OLE stands for "Object Linking and Embedding" in Access. It is a technology that allows Access to store and display data from other sources, such as documents, images, and other files, within a database. This allows Access users to link or embed data from other applications directly into their Access database, making it easier to access and manage that data.
3) What is the maximum length of the field name in Access?
Explanation:
In Microsoft Access, the maximum length for a field name is 64 characters. It is important to note that the field name should not contain any spaces or special characters, and should start with a letter or an underscore. Also, field names are not case-sensitive.
4) Which view is used to arrange table data in different graphical layouts to summarize data?
5) Which view allows to modify table's structure in Access?
Explanation:
In Microsoft Access, the "Design View" allows to modify a table's structure. It is a mode that allows you to view and modify the design of a table, including the fields, data types, and properties of the fields. You can also create new tables, add or delete fields, change the data type or field properties, add or delete indexes, and set relationships with other tables. You can access the Design View by right-clicking on a table in the Navigation Pane and selecting "Design View" or by selecting the table and then choosing "Design View" from the "View" menu.