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:
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:
| ||||||||||||||
| ......................................................................................................................... | 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. | |||
