A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Import data, generate monthly report



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2004, 06:16 AM
utahleo
external usenet poster
 
Posts: n/a
Default Import data, generate monthly report

I need some help from people more knowledgeable then I. I need some suggestions on how I can do this task.

Here it goes.

I have a group of mobile users who generate daily stats. I need to have something in place which will allow the mobile users to enter their stats online, then send the information to their respective supervisor. Then on the supervisors end, I need the data sent from the mobile user to be imported into another database/worksheet or whatever, and calculate the numbers for each of their subordinates each month.

Example:

User A Has the following stats for Day 1 in the month:

Community Contacts: 5
Dispatched Calls: 4
Assists: 7
Initials: 2

At the end of the day, User A will need to send this information to his/her supervisor (Supervisor B)

Supervisor B will recieve this information somehow and place it into a worksheet for the month. Supervisor B will recieve this type of information for about 10 other Users, and will need to place these stats onto a worksheet for each user. Then supervisor B will send a report to command staff showing the months stats for all of his users.

Ideally, and if its not to difficult, I would like to have this process automated to where the mobile users input there stats and the information is collected for the month automatically. Then the supervisor can individually select the users in his squad and generate a report for his squads stats each month.

We currently do this on paper. The users will turn in a daily stat sheet to their supervisor and the supervisor enters the information on a spreadsheet each month. I've taken on the task of how to automate this whole process, but I don't know enough about excel or access to try and make it work. Hints will be greatly appreciated. I hope this makes sense. If not e-mail me and I will explain further!

Thanks.
  #2  
Old May 22nd, 2004, 05:46 PM
John Nurick
external usenet poster
 
Posts: n/a
Default Import data, generate monthly report

Hi Leo,

This may not be as simple as it seems. First, two questions:

Do all the users have Internet access at all times they need to enter
data? If so, you could use a database running on a web server: the users
would log in to enter their data (using their web browser), and the
supervisor would log in to generate the reports.

If not, you'll need an application running on each user's computer to
capture the data as it's entered and store it until it can be uploaded
(e.g. by email) to the supervisor's system. In this case it becomes
relevant whether the users have Access on their computers.

If they do, one way to do this is to have two databases: one for the
users - with a copy on each machine - and one for the supervisor. The
users enter data into their database and at the end of the day press a
button which causes the database to bundle the day's data into an email
and send it to the supervisor.

The supervisor's database then has a system for importing the emailed
data and generating reports as needed.

If the users don't have Access, it's possible to use an Excel or Visual
Basic application for the data entry.



On Fri, 21 May 2004 22:16:04 -0700, "utahleo"
wrote:

I need some help from people more knowledgeable then I. I need some

suggestions on how I can do this task.

Here it goes.

I have a group of mobile users who generate daily stats. I need to have

something in place which will allow the mobile users to enter their
stats online, then send the information to their respective supervisor.
Then on the supervisors end, I need the data sent from the mobile user
to be imported into another database/worksheet or whatever, and
calculate the numbers for each of their subordinates each month.

Example:

User A Has the following stats for Day 1 in the month:

Community Contacts: 5
Dispatched Calls: 4
Assists: 7
Initials: 2

At the end of the day, User A will need to send this information to

his/her supervisor (Supervisor B)

Supervisor B will recieve this information somehow and place it into a

worksheet for the month. Supervisor B will recieve this type of
information for about 10 other Users, and will need to place these stats
onto a worksheet for each user. Then supervisor B will send a report to
command staff showing the months stats for all of his users.

Ideally, and if its not to difficult, I would like to have this process

automated to where the mobile users input there stats and the
information is collected for the month automatically. Then the
supervisor can individually select the users in his squad and generate a
report for his squads stats each month.

We currently do this on paper. The users will turn in a daily stat

sheet to their supervisor and the supervisor enters the information on a
spreadsheet each month. I've taken on the task of how to automate this
whole process, but I don't know enough about excel or access to try and
make it work. Hints will be greatly appreciated. I hope this makes
sense. If not e-mail me and I will explain further!

Thanks.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
  #3  
Old May 24th, 2004, 10:16 PM
utahleo
external usenet poster
 
Posts: n/a
Default Import data, generate monthly report


Hi John!

Thank's for the response. To answer your questions: Not all users will have MS Access on their machines, but all do have Internet access. So any ideas how the web based feature would work? That seems to be the more feasible option. I guess I could learn the Visual Basic stuff, but that maybe too time consuming right now.

Thanks!

----- John Nurick wrote: -----

Hi Leo,

This may not be as simple as it seems. First, two questions:

Do all the users have Internet access at all times they need to enter
data? If so, you could use a database running on a web server: the users
would log in to enter their data (using their web browser), and the
supervisor would log in to generate the reports.

If not, you'll need an application running on each user's computer to
capture the data as it's entered and store it until it can be uploaded
(e.g. by email) to the supervisor's system. In this case it becomes
relevant whether the users have Access on their computers.

