I suck at access

hjahmad

New Member
Ive been trying to build an access database, but all the online references dont help at all for what im trying to do. and i feel like its stupidly simple.
maybe it can even be done in excel

i need to keep a record of users having their passwords reset.
i figured to just have a spreadsheet, with users vs. system name.
but everytime i enter something new, in to the corresponding cell for a given user on a given system, it should keep a history of that user's resets on that system. and if possible, a history log of the user for all the systems entries that were recorded.

any ideas?

thanks
 
Access is not easy. Its a learning curve. Excel is good if just hundreds of entry's. Very slow if you try to search. My suggestion is a local book store. Read the preface from the author in the front of the book. Who is he catering too. Might want beginner to intermediate. Im sure you could also find an ebook on line. just a book as a document like PDF file.
 
excel might be easier.
two columns: user name and system
everytime you reset their password, just enter it in the spreadsheet. excel lets you sort and count how many times an entry has been made.
 
Excel is easier. Not for searching thousands or hundreds of thousands of entry's.
Access is the same i think. Just a different animal.
Its powerful and fast. Likely written up in machine language.
The diff in speed for business was 15 min vs a second.
This was for the corp i worked for. And no, they had a tech show me how.
still don't understand. Just say get,em in here and this is want i want in the database.
 
Last edited:
excel might be easier.
two columns: user name and system
everytime you reset their password, just enter it in the spreadsheet. excel lets you sort and count how many times an entry has been made.

how do i go about building it in excel?
will it be able to append each entry made and have easy recall?
 
Back
Top