1. What is the use of extended data types? Explain the function of each.
2. A…………. field allows whole numbers from 0-255.
3. What is SQL?
4. Write the full forms of a) DDL b) DML c) SQL
5. ……………. and ………….. are two types of DML commands.
6. ………….. statement allow you to update or modify data into the database.
7. Which statement is used to retrieve the data from the database?
8. Press …………………..keys together to move to next record.
9. Give one method to set primary key.
10. ……………….. icon is like a toggle switch.
11. Primary key option is present under the …………. Group and ……………. Tab.
12.By default Access sets the primary key to …………… filed.
13. What are DDL and DML commands used for? Give two examples of each.
Answers
Answer:
1)st answer
°Extended data types (EDTs) are user-defined types, based on the primitive data types boolean, integer, real, string, and date, and the composite type container. You can also base EDTs on other EDTs.
°This feature is not implemented as a language construct. EDTs are defined in the Application Object Tree (AOT).
°An EDT is a primitive data type or container with a supplementary name and some additional properties. For example, you could create a new EDT called Name and base it on a string. Thereafter you can use the new EDT in variable and field declarations in the development environment.
.
2nd answer.
Single Byte
.
3rd answer
SQL stands for Structured Query Language. A query language is a kind of programming language that's designed to facilitate retrieving specific information from databases, and that's exactly what SQL does. To put it simply, SQL is the language of databases.