How to make a database out of this

C

Cinho

How to create database in MS Access with this information? I need just some
raw drawings perhaps, how to connect these information, maybe with some
simple explanation.
I only got this information down on a piece of paper & task to draw how I
think the database should look, some concept.
I only know that for Units and Subunits there should be 3 tables (so I was
told) & to add IDs as keys.
I have a moderate knowledge of Access (mostly with 1:1 & 1:N relationships,
2 or 3 tables) but people with advanced knowledge of Access will do most of
the job.



COMPANY is divided on UNITS (relation - MANY TO MANY)
COMPANY Inc., UNIT 2, UNIT 3, UNIT 4...

COMPANY Inc. is divided on SUBUNITS (SUBUNIT 1, SUBUNIT 2,SUBUNIT 3, SUBUNIT
4...)

In database there should be

EMPLOYEES (name, surname, social sec. num., number in company, DOB,
Organization unit, cellphone number, phone on work, e-mail...)
Employees have children (members of Family) - Name, Surname, DOB

FUNCTIONS
- employees have an activty/function in the union (Commissioner, protection
at work, female groups)
- the union member can insure member of family
- the union member gets legal aid
- the union member gets the loan (amount, when)
- the union member gets a receipt for the purchase
- in case of baby birth he gets xx $
- in case of 3 months of sick leave gets xx $
- death of family member= xx $, funeral wreath, death notices...
- death of spouse and children - xx $
- participation of hospital treatment
- pensions

and

STATISTICS
- members, joined/left, paying the membership
- annual and quarterly reports of services usage
- annaual medical examination of members in the units
- children from age x to y (greeting cards,...) - List
- Female members - greeting cards,... - List
- insurance by years (or age) (there are limits, how old is on date),
children seperatly, spouses seperatly,..)
- newsletter or notification by the group, birthdays, New Years,...


If anyone knows how this should look like and is willig to help i would be
so grateful.
If you need e-mail: cuba1hr (at) gmail.com.
Many thanks in advance.
 
J

Jeff Boyce

This newsgroup is "staffed" by folks volunteering their time. If you want
their assistance, you'll need to provide a lot more information, and to ask
much more specific questions.

You appear to be asking for someone to build an entire application for you.
Have you considered seeking a consultant?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Gina Whipp

Cinho,

Okay, if you are looking to hire someone then please check your local
Colleges and Universities. If you want to hire a professional PLEASE check
references and there are boards for that, this is not one of them. If you
are looking to dabble yourself then...

http://www.databasedev.co.uk/data_models.html

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
C

Cinho

Jeff Boyce said:
This newsgroup is "staffed" by folks volunteering their time. If you want
their assistance, you'll need to provide a lot more information, and to
ask much more specific questions.

You appear to be asking for someone to build an entire application for
you. Have you considered seeking a consultant?

Regards

Jeff Boyce
Microsoft Office/Access MVP
As I wrote before I only have these information for now. I thought it would
take 2-3 minutes for someone who's into databases all the time. I have a
person who will build it. Consultant would be "too expensive" as we all
volunteer in non-profit organization. I started a search for the consultant
but I was hoping I could get some result quicker this way, or at least some
link to similar tutorial. (Thanks Gina)
Thanks anyway.
 
G

George

I am usually not so critical, but "2-3 minutes" is an EXTREMELY unrealistic
expectation!

I'm writing this, not just for you in this particular instance, but for
others who come here looking for quick answers to complex situations, or
expecting that "someone" will pull out a template that exactly meets their
needs and email it to them.

It doesn't work that way.

Designing and building even a basic database (and what you're asking for is
not all that simple, by the way) takes time, IF you expect to be done right.

A competent consultant will build your application much more quickly than
your internal person; that's a given. But that doesn't mean it will happen
overnight, or even over a weekend. There's a common saying in the software
development world. It's phrased differently from time to time, but it boils
down to this:

Good, Fast, Cheap. You can have any TWO of those.

Best of luck.

George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top