Updating bulk data
You can use the commands on the Datasheet tab, or you can open the table in Design view.
The following sets of steps explain how to use both techniques.
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 table lists the data types that Office Access 2007 provides and describes how they affect data entry.
Text fields accept either text or numeric characters, including delimited lists of items.
You use this type of field when you want to display data from a file created in another program.
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.
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.of some 5000 records, so the new data are presenting in an excel sheet.