Can this be done in access?

ivwshane

Lifer
May 15, 2000
33,030
16,178
136
I would like to create a little program/database that me and my fellow employee's can use to keep track of their sales. Here is what I'm looking to do:

1)input various info for each day and to have a running total or list that can be viewed.

2)a user interface that is more like a program rather than a spreadsheet (like a template that has buttons for inputing various data)

3)needs to be viewed and used without having access installed (The only other way I can think of is by using/saving it as a html, unless there is another way)

4)I would also like to have each employee's database tie into one main database


I think that's it on the minimum requirements.

If anyone knows if this can be done and if possible give me some insight into how it might be done I would be really grateful!

Thanks for your help;)
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Items #1,2 are available from MS Access.

Item #3
Access can be used from a server, may have a problem with locking a DB or table. This will allow you to only have a single copy and the forms developed within the Access DB for Item #2 are usable.

Item #4
The databases can be joined together
 

ivwshane

Lifer
May 15, 2000
33,030
16,178
136
Thanks for the reply.

So if I only had a database for each employee (separate databases) could I use access in some form of html (like in the same way I can save a powerpoint show as a webpage)?
 

bunker

Lifer
Apr 23, 2001
10,572
0
71
Everything you want to do can be done in Access.

I would suggest you head to the local bookstore and pick up a book on access programming. I'd give you a specific title, but all of mine are at work and I'll be damned if I can remember who published them.
 

ivwshane

Lifer
May 15, 2000
33,030
16,178
136
If you happen to remember one let me know;)

I just went through a bunch of tutorials but they didn't give me to much info:(
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
My boy learned a lot of Access programming info from a couple of books I grabbed from the local bookstores.

Just get one that deals with Access and not Office. More info will be in the book relating to what you want.