General Personnel Database

[franklinbukoski]

Good afternoon,

I'm designing a general personnel database for my organization and am
wondering if I could get an MVP to take a look at it to make sure I am on the
right path.

One of my concerns is that I have over 10 child tables that I use a form to
input data into one parent table. Such as a rank table, gender table, etc...


These tables contain a static list of data that I use to select and record
in a parent table. Thank you,

Frank

 

[KARL DEWEY]

Seems to me you have tables you do not need such as gender.
Unless things have changed a whole lot there are only two genders so you do
not need a table. A Yes/No field set to display Male/Female in you forms and
reports would do it. Also you could use a ListBox with Male/Female or just
have validation on the field to accept 'M' or 'F' only.

As for Rank i expect you could use the ListBox or validation.

You really did not say what you were using the data to do so it is hard to
guess.

Will you track events vs the individual then an Event table and a EventAssoc
table recording when start and end.

 

[Steve]

I can review the design of the table structure of your database. I have done
this for numerous customers. My fee is very reasonable. I provide a map of
the tables that shows all the tables in the database, all the fields in each
table, all the relationships between the tables and the type of relationship
for each relationship. The tables are arranged on the map generally as the
flow of information in the database. I create a map of the tables for every
database I do. The map visually shows what forms and subforms are needed for
data entry, shows what special forms and subforms can be created for
dispaying data in the database and shows
what reports and subreports can be created from the data in the database.
Finally, I provide a list of any recommendations I may have.

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

 

[John Marshall, MVP]

Steve you really like demonstrating your lack of intellectual capacity. As
you are well aware, these newsgroups are provided by MS for FREE peer to
peer support.

So can I refresh your memory? The terms of use are outlined here
http://www.microsoft.com/info/cpyright.mspx

So here are a few highlights:

Under "Use of Service"
Advertise or offer to sell or buy any goods or services for any business
purpose, unless such Communication Services specifically allows such
messages.

Under "Use of Service"
Microsoft has no obligation to monitor the Communication Services. However,
Microsoft reserves the right to review materials posted to the Communication
Services and to remove any materials in its sole discretion. Microsoft
reserves the right to terminate your access to any or all of the
Communication Services at any time, without notice, for any reason
whatsoever.

and my favourite:
Under "No unlawful or prohibited use"
You may not use the service in any manner that could ... or interfere with
any other party's use and enjoyent of any service.

Your one man soliciting campagin does put a damper on the free flow of
information in these newsgroups.

John... Visio MVP

I can review the design of the table structure of your database.

Soliciting again.

I have done this for numerous customers.

None of which want to stand up and defend your flaunting of the rules.

My fee is very reasonable.

Not quite reasonable enough. Support in these newsgroups are for free.

 

[KARL DEWEY]

This newsgroup is a FREE service!

Do not advertise here.

 

[Tony Toews [MVP]]

I can review the design of the table structure of your database. I have done
this for numerous customers. My fee is very reasonable.

1) I question your competence given your reply about the golfing
database.

2) Stop soliciting work in the newsgroups.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Keith Wilby]

I can review the design of the table structure of your database.

So could my dog and he'd do it better and for free.

 

[Tony Toews [MVP]]

I'm designing a general personnel database for my organization and am
wondering if I could get an MVP to take a look at it to make sure I am on the
right path.

One of my concerns is that I have over 10 child tables that I use a form to
input data into one parent table. Such as a rank table, gender table, etc...

Actually we'd call those lookup or master tables rather than child
tables.

But give us a list of your table names and we'll be happy to comment.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jamie Collins]

Unless things have changed a whole lot there are only two genders so you do
not need a table.

It would appear they have: see:

http://en.wikipedia.org/wiki/Grammatical_gender

and go straight to the section, 'More than three grammatical genders'.

A Yes/No field set to display Male/Female in you forms and
reports would do it. Also you could use a ListBox with Male/Female or just
have validation on the field to accept 'M' or 'F' only.

If you meant 'sex', ISO 5218 defines *four* sex codes: 0 = not known,
1 = male, 2 = female, 9 = not applicable. One would use the value 9
for a legal person who is not a natural person (human) e.g. an
organization. See:

http://en.wikipedia.org/wiki/ISO_5218

Jamie.

--