Tables

[rintobs]

I have attended classes on MS Access, a software worth trying, I wanted to explore its potential. I have created a bogus company and want to create a record keeping, updating, viewing and printing of its employees. Can anyone guide me how to go about.

[June7]

If you have a question about a specific issue, post it and we will try to help. Otherwise, sit down with tutorials and work at it. Explore template databases. Do what the classes taught. Design data structure (identify entities and relationships), build tables then forms then reports.

[orange]

Show us your tables and relationship diagram.

You may want to research Normalization and Entity Relationship Diagramming.

[rintobs]

hi,
I am planning to make a main table and link other tables to it-one to many relationship. Numbers of tables that i have thought of are:
(a) Personal Details(to include)-Personal Number, Designation, Name, Date of Birth, Date joined, Identification mark, Pen picture
(b) Address-Address Id, National Identiy Card No,House Number, Village, Block, district
(c) Leave- Leave id, Nature of leave, Duration from, duration to
(d) Medical category-medical id, blood group, category type, review date,
(e) Next of kin-nokid,name of nok, percentage of share, relation
(f) Sibling-sibling id, Name, age, sex, occupation, address, contact number
(g) Wife details-Name, National Id, House No, village,block, district
(h) Children details-name, sex, age, Qualification.
These are the things I want to try to make a database.
How should I begin with?

[orange]

Adopt a naming convention that does not include spaces or special characters in names of fields and objects.

Here is a link to a site with lots of info on Access.
http://www.accessmvp.com/strive4peace/