Question: Project Requirements: Managing and analyzing data using MS Access and MS Excel Task l: 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 l: 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, DepartmentlD Sheet 2: DepartmentID, DepartmentVame 2 Marks] Task 2 : Create a Database file and name it [Company Info] Then, Import MS Excel sheets into as an MS Access table. [2 Marks] Task 3: Assign the primary key for each table. [l Mark] [2 marks] Task 5: Create Customer query to display: EmployeelID, HireDate where the Salary is 20000 Task 4: Create relationship between the tables. 3 marks] Task 6: Save the query under the name "Employee Task 7: Add the suitable criteria to display EmployeeID, EmployeeName, and D [l mark] ame 3 marks] Task 8: Save the query under the name "Departments Task 9: Create a form by using form wizard that is based on the Employee table to display all the employee details, save it under the name "Employee Info" [1 mark] 3 marks] Task 10: Create a report by using report wizard that is based on the Department table to display all Department details, save it under the name "Department info" 2 marks] Task ll: Describe the work you did and answer the oral questions [10 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!