Is this possible?

[Neil Greenough]

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)

[Simon Hayes]

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@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/de..._msdeintro.asp

Simon

[Neil Greenough]

Apologies Simon.

I just thought that the subject of SQL servers kinda overlapped that of MS
Access.

Thanks a lot for the advice.
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41********@news.bluewin.ch...

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@hercules.btinternet.com...

I am looking into some possible ideas to get rid of a lot of paperwork fora
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/de...us/dnacc2k2/ht
ml/odc_msdeintro.asp
Simon

[Simon Hayes]

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@hercules.btinternet.com...

Apologies Simon.

I just thought that the subject of SQL servers kinda overlapped that of MS
Access.

Thanks a lot for the advice.

<snip>

No need to apologize - they're often used together, and many people do
associate them with each other somewhat, rightly or wrongly. Since this
group is an MSSQL one, you're unlikely to get responses to pure Access
questions; if you are using them together, then people here will generally
prefer solutions which rely on MSSQL functionality, not on Access.

Simon