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.
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.
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.
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.
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 information about entering new data in a database, see the article Add one or more records to a database.Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.You use this type of field when you want to display data from a file created in another program.