Large updates become much easier to perform when you understand some of the basic principles of database design.An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.View data types by using commands on the Datasheet tab The data type set for each table field provides the first level of control over what you can and cannot enter into a field.In some cases, a data type setting prevents you from entering any information at all. Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
Also, if the database designer sets the field to support rich text formatting, you can apply the types of formatting that you normally find in word processing programs, such as Office Word 2007.
You use this type of field when you want to display data from a file created in another program.
For example, you can display a text file, an Excel chart, or a Power Point slide deck in an OLE Object field.
Attachments provide a faster, easier, and more flexible way to view data from other programs.
See the Attachment entry, later in this table, for more information.
For more information about using rich-text formatting in a Memo field, see the article Format data in rows and columns.