Batch Modify field instances in Access 2003

Although now because of the data storage capacity, data processing speed needs, access has gradually exited the family of relational databases, but for many schools and remote computer systems in particular in the country and some of the system is using Access 2003, today also a database table modification needs, revisit this knowledge.

To use more than 2003 versions of Access,

Now it is necessary to the table Nc_flashlist in the title field of the "Small game download" all changed to "online games." The operation is as follows:

After you open the database, query---> Create a query in Design view,

Then close the pop-up window, right-click in the margin, and select SQL view.

Then enter the SQL statement in the blank space:

Update nc_flashlist set Title=replace (title, ' Little Game Download ', ' online games ')

The exclamation point in the last dot toolbar to execute the command

SQL Statement Description:

Update [table name] set [field name]=replace ([Field name], ' AA ', ' BB ')