What is the equivalent attribute of currency data type

1. The currency data type is equivalent to the numeric data type with what attributes
access allows nine data types: text, remarks, numeric value, date / time, currency, auto numbering, yes / no, OLE object, hyperlink and Query Wizard. In the design view of a table, each field has a design type

text: this type allows a maximum of 255 characters or numbers. The default size of access is 50 characters, and the system only saves the characters entered into the field, not the empty characters in the unused position in the text field. You can set the field size property to control the maximum length of characters that can be entered

note: this type is used to store long text and numbers. It allows fields to store up to 64000 characters. But access can't sort or index the memo field, but it can sort and index the text field. Although the text can be searched in the note field, it is not as fast as in the indexed text field

number: this field type can be used to store digital data for arithmetic calculation. Users can also set the "field size" attribute to define a specific number type. Any font type specified as a digital data type can be set to "byte", "integer", "long integer", "single precision number", "double precision number", "synchronous ID", etc There are five types of decimal. In access, the default is double

date / time: this type is used to store date, time or date time together. Each date / time field needs 8 bytes of storage space.

2. Digital type

3.

Access database provides 10 data types for fields: text, remark, value, date / time, currency, auto number, yes / no, OLE object, hyperlink, Query Wizard. In the design view of a table, each field has a design type

1. Text type

is used to input data of text or combination of text and number. The maximum length is 255 characters (bytes), and the default value is 50. In access, every Chinese character and all special characters (including Chinese punctuation) are counted as one character. If less than 50 characters are assigned to the string, the deficiency of empname is filled with spaces

2. Currency type

is used to store currency value, accounting for 8 bytes, and rounding is prohibited in calculation. This type is a special type of numeric data type, which is equivalent to numeric field type with double precision attribute. When you enter data into the currency field, you do not need to type the RMB symbol and the comma at the thousand place. Access will automatically display the RMB symbol and comma, and add two decimal places to the currency field

3. Digital

is used for data that can be numerically calculated, except for currency. According to the field size, the numeric field is divided into seven types: byte, integer, long integer, single precision, double precision, synchronous ID and decimal, accounting for 1, 2, 4, 4, 8, 16 and 12 bytes respectively. Expression: write directly. For example: 3246291

4, date / time type

is used to store date and / or time value, accounting for 8 bytes. Expression method: use English character #. For example, # 2010-02-25 #, # 02 / 25 / 2010 #, # 2010-02-25 15:30 #, # 2010-02-25 3:30pm #, # 15:30 #, are legal expressions. But note: there should be a space between the date and time

5. Automatic numbering type

is used to automatically insert the serial number (increasing by 1 or random number each time) when adding records. The default is long integer type. It can also be changed to synchronous ID. AutoNumber cannot be updated

6, yes / no type

is used to express logical value (yes / no, true / false), accounting for 1 byte. Representation. T.. F. true false. This kind of field is set up for a field which only contains two different optional values. Through the format characteristics of yes / no data type, users can select Yes / no fields

7, remark type

is used for long text or combination of long text and numbers (more than 255 characters), with a maximum length of 65535 characters. This type is used to hold long text and numbers, and it allows fields to store up to 64000 characters of content. But access can't sort or index the memo field, but it can sort and index the text field

8, OLE object type

is used for OLE objects (such as word documents, Excel spreadsheets, pictures, sounds, etc.) created in other programs using OLE protocol, and the maximum storage is 1GB (limited by disk space)

9. Hyperlink type: used to store hyperlink address, with a maximum of 64000 characters. Hyperlinks can contain up to three parts: first, the text displayed in the field or control; The second is the path to the file or page; The third is the address in the file or page. The easiest way to insert a hyperlink address into this field or control is to click the hyperlink command on the Insert menu

10. Look up wizard

allows users to select values from other tables or value lists through combo boxes or list boxes. The actual field type and length depend on the data source

4.

Access database provides 10 data types for fields, which are as follows:

1. Text: used to input data of text or combination of text and number, the maximum length is 255 characters (bytes), and the default value is 50. In access, every Chinese character and all special characters (including Chinese punctuation) are counted as one character

2. Currency: it is used to store currency value, accounting for 8 bytes, and rounding is forbidden in calculation

3. Number: data that can be used for numerical calculation, except currency. According to the field size, the numeric field is divided into seven types: byte, integer, long integer, single precision, double precision, synchronous ID and decimal, accounting for 1, 2, 4, 4, 8, 16 and 12 bytes respectively

4. Date / time type: used to store date and / or time value, accounting for 8 bytes

5. AutoNumber: it is used to automatically insert the serial number (increasing by 1 or random number each time) when adding records. It is long integer by default and can also be changed to synchronous ID. AutoNumber cannot be updated

6, yes / no type: used to represent logical value (yes / no, true / false), accounting for 1 byte

7. Memo: used for long text or combination of long text and numbers (more than 255 characters), with a maximum length of 65535 characters

8. OLE object: it is used for OLE objects (such as word documents, Excel spreadsheets, pictures, sounds, etc.) created in other programs using OLE protocol. It can store up to 1GB (limited by disk space)

9. Hyperlink: used to store hyperlink address, with a maximum of 64000 characters

10. Lockup Wizard: allows users to select values from other tables or value lists through combo box or list box. The actual field type and length depend on the data source

source of reference: network Microsoft Office Access

source of reference: network data type source of reference

