Windows XP 
Access 2007
Hey all,
I recently moved into a IT Helpdesk role and we have a quick reference guide that holds all of our data for escalations. Example: Problem - Description - Tier 1 - 3 support groups - Approvals needed - Troubleshooting steps.
We have around 600 entries and we were using an HTML based page to house the information. Recently we switched to access and the interface for searching through the data is...not user friendly.
What I am wondering is if there is a way to create a new interface that lists all the data so that we can sort as we want and search through a full page for the information, not a new window for each search result. Example: I want it to look like a webpage. I want new analysts to be able to search for a certain department that does Tier 2 support and to see all the escalations/programs that they handle all on the same page. As it is right now a new page comes up for each search, so we can search for that Tier 2 support group but we just mash enter until we find the right result.
I am not sure if this is possible in Access and I don't know if it's easy to do such a thing. Nor do I know if I am even making any sense. My wish is that we would stay away from Access because I do not know enough of it, but this isn't an option. They want to use access for easy exporting of data if we ever head into building our own library.
I'm not opposed to even scrapping the use of Access and go with a MySQL type thing, however I am again at a loss of knowledge about it.
I am hoping someone can tell me the following:
If it's possible for Access to display the data we have stored, sorted and viewed on a full page.
If Access cannot do this, or if there is a better way/program to use to do it, what this program is.
Perhaps suggest a beginners how to book I can purchase.
I am not looking for someone to do the work for me, but I am hoping someone with this knowledge will help me to get started.
Reply With Quote
