How to Update Data in a Query in Access 2003

Are you having trouble trying to update data in a query in Access 2003? With all the buttons and menus, Access 2003 can seem daunting. Follow these easy steps and the job of updating your query will become much simpler:

Difficulty:

Moderately Easy

Instructions

Things You'll Need

• Computer
• Access 2003

1. Open Access 2003. You can do this by clicking the "Start" button on the bottom left of your screen. Next, choose "All Programs". From this list choose "Microsoft Access".

2. Open the query you wish to update. It is important to note that not all queries can be updated. The type of query will be a big part of your ability to modify it.

3. Change the "Interface View" to the "Datasheet View". Do this simply by clicking on the "Datasheet View" option.

4. Move the cursor over the datasheet to the cell you wish to alter and select it.

5. Alter the data as you see fit. There may be only one updatable selection or there may be several based on the type of query with which you are working.

6. Save the data after it is updated. The table under the datasheet display will reflect your changes. You have successfully updated the data in a query.

Tips & Warnings

• There are alternate ways to edit data in some queries. Use the help menus of the program to help you find them.

• Do not forget to save your progress.