UPDATED QUERY PDF
Document Details
Uploaded by LucidCelebration2654
Ram Narayan Intermediate College
Tags
Summary
This document provides step-by-step instructions for updating data in an MS Access database table. The steps include opening a database, selecting a table, creating a query, and running the query.
Full Transcript
UPDATED QUERY 1. Change the name of student who have roll 4? 2. Change the address of a student who belongs in roll 5? 3. Change the course of a student who get roll 6 and name sonali sahu? Step-1 Open ms access database and table File->open->database name->open->Right click on table-1...
UPDATED QUERY 1. Change the name of student who have roll 4? 2. Change the address of a student who belongs in roll 5? 3. Change the course of a student who get roll 6 and name sonali sahu? Step-1 Open ms access database and table File->open->database name->open->Right click on table-1 and select open Step-2 Click on create menu select quarry design add table-1 select update quarry from design menu Step-3 step-5 click on run quarry from design menu