Question

Create below table : MANAGER in Libreoffice Base/MS Access. Write queries for the following :
a) Display department name where city is Chennai
b) Display record of Preeti Arora.
c) Arrange all the records in ascending order department wise.
d) Change the Deptname HR to Admin HR.
e) Insert a new record (S102, Admin, Ananya Jain, Delhi)
f) Delete record of Pranjal Sharma

Answer 1

Answer:

Display department name where city is Chennai. 2Q. Display different cities in the manager table. 3G Arrange all the record in ascending