Problem designing tables: Too many fields

So, would you say its harder doing it in Access than in Excel?
Because for me it sounds way harder in Access!

PLease let me know what you think, because I am lost!

Just download the following template from the Microsoft site. It will
already have built-in forms and reports and be ready to use.

http://office.microsoft.com/en-us/te...CT011366791033

I don't know if you want them to see a weeks worth - and am confused
because you actually show 8 days on your form example - very strange - could
you please Explain that

Ok, first thank you very much for your help....I think im getting
somewhere.
That "form" that I described in my first post, was a "copy-paste" of an
excel file that the employees are using right now for Expenses Report.

Your 'entry' form would probably NOT have multiple dates shown - but give
the user the ablility to enter each days lodging and meals seperatly. You
then could show all the information for a particular period on one form if
that was needed.

This sounds confusing to me...if I have one form then I dont need to
retype the Name, Period Ending, Location, etc...on the other hand if I
have one form for each record it will be more work, maybe i am wrong.
I am just thinking on a way to leave the form as it is right now. It
would me easier for employees to enter their information. Also my
manager told me "I want this" (refering to the excel file). So I dont
know if I am asking for too much help in here...but if you can give me
some hits or something i will really apreciatted, thank you

WOW, this is great...let me check it out...this can save my life

Harder ... for whom?!

Again, if you have someone with experience in X, doing something in X is
easier than someone who is just learning X. Do you have Excel experience?
Do you have someone with Excel experience?

Do you have Access experience?

(The learning curve on Access, if you haven't been using it and don't have
experience creating normalized data tables, can be fairly steep.)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"erick-flores" wrote in message
oups.com...

So, would you say its harder doing it in Access than in Excel?
Because for me it sounds way harder in Access!

PLease let me know what you think, because I am lost!

Just a reminder ...

Even if you have a template in Access, you still need to figure out how to
"parse" your Excel-oriented data into the structure that the Access template
uses.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"erick-flores" wrote in message
oups.com...

WOW, this is great...let me check it out...this can save my life

This particular template is fairly simple and self-explanatory. Could
possibly just sit and type the information over in an afternoon, depending on
how many records there are. Probably makes more sense than the Excel file
ever did. Well, at least I hope it makes more sense . . . after all,
erick-flores still hasn't come back and told us the results of this
experiment.

"Jeff Boyce" wrote:

Just a reminder ...

Even if you have a template in Access, you still need to figure out how to
"parse" your Excel-oriented data into the structure that the Access template
uses.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"erick-flores" wrote in message
oups.com...

WOW, this is great...let me check it out...this can save my life

Hey, that template its helping me A LOT!....that what I need

Right now I am customizing some of the tables, and adding others so it
can fit the company's needs. But its PERFECT. The excel file that the
company was using before will be now obsolete, from no on we will be
using the Access template with some modifycation that im doing right
now

Thank you very much for ur helps

Glad that the template works for you. If you run into any problems with your
modifications, just start a new thread. There are lots of helpful people
here that can guide you through.

In case you want to create other databases, there are also templates that
are located right on your computer, as well as the ones that are on
Microsoft's site.

Good luck with your modifications.

Oh, one other thing: Do regular backups on your database. Do a backup
before changing ANYTHING. Do a backup after changing ANYTHING. It is
possible to destroy a form/report, and with a backup you can import the
form/report back in. Also, once it is being used by people, back it up very
regularly. Depending on how often data is put in, that could be daily,
weekly, or monthly.

Tools/Database Utilities/Back Up Database