relationships struggle ! (1 Viewer)

[coda7777]

Hello brilliants

I come as a refugee from relationships struggle with DB !! i literally watched hours and hours of videos and read a lot and still can't control it ! so i will say what i need to do !!!


i'm building a complete DB ! however i went through forms , codes , macros and many things i still want to jump back to the starting point and checkout the relationships so....

Database has :
part 1:

Employees : containing ( different titles) (different direct managers ) ( different security pass levels depending on the titles they have )

each Employee has this : >> Title , direct manager , security level (numbers 1~7)

part 2 :

Each Employee has Holiday record !!
holidays main table has the type of holiday and how many days based on , table of requested holidays vs table of accepted holiday

Employee > Holidays > type & days of the holidays acquired

part 3 :

Each employee is doing work on : >>
cases & files

part 4 :

cases and files are handled by junior team then : escalated or not to Senior team


i'm gonna commit suicide after writing that coz probably it's too complicated to think about it
of course Employees has many info , cases files has many info but they are not required to be linked just data

HELP PLEASE !

 

[Ranman256]

TEmployee table
EmpID
FirstN
LastN
Level
Etc...

TCases table
CaseID* (your#)
CaseDate
EmpID. (Long)
Etc...
(Instead of empID,you could use TeamID from the tTeams table )

TEmpHoliday table
EmpID*
Date*
Reason
Etc...

 

[coda7777]

makes any sense ?

 

[coda7777]

TEmployee table
EmpID
FirstN
LastN
Level
Etc...

TCases table
CaseID* (your#)
CaseDate
EmpID. (Long)
Etc...
(Instead of empID,you could use TeamID from the tTeams table )

TEmpHoliday table
EmpID*
Date*
Reason
Etc...

i have already created tables , forms , and many things
when i browse the row data and for further forms and tables i want to build the proper relationship !
where goes where and lead to what.... etc

 

[jdraw]

It all starts with a clear description of the business. The simpler the terms and the avoidance of jargon the better the communication.
You must start with an understanding and some confirmation of WHAT you are trying to do.
If you already have forms, tables, macros..., then you probably have a cart before the horse situation.

I don't know if you have worked through a tutorial from RogersAccessLibrary but that's what I would recommend before you go any farther.
It will take 45-60 minutes to work through, but you will learn by experience.

Here are a couple of tutorials and more info.

Class info system
Catering Business
Widgets

Here is a link to an excellent tutorial on database design by Barry Williams

I like to lay out a data model before getting near physical Access.
You can build the model with pencil and paper.
Here are some steps from Dezign for data modeling

You might try watching some free video tutorials by Dr.Daniel Soper that will help you with the concepts.

Intro to Database
The Relational Model
Data Modelling and the ER Model