Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OpenStack Trove

Authors: Amrith Kumar, Douglas Shelley

1st Edition

1484212215, 9781484212219

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago