473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Recordkeeping

I have a project to put together. My company keeps records of employee
regulatory testing. I want to put together a program that will track
employee testing.

The employee will log in, take the test which, only whether they passed or
failed the test, will need to be stored in the database. There will also be
an interface that will show them what tests they have passed/failed and
which ones haven't been taken. From there, they should be able to click on a
link to take another test. I have some programming experience, I'm just not
sure what would be the best way for this information to flow (ASP, Access,
VB, SQL, XML, etc.).

I would like to start out with something small (2 or 3 users and only a
couple of tests).

Any help would be appreciated,

Jerry

Nov 13 '05 #1
3 1482
If this is a company-wide project, the easiest way would probably be a
web-based product (but read further for more info). You could use Access/Jet
to store this information, but your company's intranet may already host a
database engine like MySQL, Oracle, MSSQL etc. And Access is file-based,
thus while it's often easier for you to work with, it's also easier to hack
than server-based data. I don't know how sensitive this information would
be, but if it's something that could cause legal problems if it leaks out,
you might want to use a more secure database engine like metioned earlier.

If you go web-based, the language you'd use would depend on what type of
server it's hosted on. If it's a Windows machine, then your best bet is ASP
(or ASP.NET, depending on your flavor of servers) to render dynamic pages,
and ADO to "talk" to the database. You'd use Structured Query Langauge (SQL)
from within ADO to retrieve/update data ...

Of course, you could also write a VB/Access frontend that connects to your
server database, if that's more to your liking. Desktop applications are
usually much more feature rich than web-based ones, thus you can do a lot
more with a desktop application. The trouble with this type of scenario is
updates and deployment hassles. When you need to send out a new frontend,
you'll have to update all users individually. You can automate this any
number of ways, of course, but it's still a problem to deal with. There's
also the issue of compatibilty among desktop environments (especially if you
use Access as the frontend); different combinations of OS/Office can cause
headaches. Again, this isn't insurmountable, but it's one factor to
consider.

What it boils down to is this: a web-based interface is easier to deploy and
maintain that a desktop interface. However, a desktop interface offers you
many more User Interface considerations than does a web-based. So you must
determine which are the more important aspects. If your tests are all yes/no
or simple multiple choice, then a web-based interface would work fine. If
users must manipulate objects (i.e move things around on screen) or draw
things, a desktop environment will be much more useful.
"Jerry W. Swatsell" <sw******@swbell.net> wrote in message
news:I3****************@newssvr30.news.prodigy.com ...
I have a project to put together. My company keeps records of employee
regulatory testing. I want to put together a program that will track
employee testing.

The employee will log in, take the test which, only whether they passed or
failed the test, will need to be stored in the database. There will also
be
an interface that will show them what tests they have passed/failed and
which ones haven't been taken. From there, they should be able to click on
a
link to take another test. I have some programming experience, I'm just
not
sure what would be the best way for this information to flow (ASP, Access,
VB, SQL, XML, etc.).

I would like to start out with something small (2 or 3 users and only a
couple of tests).

Any help would be appreciated,

Jerry

Nov 13 '05 #2
Scott,
Java and C# and VB.NET and similar things offer enough widgets that you can
do quite a bit to design a UI that doesn't feel like a warmed over web page.
I'd make the case that a web-based project can be well-designed and easy to
use. The effort to do the requirements isn't that much greater and the
lifespan of a web-based application is likely to be better/cheaper than
committing to a version of Office/Access. I am generally agin Access
anyway, a search of Google will pull up plenty of my posts that show this,
so given the option I'd pick an IDE like Eclipse, an OpenSource rdbms like
PostgreSQL and Java as my toolkit. If it's a Microsoft house then C#,
VB.Net and SQL Server or MSDE are my prefferred choices over Jet/Access &
VBA.

"Scott McDaniel" <scott@NO_SPAM_HEREthedatabaseplace.net> wrote in message
news:zf********************@comcast.com...
If this is a company-wide project, the easiest way would probably be a
web-based product (but read further for more info). You could use
Access/Jet to store this information, but your company's intranet may
already host a database engine like MySQL, Oracle, MSSQL etc. And Access
is file-based, thus while it's often easier for you to work with, it's
also easier to hack than server-based data. I don't know how sensitive
this information would be, but if it's something that could cause legal
problems if it leaks out, you might want to use a more secure database
engine like metioned earlier.

If you go web-based, the language you'd use would depend on what type of
server it's hosted on. If it's a Windows machine, then your best bet is
ASP (or ASP.NET, depending on your flavor of servers) to render dynamic
pages, and ADO to "talk" to the database. You'd use Structured Query
Langauge (SQL) from within ADO to retrieve/update data ...

Of course, you could also write a VB/Access frontend that connects to your
server database, if that's more to your liking. Desktop applications are
usually much more feature rich than web-based ones, thus you can do a lot
more with a desktop application. The trouble with this type of scenario is
updates and deployment hassles. When you need to send out a new frontend,
you'll have to update all users individually. You can automate this any
number of ways, of course, but it's still a problem to deal with. There's
also the issue of compatibilty among desktop environments (especially if
you use Access as the frontend); different combinations of OS/Office can
cause headaches. Again, this isn't insurmountable, but it's one factor to
consider.

