In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.
In some cases, you can use conversion functions to perform calculations on the data in a Text field.Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.If someone tries to enter text in that field, Access displays an error message and will not let that user save the changed record, a step that helps protect your figures.Show me how to view data types Access now provides two ways to view the data types for a table field.For more information about using rich-text formatting in a Memo field, see the article Format data in rows and columns.
Like Text fields, you can also run conversion functions against the data in a Memo field.
If you format the field to show a list, you can select either Yes or No, True or False, or On or Off from the list, again depending on the format applied to the field.
You cannot enter values in the list or change the values in the list directly from a form or table.
You can enter only currency values in this type of field.
Also, you do not have to manually enter a currency symbol.
The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.