5. Money
monetary data
monetary data represents a positive or negative monetary value. In Microsoft & # 174; SQL Server™ In 2000, money and smallmoney data types are used to store money data. The accuracy of currency data storage is four decimal places. The range of values that can be stored in the money data type is - 922337203685477.5808 to + 922337203685477.5807 (8 bytes of storage space required). The range of values that can be stored in the smallmoney data type is - 214748.3648 to 214748.3647 (4 bytes of storage). If the value exceeds the above range, the decimal data type can be used instead

decimal data contains data stored on the least significant number. In SQL server, decimal data is stored by decimal or numeric data type. The number of bytes required to store a decimal or numeric value depends on the total number of digits in the data and the number of decimal places to the right of the decimal point. For example, storing the value 19283.29383 requires more bytes than storing 1.1

in SQL server, numeric data type is equivalent to decimal data type.

6. How to say, the so-called question banks are all false. Who will know what questions to test, unless the Question Maker sells his own questions. However, these are the summary of the examination questions for many years, and there are always several questions that are the same
I hope they can help you.

7. The field property uses remarks, because the text is the record name, address... Oh ~ ~ no more, Let's see for ourselves: access data type complete statement modify the field type in access alter table tb alter column AA byte number [byte] alter table tb alter column AA long number [long integer] alter table tb alter column AA short number [integer] alter table tb alter column aa single number [single precision alter table TB alter column AA double number [double precision] al Ter table tb alter column AA currency alter table tb alter column AA char text alter table tb alter column AA text (n) text, Where n is the field size alter table tb alter column AA binary alter table tb alter column AA counter auto number alter table tb alter column AA memo remark alter table tb alter column AA time date / time in the design view of the table, each field has a design type, and access allows nine data types: text, remark, numeric value, date / time Date / time, currency, AutoNumber, yes / no, OLE object, hyperlink, Query Wizard. Text: this type allows a maximum of 255 characters or numbers. The default size of access is 50 characters, and the system only saves the characters entered into the field, not the empty characters in the unused position in the text field. You can set the field size property to control the maximum length of characters that can be entered. Note: this type is used to store long text and numbers. It allows fields to store up to 64000 characters. But access can't sort or index the memo field, but it can sort and index the text field. Although the text can be searched in the note field, it is not as fast as in the indexed text field. Number: this field type can be used to store digital data for arithmetic calculation. The user can also set the "field size" attribute to define a specific number type. Any font type specified as a digital data type can be set to "byte", "integer", "long integer", "single precision", "double precision", "synchronous replication ID", etc There are five types of decimal. In access, the default is double. Date / time: this type is used to store date, time or date time together. Each date / time field needs 8 bytes of storage space. Currency: this type is a special type of numeric data type, which is equivalent to numeric field type with double precision attribute. When you enter data into the currency field, you do not need to type the RMB symbol and the comma at the thousand place. Access will automatically display the RMB symbol and comma, and add two decimal places to the currency field. When there are more than two decimal places, access will round the data. The accuracy is 15 digits to the left and 4 digits to the right of the decimal point. Automatic numbering: this type is special. Each time a new record is added to the table, access will automatically insert a unique sequence or random number, that is, specify a value in the automatic numbering field. Once the AutoNumber is specified, it is permanently connected to the record. If you delete a record in a table that contains an AutoNumber field, access will not renumber the AutoNumber field. When adding a record, access no longer uses the value of the deleted auto number field, but re assigns the value according to the increasing rule. Yes / No: this kind of field is set up for a field containing only two different optional values. Through the format characteristics of yes / no data type, users can select Yes / no fields. OLE object: this field means that the field allows to "link" or "embed" OLE objects indivially. When adding data to OLE object fields, OLE objects that can be linked or embedded in access tables refer to objects created in other ole protocol programs, such as word documents, Excel spreadsheets, images, sounds or other binary data. OLE object fields can be up to 1GB, which is mainly limited by disk space. Hyperlink: this field is mainly used to save the hyperlink, including the text as the hyperlink address or the combination of characters and numbers stored in the form of text. When you click a hyperlink, the web browser or access will reach the specified destination according to the hyperlink address. Hyperlinks can contain up to three parts: first, the text displayed in the field or control; The second is the path to the file or page; The third is the address in the file or page. The easiest way to insert a hyperlink address into this field or control is to click the hyperlink command on the Insert menu. Look up Wizard: this field type provides users with a list of field contents. You can select the contents listed in the list as the contents added to the field

if it helps you, please remember to adopt it as a satisfactory answer. Thank you! I wish you a happy life! vae.la

8. Generally, money or decimal or numeric is used instead of float or double, because & quot; Distortion & quot

the accuracy of money data storage is four decimal places. The range of values that can be stored in the money data type is - 922337203685477.5808 to + 922337203685477.5807 (8 bytes of storage space required)

in SQL server, numeric data type is equivalent to decimal data type. The number of bytes required to store a decimal or numeric value depends on the total number of digits in the data and the number of decimal places to the right of the decimal point.

9. With the help of Excel to achieve! 1. Select the "many, many lines of text content" to be operated, and then click: table, conversion, text conversion to table... 2. Select the table, right-click and . 3. Create a new EXCEL file, select A1, right-click, paste 4, input function in A2: = if (len (A1) & gt= 6,A1," & quot;) 5. Fill this function all the way to the end of the table. 6. Select all the contents, right-click and . 7. Open the original word file, select the upper left cell of the table, right-click and paste. 8. Convert the table to text (the same steps as 1). 9. Remove the blank line with search and replace (check ^ p ^ P, replace ^ P). It's all finished!