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.
For information about entering new data in a database, see the article Add one or more records to a database.
Updating dd form 93
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.
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.
In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.
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.
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.
You can use the commands on the Datasheet tab, or you can open the table in Design view.