Microsoft AccessThe lesson for today on how to create forms, and I consider that the establishment of models is the most beautiful in Alakss
But before you start to create a simple partial models learn to design tables This is a partial supplement to the
We have learned in previous lessons of this part is to find out what types of fields heya data that will be included by: -
Home
What kind of data you want to use a field from the fields of the table???
What kind of values that you want to enter in the field? For example, you can not store the type of
Data "text" in the field of data type "number".
What is the amount of storage space that you want to use in the field?
What are the types of operations that you want to perform on the values in the field? For example, can
Microsoft Access compilation of the values in the fields "number" and "currency", but can not collect the values in the
Fields, "text" and "Object OLE"
Now we see when you open the table in Design view in the picture as Homhdd types of names of the types of
Data will be entered in each field such as text - note - No. ....... etc.
Here's an explanation for the use of each of them: -
1 (Text) to store data such as names, addresses, and any numbers that do not require calculations, such as phone numbers,
Numbers of goods or postal codes. Can field "text" that stores a maximum of 255 characters, but the size
Default field is 50 characters. Control property (field size) in determining the number of characters that can be
Entered in the field of "text".
2 (note) you need to store more than 255 characters. Field can "note" that stores the number of
Lines or 65 536 characters max.
3 - (number) to store any digital data can be used in mathematical calculations, except
Accounts that have entered the money or that require a high degree of accuracy. Is controlled in the type and size
For numeric values that can be stored in the field of "Number" by setting the property (field size)
4 - (date / time) to store the date and time a j hours
5 - (currency) to store financial figures (YR, pounds, dinars, pounds, Aldrihammmmmm)
6 - (AutoNumber) to create fields and enter the numbers automatically when a record is added. Once you create a number
For the record, can not be deleted or changed "automatic numbering" growing by 1 is the most "numbering
Automatic "is also commonly the best choice for use as the primary key for the table.
But before you start to create a simple partial models learn to design tables This is a partial supplement to the
We have learned in previous lessons of this part is to find out what types of fields heya data that will be included by: -
Home
What kind of data you want to use a field from the fields of the table???
What kind of values that you want to enter in the field? For example, you can not store the type of
Data "text" in the field of data type "number".
What is the amount of storage space that you want to use in the field?
What are the types of operations that you want to perform on the values in the field? For example, can
Microsoft Access compilation of the values in the fields "number" and "currency", but can not collect the values in the
Fields, "text" and "Object OLE"
Now we see when you open the table in Design view in the picture as Homhdd types of names of the types of
Data will be entered in each field such as text - note - No. ....... etc.
Here's an explanation for the use of each of them: -
1 (Text) to store data such as names, addresses, and any numbers that do not require calculations, such as phone numbers,
Numbers of goods or postal codes. Can field "text" that stores a maximum of 255 characters, but the size
Default field is 50 characters. Control property (field size) in determining the number of characters that can be
Entered in the field of "text".
2 (note) you need to store more than 255 characters. Field can "note" that stores the number of
Lines or 65 536 characters max.
3 - (number) to store any digital data can be used in mathematical calculations, except
Accounts that have entered the money or that require a high degree of accuracy. Is controlled in the type and size
For numeric values that can be stored in the field of "Number" by setting the property (field size)
4 - (date / time) to store the date and time a j hours
5 - (currency) to store financial figures (YR, pounds, dinars, pounds, Aldrihammmmmm)
6 - (AutoNumber) to create fields and enter the numbers automatically when a record is added. Once you create a number
For the record, can not be deleted or changed "automatic numbering" growing by 1 is the most "numbering
Automatic "is also commonly the best choice for use as the primary key for the table.
Aucun commentaire:
Enregistrer un commentaire