Is Access a practical solution to track disciplinary/grievance cas

[AndyHRM]

Hi

I work in the HR department of a large company, at present all of our
disciplinary and grievance cases are stored on a very messy outdated excel
spreadsheet. I have been given the task of updating the way we record
information and I thought Access might provide the solution.

Has anyone had any experience of using Access for this type of function, if
so please can you provide me with some advice?

Cheers

 

[Tom van Stiphout]

On Wed, 24 Feb 2010 05:55:01 -0800, AndyHRM

Yes, generally speaking Access is suitable for that. But if this is
your first time developing an application with Access, it may be too
much for you. Then I would recommend finding professional help.
"Microsoft Solution Provider" in your yellow pages is one way to find
it.
Or buy an off-the-shelf package; there must be some out there.

-Tom.
Microsoft Access MVP

 

[GP George]

Access is a very powerful tool, but you must keep in mind that it is a tool
with which you build other tools. To put it another way, Access is a
development tool, not an end product. The question is not whether Access is
suited for this type of application. The question is whether you, the
developer, will be able to make effective use of the tools in Access to
create this type of application.

In your case, Access most certainly can be used to create that application,
but YOU provide the business logic and rules that determine how that
application works. Moreover, as Tom has already pointed out, it is not an
"easy-squeezy" little task to put together a robust database application.
You need, in addition to your business knowledge, a fairly decent
understanding of database development. That's the part where you probably do
want professional assistance.

George

 

[Steve]

Andy,

I would like to offer to build the datavase for you. I provide help with
Access, Excel and Word applications for a small fee. I could also import
your existing cases in Excel. Since you already have the Excel spreadsheet,
it could be used as a basis for creating the database saving alot of time.
My fee to help you would be very modest. Contact me.

Steve
(e-mail address removed)

 

[John... Visio MVP]

Andy,

I would like to offer to build the datavase for you. I provide help with
Access, Excel and Word applications for a small fee. I could also import
your existing cases in Excel. Since you already have the Excel
spreadsheet, it could be used as a basis for creating the database saving
alot of time. My fee to help you would be very modest. Contact me.

Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

 

[George Hepworth]

Stevie,

Just to be 100% clear, when I recommended the OP look for "professional"
assistance, I truly meant PROFESSIONAL.

One of the defining characteristics of being a professional was, is, and
always will be, respect for the standards of one's profession. Therefore,
your on-going solicitation for paid work in a forum where it is absolutely
clear that such solicitation is forbidden and unwanted clearly identifies
you as something other than a true professional. And that, I'm afraid,
should be quite enough to warn this poster away from you.

George

 

[Mark Andrews]

My last project a few days ago was discrepancy tracking for the army where
the database tracked individuals and discrepancies each individual had
committed (along with a lot of other information). I also did a database
for a police department tracking violations/criminal records. In general
Access will work for certain applications while web-based applications work
better for some applications. Since you are using Excel I would guess
Access would be an improvement. Access can be used for database
applications similar to what you need. Off the shelf software also has
pros/cons.

I sell a few low cost templates that could help get you started if you want
to build the database yourself.

If you want to hire an Access consultant I recommend a simple Google search
for "Microsoft Access Consultant".

I would be more than willing to discuss your situation and make
recommendations. No charge consultation.

Since you are in HR, you might of heard of my last company "Development
Dimensions International". I ran the internal software engineering group
before going independent.

In summary "Yes, Access might work. Need more details."

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

 

[a a r o n . k e m p f]

I don't know why you're harrassing Steve, please stop it!

 

[a a r o n . k e m p f]

Access (Jet) databases shouldn't be used by anyone for any reason
whatsoever

Move to SQL Server, unless you _LIKE_ losing data and having to type
it in by hand time and time again

 

[Larry Linson]

message

I don't know why you're harrassing Steve, please stop it!

Mr. Kempf, if you don't know why people object to Steve, then you obviously
know less about the content of the newsgroup than about the appropriateness
of your own suggestions here.

I am rather surprised to see you back here -- does that mean the terms of
your probation have expired?

