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.For information about entering new data in a database, see the article Add one or more records to a database.
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.
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.
When you design a database table, you select a data type for each of the fields in that table, a process that helps ensure more accurate data entry.
For example, suppose you specify the Number data type for a field because you need to calculate sales figures.In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.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.By default, Access applies the currency symbol ( ¥, £, $, and so on) specified in your Windows regional settings.When you click a field that is set to this data type, Access displays either a check box or a drop-down list, depending on how you format the field. 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.As you proceed, remember that updating data is not the same process as entering new data.You can enter large amounts of text and numeric data in this type of field.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.