Hi all
So I have a dilemma on how to approach this, disclaimer i am by no means an access expert.
I have a very time consuming manual form I have to go through on separate occasions (concept, design, implementation, sign off) when progressing through a project..
Essentially it has 2 parts:
A single front page table (dates, participants, project titles etc) which is updated briefly on the occasions it is opened but the project title etc remains the same:
And a series of Yes/No/NA questions (250 of them which are the same every time).
The idea is to eliminate all the No answers to either a yes or a NA.. (health and safety box ticking exercise Grrr)
Instead of tabbing through some small fonted word doc that was written badly in the 90's I want to try to create a simple DB that allows me to bring up a form and tab through the displayed questions and click the answer as a Yes/No/NA.
My issue comes when i have to go through the same Yes/no/NA questions that follow each stage.
I started looking at each question as an individual field but i found the the questions are just too long for a sensible field name.
This was basically my limit of Access knowledge and I was stumped on how to approach it so i thought i would ask before going down the wrong path.
I can easily go into excel and create something where I tab down each line and add in a cross on the relevant column if this is though to be more appropriate, but i really would like to use Access (2010) and brush up on my skills at the same time as its been a while since i used it last.
Thanks all