Software

Ask something
Discussion Locked

MS ACCESS HELP-Status Reports Forms

0 helpful
3 replies

by rafay.baig

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am currently in charge of monitoring my divisions weekly status reports. At the end of each week everyone in my division sends me their status report in word format. It is my job to take all of the status reports and make a status report summary.

As of right now, its been a cut and paste job. I would really like to use Microsoft Access to automate this process by creating some type of form, to make it much more organized and uniform. Anyone, PLEASE adivise me on how i should go about accompolishing this, given my limited MS Access knowledge. Secondly, are there any templates out there that resemble, or are similar to what I am suggesting.

Any input would be much appreciated.

Thanks

Rafay

3 replies

by dklippert

While Access works just fine, you maybe more comfortable using Excel. If you layout a Word template with the information in a table, you can copy and paste the table into Excel.
Massage the numbers, then use the Excel worksheet as a basis for a Word mail merge report.

by mariobrf

Going for MS Access might be an interesting option since you can have your colleagues populating the data in a central database and you would not be required anymore to do the cut&paste job :-)
I suggest to start with templates available in the microsoft pages for Office and start quick learning.
After you get reasonable knowledge, go for getting interfaces via your intranet to populate the database.
Pay attention that your company network needs to be ok for all users in order to avoid problems to your remote colleagues to populate their reports.
Hope this helps
Mario

by kristigarcia

I was assigned the tack of creating a weekly report for my IT organization and wanted to implement a red/yellow/green report and still deciding on which template to use? Have any ideas? Thanks, Kris

This discussion is closed to new replies.