Newbie needing suggestions.

  • Thread starter Thread starter kilocharlie
  • Start date Start date
K

kilocharlie

I am looking for suggestions.

I have a DB in excel now that functions ok. I would like
to move to something a little more automated that I can
do some reporting with.

I have 4 dispatchers on a network, and each dispatcher
has a daily dispatch sheet that I copy and past to one
DB. This is getting old. I'd like all the info in one
DB, and some reports.

Anyone interested in helping?
 
"kilocharlie" wrote
I am looking for suggestions.

I have a DB in excel now that functions ok. I would like
to move to something a little more automated that I can
do some reporting with.

I have 4 dispatchers on a network, and each dispatcher
has a daily dispatch sheet that I copy and past to one
DB. This is getting old. I'd like all the info in one
DB, and some reports.

Anyone interested in helping?
Click to expand...

The purpose of these newsgroups is _helping_. You get the best answers when
you ask specific, detailed ("concise" and "precise")questions. If you'd
like to clarify the data that you (need to) keep and how it should be
presented, possbily someone can make suggestions.

To me, "four dispatchers on a network" and "daily dispatch sheet" are not
self-explanatory.

Larry Linson
Microsoft Access MVP
 
I am looking for suggestions.

I have a DB in excel now that functions ok. I would like
to move to something a little more automated that I can
do some reporting with.

I have 4 dispatchers on a network, and each dispatcher
has a daily dispatch sheet that I copy and past to one
DB. This is getting old. I'd like all the info in one
DB, and some reports.

Anyone interested in helping?
Click to expand...

Well, bear in mind that Excel is a spreadsheet, an excellent one;
Access is a relational database. It's not a "big Excel" nor is it a
way of automating Excel. They ARE DIFFERENT and require a different
mindset!

This does indeed sound like a good candidate for converting to
relational tables. No copy and paste would be needed if you had the
right tables set up.

Are you interested in hiring someone to set this up, or just getting
some free advice on table structures and designs? Either is available.
 
Thank you, John for responding.

I'm just looking for structuring advice, basically.
And maybe I was premature in asking for advice without
thinking clearly about what I wanted.

I since have started and have the db working on a basic
structure. Now I'm looking at adding in reporting, and
user login.
 
Thanks for responding, Larry.

I understand the purpose of the newsgroup. I appreciate
your asking the right questions, understanding that I
DONT know what I'm doing. Hence, NEWBIE.
 
Thank you, John for responding.

I'm just looking for structuring advice, basically.
And maybe I was premature in asking for advice without
thinking clearly about what I wanted.

I since have started and have the db working on a basic
structure. Now I'm looking at adding in reporting, and
user login.
Click to expand...

It may be prudent to be sure that your table structure is properly
normalized first. If you have a good, properly related set of tables,
then Reports and Forms will come pretty easily; if your tables are
improperly structured it can be a nightmare!

We'll be glad to help with any specific questions; if you'ld like to
post your tables and how they are related, someone will be willing,
I'm sure, to either validate your design or suggest improvements.
 
Back
Top