Updating database with adapter


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 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.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.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.



The following sets of steps explain how to use both techniques.

The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.