Question
1. Create an Excel file for Employee. a. Add the columns EmpName, EmpID, EmpAddress, EmpPhone, EmpSalry and EmpDesignation . b. Insert 5 Employee record. 2.
1. Create an Excel file for Employee.
a. Add the columns EmpName, EmpID, EmpAddress, EmpPhone, EmpSalry and EmpDesignation .
b. Insert 5 Employee record.
2. Integrate Exel file (Employee table) in Access database.
a. Delete filed EmpAddress and add new field Old-address and Newarrdess in Access database table Employee.
b. Add field EmpTax in Employee Table.
c. Write the steps on reflected changes.
3. Now Integrate Employee table in word.
a. Change the EmpAddress in excel and update data automatically in word
b. Change salary of employee in excel and update automatically in word.
c. Show the reflected changes. Write down steps.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started