Question: Use Microsoft access Q1. Select name, ID, Address from Customer where not city=IBRA; Q2. Select * from Customer where ID Between 1 and 3; Q3.

Use Microsoft access

Q1. Select name, ID, Address from Customer where not city=IBRA;

Q2. Select * from Customer where ID Between 1 and 3;

Q3. Update Customer set City= Muscat where ID= 5;

Q4.Delete from Customer where name= Ahmed and city=IBRA;

Q5.Select * from Customer order by Name Desc;

Q6.

Part C: Write appropriate queries for the following result (Total Marks=5)

ID

Name

City

Email

Salary

1

Fatima

Sur

1@xyz.com

1000

2

Mohammed

Salalah

2@xyz.com

800

3

Khalid

Nizwa

3@xyz.com

1000

4

Ahmed

IBRA

4@xyz.com

900

5

Abdullah

Muscat

5@xyz.com

400

Use the above table to create Query

Question 16

Not yet answered

Marked out of 1.00

Flag question

Question text

Name

City

Fatima

Sur

Mohammed

Salalah

Khalid

Nizwa

Ahmed

IBRA

Abdullah

Muscat

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!