If they do, one way to do this is to have two databases: one for the
users - with a copy on each machine - and one for the supervisor. The
users enter data into their database and at the end of the day press a
button which causes the database to bundle the day's data into an email
and send it to the supervisor.

The supervisor's database then has a system for importing the emailed
data and generating reports as needed.

If the users don't have Access, it's possible to use an Excel or Visual
Basic application for the data entry.



On Fri, 21 May 2004 22:16:04 -0700, "utahleo"
wrote:

I need some help from people more knowledgeable then I. I need some

suggestions on how I can do this task.
Here it goes.
I have a group of mobile users who generate daily stats. I need to have

something in place which will allow the mobile users to enter their
stats online, then send the information to their respective supervisor.
Then on the supervisors end, I need the data sent from the mobile user
to be imported into another database/worksheet or whatever, and
calculate the numbers for each of their subordinates each month.
Example:
User A Has the following stats for Day 1 in the month:
Community Contacts: 5

Dispatched Calls: 4
Assists: 7
Initials: 2
At the end of the day, User A will need to send this information to

his/her supervisor (Supervisor B)
Supervisor B will recieve this information somehow and place it into a

worksheet for the month. Supervisor B will recieve this type of
information for about 10 other Users, and will need to place these stats
onto a worksheet for each user. Then supervisor B will send a report to
command staff showing the months stats for all of his users.
Ideally, and if its not to difficult, I would like to have this process

automated to where the mobile users input there stats and the
information is collected for the month automatically. Then the
supervisor can individually select the users in his squad and generate a
report for his squads stats each month.
We currently do this on paper. The users will turn in a daily stat

sheet to their supervisor and the supervisor enters the information on a
spreadsheet each month. I've taken on the task of how to automate this
whole process, but I don't know enough about excel or access to try and
make it work. Hints will be greatly appreciated. I hope this makes
sense. If not e-mail me and I will explain further!
Thanks.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

  #4  
Old May 25th, 2004, 09:56 AM
John Nurick
external usenet poster
 
Posts: n/a
Default Import data, generate monthly report

Sorry, Leo, this isn't an area I've got into yet. As far as I know a lot
depends on what services your web server offers, but I get the
impression that ASP.NET may be the technology to use.

On Mon, 24 May 2004 14:16:06 -0700, "utahleo"
wrote:


Hi John!

Thank's for the response. To answer your questions: Not all users will

have MS Access on their machines, but all do have Internet access. So
any ideas how the web based feature would work? That seems to be the
more feasible option. I guess I could learn the Visual Basic stuff, but
that maybe too time consuming right now.

Thanks!

----- John Nurick wrote: -----

Hi Leo,

This may not be as simple as it seems. First, two questions:

Do all the users have Internet access at all times they need to enter
data? If so, you could use a database running on a web server: the users
would log in to enter their data (using their web browser), and the
supervisor would log in to generate the reports.

If not, you'll need an application running on each user's computer to
capture the data as it's entered and store it until it can be uploaded
(e.g. by email) to the supervisor's system. In this case it becomes
relevant whether the users have Access on their computers.

If they do, one way to do this is to have two databases: one for the
users - with a copy on each machine - and one for the supervisor. The
users enter data into their database and at the end of the day press a
button which causes the database to bundle the day's data into an email
and send it to the supervisor.

The supervisor's database then has a system for importing the emailed
data and generating reports as needed.

If the users don't have Access, it's possible to use an Excel or Visual
Basic application for the data entry.



On Fri, 21 May 2004 22:16:04 -0700, "utahleo"
wrote:

I need some help from people more knowledgeable then I. I need some

suggestions on how I can do this task.
Here it goes.
I have a group of mobile users who generate daily stats. I need to have

something in place which will allow the mobile users to enter their
stats online, then send the information to their respective supervisor.
Then on the supervisors end, I need the data sent from the mobile user
to be imported into another database/worksheet or whatever, and
calculate the numbers for each of their subordinates each month.
Example:
User A Has the following stats for Day 1 in the month:
Community Contacts: 5

Dispatched Calls: 4
Assists: 7
Initials: 2
At the end of the day, User A will need to send this information to

his/her supervisor (Supervisor B)
Supervisor B will recieve this information somehow and place it into a

worksheet for the month. Supervisor B will recieve this type of
information for about 10 other Users, and will need to place these stats
onto a worksheet for each user. Then supervisor B will send a report to
command staff showing the months stats for all of his users.
Ideally, and if its not to difficult, I would like to have this process

automated to where the mobile users input there stats and the
information is collected for the month automatically. Then the
supervisor can individually select the users in his squad and generate a
report for his squads stats each month.
We currently do this on paper. The users will turn in a daily stat

sheet to their supervisor and the supervisor enters the information on a
spreadsheet each month. I've taken on the task of how to automate this
whole process, but I don't know enough about excel or access to try and
make it work. Hints will be greatly appreciated. I hope this makes
sense. If not e-mail me and I will explain further!
Thanks.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.