Help! I think Access is the proper program but don't know how to s

[Guest]

We have long-haul truckers across the US. They get per diem and have the use
of credit cards for cash and lodging. They get advances. I believe that
everything is settled through the payroll (though I am not sure).

My job is to set up a database of employees that will enable me to track
what they get from us and how much they've accounted for when they return
from a trip.

I have the "Teach Yourself Access in 24 Hours" text and frankly I have my
doubts. Can anyone direct me to good newbie resources where I can begin from
the ground up?

Thank you!

Mary

 

[Ben M. Schorr, MVP]

Have you visited the official Access site?
http://office.microsoft.com/en-us/access/default.aspx

They have some papers and training resources available there that might get
you started.


--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com/access.htm

 

[Steve]

Mary,

The first thing that needs done is to create a set of tables to hold your
data. Read up on designing database tables. Come back with your questions
after you have read about tables.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[gls858]

We have long-haul truckers across the US. They get per diem and have the use
of credit cards for cash and lodging. They get advances. I believe that
everything is settled through the payroll (though I am not sure).

My job is to set up a database of employees that will enable me to track
what they get from us and how much they've accounted for when they return
from a trip.

I have the "Teach Yourself Access in 24 Hours" text and frankly I have my
doubts. Can anyone direct me to good newbie resources where I can begin from
the ground up?

Thank you!

Mary

My first question would be how many employees do you need to track?
10, 100, 1000. It might be that Access is more than you really need.

gls858

 

[Jeff Boyce]

Mary

Access has a fairly steep learning curve. How did you decide that Access
was the tool of choice? And there are other factors to consider...

How urgently is a "finished" application needed?
How many folks will need to share the data?
Are all the (potential) users on the same Local Area Network?
Do all the users already have Access installed (or will you need to install
the Access runtime)?
Do you want the users to be able to open up their Access and "muck about"
with it, or will you want to lock it down so they can only do what you want
them too? (Making it EASY to use is HARD!)

There are more considerations...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP