[quoted text, click to view] "Neil Greenough" <neilgreenough@btopenworld.com> wrote in message
news:ckj3au$72m$1@hercules.btinternet.com...
>I am looking into some possible ideas to get rid of a lot of paperwork for
>a
> volunteer organisation I work for, and just want to know if this is
> possible
> to do with MS Access?
>
> Basically, at the end of every month, each volunteer must hand in their
> expense claims along with their monthly performance (hours worked etc...)
> This is all currently done on paper.
>
> Now, what would be ideal is for all of this to be done on a network-based
> Database. So basically, each individual has restricted access to the
> database and can enter their expenses and performance details and then
> this
> can be authorised by a line manage (not too sure how you can
> electronically
> sign off expenses). Then add the end of a month, the boss can simply print
> out everybody's claims.
>
> Is this possible to create in MS Access? It will be network-based and
> there
> will need to be different levels of access (ie. restricted access for
> individuals, semi-restricted access for line managers and complete access
> for boss)
>
>
>
This is an MSSQL group, so you will probably get a better response in an
Access group. Having said that, if security is a concern, you might want to
consider using Access as a front-end interface only, with all the data in
MSDE (a free, 'stripped down' version of MSSQL for small applications). This
would give better security, scalability and data integrity, but it would
also add complexity, so it depends on what skills are available in your
organization, and how important those features are to you. A good Access
implementation can be more useful than a poor MSSQL one.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp
Simon
