Question: Project Requirements: Managing and analyzing data using MS Access and MS Excel Task 1: By using Ms. Office Excel create two Work sheets and enter
Project Requirements: Managing and analyzing data using MS Access and MS Excel Task 1: By using Ms. Office Excel create two Work sheets and enter the columns below in each sheet and then insert ten records below these columns. Sheet l: EmployeelD, HireDate, EmployeeName, Salary, DepartmentID Sheet 2: DepartmentID, DepartmentName 12 Marks] Task 2 : Create a Database file and name it [Company Info]. Then, Import MS Excel sheets into Task 3: Assign the primary key for each table. Task 4: Create relationship between the tables. Task 5: Create Customer query to display: EmployeelD, HireDate where the Salary is >20000 as an MS Access table. [2 Marks] [I Mark] 12 marks]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
