alrite heres the situation -
my boss just dropped about 600 sheets of paper on my desk … these “papers” are student records from the educational institute i work at… she wants me to extract the following from the paper and manually input it all into excel “Student Name” “Student ID” “Date” “Class Code” “Institutional” “Time (Minutes)”
it’ll prolly take me a good 2-3 hours going thru the whole pile but i am sure there is a way of designing some type of database where once i start entering the info it can autofill the rest of the field. i also want to create a simple interface so that others at work can work into a web page based input system rather than excel itself? my boss later wants to generate reports from the entered data…
can someone point me in the right direction please other than a new job ? lol
if u have entered some data in excel, excel does give an autofill by typing the first few characters of the entry....
but i dont think it will help in this case....
i'm sorry, i guess i wasn't very clear - what i meant to say is that once entered and it needs to be entered again it should come up after a first couple of characters typed
It’s pretty easy. You seem to be new with excel as well, you better stick to it… It really has good auto fill feature but that you don require. As far as I understood you’ve got a lot of students… haven’t you? So why would you go after auto fill? As each student’s data would differ from others for sure?
Even excel has great data entry features, only thing required is that you know ‘em. My advice? First manually complete your job in excel to save your new job and escapin’ you boss’s fury. At leisures you may visit web in order to learn ASP (Active Server Pages) and MS Access and only these two should be your start (after HTML offcourse). Your boss really wants a database type of thing.
What you need will be:
A Web Server (dont panic… it will still be your own computer)
Microsoft Access
Macromedia Dreamweaver
and to know how to start with them go to:
h t t p : / / w w w . W e b T h a n g . c o . u k /
Remember! take lessons step by step. Dont ever try to jump to new things or your learning pace might go down. For any excel or Dreamweaver help, I’m here but for ASP, don’t come to me; web is already full of coding. I know no ASP, Dreamweaver does it for myself.
Access
Dreamweaver