Write down all the data types used in Database management system and their discription
Answers
Explanation:
1.text :it is a default data type it stores text or data that do not require calculations such as mobile number the default size is 50 but it can store up to 255 characters
2.number: it stores numeric data that will be used in calculations
3. currency: it specifies various currencies and displays them in different formats
4. date / time: it stores date and time you can display the date and time in various formats
5. yes /no :this can have two values true or false
6. lookup & relationship: it displays either a list values that is retrieved from a table or query or a set of values that you specified when you created the field the lockup Wizard helps to create a lookup failed the data type can be taxed on number depending on the choices that you make in the wizard
7. memo :its source text like notes and description it stores upto 65536 characters
8. attachment: this special data type allows you to attach external files to an access database
9. hyperlink: this special data type allows you to attach external files to an access hyperlink address it can store up to 2048 characters
10. calculated :this type of data lets you create a field that is based on the calculations of field other fields in the same table
11. OLEobject: it stores pictures graphs sounds and what processing spreadsheet files
12. auto number: its stores in integers whose value increases or decreases automatically as you add or Delete records
hope it helps you
bahut mehnat ki hai eske liye