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:

https://streamable(DOT)com/yvrizw

Explanation:

Replace the (DOT) with a period. It's a video of me explaining the answer :D Hope it helps!