Need Help with Access

[JLE]

I am new to working with Access and I need some help. I am creating a
database that will allow other employees in my department the ability to
input information on a weekly basis. I plan on being able to create reports
to send to our supervisor as well.

The issue is that we work in the field and I want to make it easy for my
coworkers to be able to access the form to input information and not see all
of the background (tables, design, etc.). I plan on putting this on my
company's intranet as well.

Any ideas?

Thanks!


JLE

 

[Bill Mosca, MS Access MVP]

If it's going on an intranet, you might as well start out with ASP pages and
use Access as the back end. That way you can build submit and response
pages. FrontPage makes it very simple to connect to an Access database.

If you want to stay with an Access interface, you can create an MDE from
your MDB and take the steps necesary to hide the database window. But that's
a topic best taken in small bites.

 

[JLE]

Thank you for the information Mr. Mosca.

As you can easily see, I am completely new to this and want it to work well.
What is the best method to learn how to use the Access/Frontpage option for
my goal?

Thanks!

 

[Bill Mosca, MS Access MVP]

JLE

First things first. You stated that you are new to Access so I suggest you
learn as much about database design as you can before you start to build the
database. This is the hardest part and will take the most time.

I knew nothing about HTML or ASP when I started using FrontPage. It's really
a pretty simple program so I caught on in a few hours. There is a data
wizard of some sort in FrontPage that does most of the work. I can't
remember what it is called. It will take you through the steps necessary to
make a connection to the database and build the required forms.

Once your form pages are made, you can tweak the VBScript code to handle
validation if you want, or let the database do as much of it as possible.

All the hardcore web developers will think me crazy to suggest using
FrontPage, but for a novice who needs a web-based data application, it makes
life much easier than trying to learn a more robust development application.