Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Is Access the right way to go?

Is Access the right way to go?

Is Access the right way to go?

Good Morning,
I am a new comer to the forum, and I hope I have the right area to ask this question.
At my job, we submit end of shift reports for maintenance technicians. They pass on what happened during the shift to the oncoming technicians, and are usually done via email. This does not lend itself well to searching for specific information within the emails.

We are a new launch department, and have the opportunity to set things up for the future that will help troubleshoot and archive data based on the lessons learned.
So I was thinking of setting up an Access database that the techs could use to submit these reports. That way we could reference back to what was done in the past on a particular machine, and cut down on troubleshooting time.

Since I'm not that experienced in writing databases, I was looking at using a template for the reports. Also I was thinking that it would require some kind of a front end application to access the data, and not use the MS Access as a front end. Not sure.
Any ideas would be appreciated.

RE: Is Access the right way to go?

I love Access and it is certainly up to the task of creating a shift handoff. It would be easiest to use Access as both the front end and back end.

However, do you have SharePoint installed at your work? It would be much easier to create a simple list that could be filtered as needed.

Hook'D on Access
MS Access MVP 2001-2016

RE: Is Access the right way to go?

We do have share point here. Although I don't know how to put a form on it, and make it searchable like access queries. Is that possible?

RE: Is Access the right way to go?

Do you need a custom form? You can create dropdowns in SharePoint as well as multiple views of the same list using various filters.

I guess you might need to focus on the requirements and vet your options.

Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close