MS Access: Office and Employee Tables, Joins, and Queries Tutorial
5. Consider the following two tables and perform the operations in MS Access:
Office(Branch_No,Branch_Name, Location)
Employee(Emp_ID, Emp_Name, Branch_No, Salary, Date_of_Joining)
- Create the two tables Show Datasheet View and Design View of those tables.
- Insert at least 5 tuples of records in each table.
- Perform a joining / relationship between those tables using suitable foreign key.
- Perform the following Queries:-
- Display the Employee Details of Asansol Branch.
- Display Branch Details of Employee Mr. Sanjay Gupta
- Display the Employee names whose Salary in between 20000 and 30000
Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects. Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.
To connect with expert and ask your query click here Exam Question Bank