Cry For Help

[Matt Moffat]

Hello all. I am a novice, at best, Access user. Unfortunatly, I was assigned
to create a database for a research project I am participating in and I
really just don't know where to start. I was thinking my best chance would
just be to modify a template to fit my needs but I can't seem to find one
that will really work. I need to do the following:

People need to be able to input the number of hours they work, the project
they work on, and a brief description of the work they do.

I need to be able to lookup data by date, project, or person.

It seems like a simple task to me, but this is all way beyond my understand
and would appreciate any advice I could get. I am no fool and can learn
pretty quickly, I am just unsure of where to start.

 

[Mike Revis]

Matt,
You don't say which version of Access you are using but Microsoft has
templates for project management (2007 I think) and one for time and
billing. Search the MS site for templates.
Perhaps one of these will work for you.

Post back if you have specific questions.

Good luck
Mike

 

[John]

On Fri, 5 Sep 2008 16:01:01 -0700, Matt Moffat <Matt

Hello all. I am a novice, at best, Access user. Unfortunatly, I was assigned
to create a database for a research project I am participating in and I
really just don't know where to start. I was thinking my best chance would
just be to modify a template to fit my needs but I can't seem to find one
that will really work. I need to do the following:

People need to be able to input the number of hours they work, the project
they work on, and a brief description of the work they do.

I need to be able to lookup data by date, project, or person.

It seems like a simple task to me, but this is all way beyond my understand
and would appreciate any advice I could get. I am no fool and can learn
pretty quickly, I am just unsure of where to start.

Based on your brief description, I will GUESS project title is key

So, what **I** would do is... (may not be best, but quick & easy)

The key index field (unique) would be Project Title, however many
characters you think will be needed, in a project table

A (one to many) related table will have
Project Title
Person Name
Date Worked
Notes - a memo field

Project Query based on a list box on a form (select Project Title
and feed to Query as (example) criteria [forms]![PrintMain]![PTitle]

Build a report based on that query, so you select all records for
the chosen Project title... sort as needed by name or date

Do another query selecting a person's name from a list box and feed
that to the query as criteria [forms]![PrintMain]![PersonName]

That should get you started