Larry Linson

 

[Larry Linson]

Access (Jet) databases shouldn't be used by anyone
for any reason whatsoever

Move to SQL Server, unless you _LIKE_ losing
data and having to type it in by hand time and time again

To the original poster: Mr. Kempf is like a scratched record on a turntable,
repeating the same misleading advice over and over. He was away from this
newsgroup for some time, but obviously the record, the recording, and the
scratch are all the same.

You can safely disregard his rantings. All he does with them is to damage
the reputation of Microsoft SQL Server which is a fine product, but
certainly not a database for someone who's such a beginner that he's not
sure he even needs a database.

Larry Linson

 

[a a r o n _ k e m p f]

Larry;

there's nothing wrong with Steve.. It's just another case where a
bunch of assholes bully someone on these newsgroups, just because they
disagree.
Steve has every every every right to post on these newsgroups- Just
like you MVPs do - with a link to your company.

What, do the MVPs work for free?

Lose the tude, dude

-Aaron

 

[a a r o n _ k e m p f]

never had probation, never charged, never convicted, never plead.

it never happened.

Literally

 

[a a r o n _ k e m p f]

correction:

SQL Server is _EASIER_ to use than jet.. because you don't need to
learn an obsolete language like DAO for example

Furthermore, the security implications of some sort of HR database
guarantees that he needs a databasse that provides basic level of
security.
Access 2007 (format) doesn't even allow for security in any manner.

So if you want to secure a database- you don't have a choice but to
use SQL Server / Access Data Projects

-Aaron
MCITP: DBA

 

[a a r o n _ k e m p f]

never had probation, never charged, never convicted, never plead.

it never happened.

Literally

 

[a a r o n . k e m p f]

I don't know what you're talking about idiot

It's dumb that you assholes stalk steve.. he has _JUST_ as much right
to be on this newsgroup as do you or I.

-Aaron

Even if you ignore his complete absence of any regard for newsgroup ethics,
his repeated failure to respond to requests to show us the 'simple' solutions
which he has maintained he can deliver instead of the inept ones openly and
freely provided by others and the lack of any evidence of anything but a
superficial level of competence on his part, how many other people would,in
reply to a request for help by a hospice for terminally ill children, offer
his services at a price, as Steve did last year?

Haven't seen you around for a while Aaron.  Has the medication run out again?

Ken Sheridan
Stafford, England

I don't know why you're harrassing Steve, please stop it!
[quoted text clipped - 14 lines]

Arno R

 

[a a r o n . k e m p f]

Do you work for free?

I'd charge hospice children also!!!
And kidney patients!

-Aaron

Even if you ignore his complete absence of any regard for newsgroup ethics,
his repeated failure to respond to requests to show us the 'simple' solutions
which he has maintained he can deliver instead of the inept ones openly and
freely provided by others and the lack of any evidence of anything but a
superficial level of competence on his part, how many other people would,in
reply to a request for help by a hospice for terminally ill children, offer
his services at a price, as Steve did last year?

Haven't seen you around for a while Aaron.  Has the medication run out again?

Ken Sheridan
Stafford, England

I don't know why you're harrassing Steve, please stop it!
[quoted text clipped - 14 lines]

Arno R

 

[Larry Linson]

never had probation, never charged, never convicted, never plead.

it never happened.

Literally

Mr. Kempf, it appears your memory or your perception is as faulty as your
understanding of Microsoft Access, because the link to the court records of
what you deny has been posted here more than once.

 

[Tony Toews [MVP]]

never had probation, never charged, never convicted, never plead.

it never happened.

http://dw.courts.wa.gov/ >> Name Search (middle column under Search
for a person) >> Accept >> key in your name >> Look for case number
07-1-05748-6 probably second last item.

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[a a r o n . k e m p f]

George;

There is NO SUCH THING as a professional jet database developer.

Only halfwits using an obsolete database.

If you want professional, than go to Microsoft and search for
'Microsoft Certified IT Professional' or 'Microsoft Certified DB
Developer'

There's a reason that they don't give these certs to Access script-
kiddies!

-Aaron