What it boils down to is this: a web-based interface is easier to deploy
and maintain that a desktop interface. However, a desktop interface offers
you many more User Interface considerations than does a web-based. So you
must determine which are the more important aspects. If your tests are all
yes/no or simple multiple choice, then a web-based interface would work
fine. If users must manipulate objects (i.e move things around on screen)
or draw things, a desktop environment will be much more useful.
"Jerry W. Swatsell" <sw******@swbell.net> wrote in message
news:I3****************@newssvr30.news.prodigy.com ...
I have a project to put together. My company keeps records of employee
regulatory testing. I want to put together a program that will track
employee testing.

The employee will log in, take the test which, only whether they passed
or
failed the test, will need to be stored in the database. There will also
be
an interface that will show them what tests they have passed/failed and
which ones haven't been taken. From there, they should be able to click
on a
link to take another test. I have some programming experience, I'm just
not
sure what would be the best way for this information to flow (ASP,
Access,
VB, SQL, XML, etc.).

I would like to start out with something small (2 or 3 users and only a
couple of tests).

Any help would be appreciated,

Jerry


Nov 13 '05 #3
I really appreciate your input. I think I may end up outsourcing. I think I
may be in a little over my head :)

"Alan Webb" <kn*****@hotmail.com> wrote in message
news:e5********************@comcast.com...
Scott,
Java and C# and VB.NET and similar things offer enough widgets that you
can do quite a bit to design a UI that doesn't feel like a warmed over web
page. I'd make the case that a web-based project can be well-designed and
easy to use. The effort to do the requirements isn't that much greater
and the lifespan of a web-based application is likely to be better/cheaper
than committing to a version of Office/Access. I am generally agin Access
anyway, a search of Google will pull up plenty of my posts that show this,
so given the option I'd pick an IDE like Eclipse, an OpenSource rdbms like
PostgreSQL and Java as my toolkit. If it's a Microsoft house then C#,
VB.Net and SQL Server or MSDE are my prefferred choices over Jet/Access &
VBA.

"Scott McDaniel" <scott@NO_SPAM_HEREthedatabaseplace.net> wrote in message
news:zf********************@comcast.com...
If this is a company-wide project, the easiest way would probably be a
web-based product (but read further for more info). You could use
Access/Jet to store this information, but your company's intranet may
already host a database engine like MySQL, Oracle, MSSQL etc. And Access
is file-based, thus while it's often easier for you to work with, it's
also easier to hack than server-based data. I don't know how sensitive
this information would be, but if it's something that could cause legal
problems if it leaks out, you might want to use a more secure database
engine like metioned earlier.

If you go web-based, the language you'd use would depend on what type of
server it's hosted on. If it's a Windows machine, then your best bet is
ASP (or ASP.NET, depending on your flavor of servers) to render dynamic
pages, and ADO to "talk" to the database. You'd use Structured Query
Langauge (SQL) from within ADO to retrieve/update data ...

Of course, you could also write a VB/Access frontend that connects to
your server database, if that's more to your liking. Desktop applications
are usually much more feature rich than web-based ones, thus you can do a
lot more with a desktop application. The trouble with this type of
scenario is updates and deployment hassles. When you need to send out a
new frontend, you'll have to update all users individually. You can
automate this any number of ways, of course, but it's still a problem to
deal with. There's also the issue of compatibilty among desktop
environments (especially if you use Access as the frontend); different
combinations of OS/Office can cause headaches. Again, this isn't
insurmountable, but it's one factor to consider.

What it boils down to is this: a web-based interface is easier to deploy
and maintain that a desktop interface. However, a desktop interface
offers you many more User Interface considerations than does a web-based.
So you must determine which are the more important aspects. If your tests
are all yes/no or simple multiple choice, then a web-based interface
would work fine. If users must manipulate objects (i.e move things around
on screen) or draw things, a desktop environment will be much more
useful.
"Jerry W. Swatsell" <sw******@swbell.net> wrote in message
news:I3****************@newssvr30.news.prodigy.com ...
I have a project to put together. My company keeps records of employee
regulatory testing. I want to put together a program that will track
employee testing.

The employee will log in, take the test which, only whether they passed
or
failed the test, will need to be stored in the database. There will also
be
an interface that will show them what tests they have passed/failed and
which ones haven't been taken. From there, they should be able to click
on a
link to take another test. I have some programming experience, I'm just
not
sure what would be the best way for this information to flow (ASP,
Access,
VB, SQL, XML, etc.).

I would like to start out with something small (2 or 3 users and only a
couple of tests).

Any help would be appreciated,

Jerry



Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Haisoo Shin | last post by:
Hello.. I am working on a PHP/PEAR web page that shows statistics of how many people read a certain article during given period of time. I have, say, two tables called 'books' and 'logs'. The...
0
by: namita_jain | last post by:
Hi I have an XML which includes two namespaces. I am able to add one namespace How do i add the second namespace through my code? The sample Xml is as follows: <?xml version="1.0"...
3
by: Ron | last post by:
Hi All, I've written a program that takes care of recordkeeping. I've got tables for clients, orders, and details for those orders. All sortsa reports, etc. On my main unit, everything runs...
10
tuxalot
by: tuxalot | last post by:
I have a table (TblDateHistory) to record lost days due to injuries: EmployeeID StartDate ReturnDate RestrictedOrLostDays TotalDays 1 ... ... Lost Time...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.