Microsoft Access Database Structure
Microsoft Access database has several objects such as table form query & report. And when we create MS Access table all information we enter into the table will be stored columns or fields. Field is a part the table which cannot be made without it. Up to 255 fields can be stored the table even though is recommended to have a smaller amount. The more fields you create the table the more information will be stored & the bigger the table will get. Smaller amount data & fields leads to better database performance while bigger files can lead to database corruption.
Fields have different data types & when you create Access fields is important to select the right data type. It is possible to store a price as a text data type course. But would be better to store as a numeric data type. It might lead to a lot problems & confusions if you need to perform calculations with the data but is stored text data type.
Text data type field can hold text or a text & numbers combination. It can hold such data as post code & telephone number as well.
Memo data type is great for storing large texts. There are times when you need to add long descriptions or notes to your database. This is when you would use memo data type
There is also number data type which is used for entering numeric information like monetary amounts or unit price. Actually any data type which can be used calculations should be stored number data type field.
The date/time data type field is perfect for storing dates & time & years from 100 till 9999.
Fields with currency data type are used to store values used calculations that have one to four decimals. You can also add a currency symbol next to the value.
Autonumber field increments by one every time you add a new record. This field data type is good for storing unique record identifier or primary key.
Yes/No field data type is used to store true or false values. You can only store one two values this field.
OLE objects data type field are used to store objects that are embedded Access table as images Word documents sounds or Excel spreadsheets.
In hyperlink field you can store hyperlink web address that is used to link to website or Access object such as a report or form.
You can also use MS Access fields as controls forms which can be very useful for performing different tasks. It is worth spending some time to define the right data type for your MS Access field when you design your database because may save you time & some database problems future.
The sphere computers & computer applications grows all the time. But you can turn this issue into your strong point by catching up with this knowledge & becoming a pro for example microsoft access database niche.
Please visit this website that specifies microsoft access database topic & has a great line microsoft access database products available.