I have designed project in Excel as a frontend and Access as a backend. In Access database there are following tables:
1. tblstaff (This table stores all staff names)
2. tblprocess (This table stores all process names)
2. tblAccredit ( This table stores staffname and process name where the staff has been accredited to)
3. tbltraining (This table stores staffname and process name where the staff has been put into training)
Now I want to design MI report in Excel that will fetch data from Access table and store in the excelsheet. The format should be like this:
All staff Names from tblstaff should display in the first column, All process names from tblprocess should be displayed in the first row. And then we need to check the staff names in each table tblAccredit,tbltraining for each process. T is assigned if the staff name has been put into training and A is assigned if the staff is accredited to a process.
Staff Name Cheques Banking Complaint handling
Sarah T A
Smith A T
I hope anyone can help me out in this.