Updating table with data from another table
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.
A text field accepts a smaller number of characters than does a Memo field — from 0 to 255 characters.
In some cases, you can use conversion functions to perform calculations on the data in a Text field.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
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.
For example, you can apply different fonts and font sizes to specific characters in your text, and make them bold or italic, and so on.
You can also add Hypertext Markup Language (HTML) tags to the data.