Podcast
Questions and Answers
What is the first step to change the name of the student with roll 4?
What is the first step to change the name of the student with roll 4?
- Open the ms access database and locate the table. (correct)
- Click on create menu and select query design.
- Select update query from the design menu.
- Run the query from the design menu.
Which roll number student needs their address changed?
Which roll number student needs their address changed?
- Roll 6
- Roll 5 (correct)
- Roll 3
- Roll 4
How do you start creating an update query in ms access?
How do you start creating an update query in ms access?
- Access query design first and then add table-1. (correct)
- Use the open file menu to select the database.
- Run the update query to make changes.
- Select update query from the create menu.
What did the student with roll 6 need to change?
What did the student with roll 6 need to change?
What action is performed to execute the update query?
What action is performed to execute the update query?
Flashcards
Update student data
Update student data
Modifying existing student information in a database table.
MS Access Database
MS Access Database
A software application used to manage and store data in tables.
Query Design
Query Design
Creating instructions for data manipulation in MS Access.
Update Query
Update Query
Signup and view all the flashcards
Run Query
Run Query
Signup and view all the flashcards
Study Notes
Updated Query
- Change student name with roll 4
- Change student address with roll 5
- Change student course for roll 6 and name Sonali Sahu
Step 1
- Open MS Access database and table
- Locate the table
- Right-click on the table and select 'Open'
Step 2
- Click on 'Create' menu
- Select 'Query Design'
- Add the table
- Choose 'Update Query' from design menu
Step 3
- No specific step 3 in the image, move on to step 5
Step 5
- Click 'Run Query' from design menu
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.