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) 3 1399
"Neil Greenough" <ne***********@ btopenworld.com > wrote in message
news:ck******** **@hercules.bti nternet.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
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.c h... "Neil Greenough" <ne***********@ btopenworld.com > wrote in message news:ck******** **@hercules.bti nternet.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.a sp Simon
"Neil Greenough" <ne***********@ btopenworld.com > wrote in message
news:ck******** **@hercules.bti nternet.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Julia Briggs |
last post by:
I am struggling to create a PHP function that would take a specified
image (JPG, GIF or PNG) from a link, and resize it down to a thumbnail
so it will always fit in a 200x250 space. I am hoping not to have it
inserted or read from a database to do this function. Can it be done &
someone please help me?
|
by: rbt |
last post by:
Say I have a list that has 3 letters in it:
I want to print all the possible 4 digit combinations of those 3
letters:
4^3 = 64
aaaa
|
by: CHIN |
last post by:
Hi all.. here s my problem ( maybe some of you saw me on other groups, but i
cant find the solution !! )
I have to upload a file to an external site, so, i made a .vbs file , that
logins to the site, and then i have to select the file to upload.. i used
sendkeys.. and i worked perfect.. BUT ... the computer must be locked for
security ( obviusly ) reazons.. so..i think this probable solutions to
unlock the computer and run the...
|
by: Andrzej |
last post by:
Is it possible to call a function which name is given by a string?
Let assume that I created a program which call some functions for example
void f1(void),
void f2(void),
void f3(void).
After some time, I added new function void f4(void).
|
by: Bhupesh Naik |
last post by:
This is a query regarding my problem to make a spell and
grammar check possible in text area of a web page.
We have aspx pages which are used to construct letters.
The browser based screens provide text area where the user
can insert big chunks of text and submit it all to the
server paragraph by paragraph.
The requirement is to do a Spell Check AND Grammar Check
in the text area. I did look at lot of possible third
| |
by: AAA |
last post by:
hi,
I'll explain fastly the program that i'm doing..
the computer asks me to enter the cardinal of a set X ( called "dimX"
type integer)where X is a table of one dimension
and then to fill it with numbers X;
then the computer asks me how many subsets i have (nb_subset type
(integer))
then,i have to enter for every sebset the card, and then to fill it,
we'll have a two tables , one called cardY which contains nb_subset
elements,and every...
|
by: Piotr Nowak |
last post by:
Hi,
Say i have a server process which listens for some changes in database.
When a change occurs i want to refresh my page in browser by notyfinig it.
I do not want to refresh my page i.e. every 5 seconds, i just want to
refresh it ONLY on server change just like desktop applications do.
The problem is that refreshing evry n seconds has to much impact on my
web server. The refresh action should be taken only when something
|
by: RSH |
last post by:
Okay my math skills aren't waht they used to be...
With that being said what Im trying to do is create a matrix that given x
number of columns, and y number of possible values i want to generate a two
dimensional array of all possible combinations of values.
A simple example:
2 - columns and 2 possible values would generate:
0 0
|
by: Robert S. |
last post by:
Searching some time now for documents on this but still did not find
anything about it:
Is it possible to replace the entry screen of MS Office Access 2007 -
that one presenting that default 'templates' (with that big graphic
buttons) - with some sort of own HTML-Page? I could imagine, that
somehow it is possible to change this construction (hopefully not
hardcoded in MS-Acc07), like it is possible to edit the 'Fluent Ribbon'?
If so...
|
by: bjorklund.emil |
last post by:
Hello pythonistas.
I'm a newbie to pretty much both programming and Python. I have a task
that involves writing a test script for every possible combination of
preference settings for a software I'm testing. I figured that this
was something that a script could probably do pretty easily, given all
the various possibilites.
I started creating a dictionary of all the settings, where each key
has a value that is a list of the possible...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |