Document Details

LucidCelebration2654

Uploaded by LucidCelebration2654

Ram Narayan Intermediate College

Tags

database access query sql

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

Use Quizgecko on...
Browser
Browser