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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!