Question: Task 1 Create the following tables using Microsoft Access Save the database file as Assignment 2_yourID. (1mark) Create the table, name it as; The table
Task 1 Create the following tables using Microsoft Access Save the database file as Assignment 2_yourID. (1mark) Create the table, name it as; The table 1-Employee table, table 2- Department Table, table 3- Job Table as shown below. (3 marks) Employee table EmpID Name Address Salary DateJoin DeptId E001 Sam Raju Tuatua $38,587.50 10/02/2022 5 E002 Rita Chand Namara $45,202.50 15/02/2000 5 E003 Javed Ali Naseakula $25,000.00 12/02/2023 4 E004 Rahul Chand Namara $32,000.00 28/04/2001 3 E005 Adi Mere Namara $40,000.00 25/06/2000 3 E006 Seru Ramoce Tabia $28,000.00 10/05/2023 4 E007 Kavita Singh Soasoa $25,000.00 10/05/2020 3 E008 Kavita Prasad Tabia $35,000.00 15/12/2015 4 E009 Raju Srivastav Naseakula $40,000.00 12/07/2003 5 E010 Semi Ratuvanua Batnikama $25,000.00 15/06/2022 2 E011 Ratu Tevita Seaqaqa $15,000.00 20/02/2023 2 E012 Ashika Chand Soasoa $32,000.00 15/12/2009 5 Task 2: Relationship Create a relationship between the tables. (1 mark) Task 3: Forms Create form on the Employee table, Department Tabel, Job table and save using a suitable name for the forms. (3 marks) Task 4: Query Query-1. Show details of all employees whose salary is below $35000. (1 mark) Query-2. Show list of employees who are working in the Marketing Department.(1 mark) Query-3. List all employees
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
