Microsoft Access 2007 tutorial: Update and Delete Query

Update and Delete Query



X. Update Query

You can use update query to update data in a table. For example, update address field of  TblTeacher by replacing PP with Phnom Penh. To do so, follow the steps below:

- Click Create tab

- Click Query Design, in Macro group, on the Ribbon

- Click TblTeacher, in the list of Show Table dialog box

- Click Add button

- Click Close button

- Drag and Drop necessary fields

- Click Update Query icon

- Type Phnom Penh and PP as shown below:

Microsoft Access 2007 Update Query

XI. Delete Query

You can use delete query to delete data in a table. For example, delete book records that contain BookID equal to B004. To do so follow the steps below:

- Click Create tab

- Click Query Design, in Macro group, on the Ribbon

- Click TblBook, in the list of Show Table dialog box

- Click Add button

- Click Close button

- Drag and Drop necessary fields

- Click Delete Query Icon

- Type B004 as shown below:

Microsoft Access 2007 Delete Query



Comments

Name:
Comment:
Enter the text:
CAPTCHA image

.........................................................................................................................Home | Forum | About | Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word.
However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like