I want to build DB by MS Access as the following ..
## THE REAL LIFE CASE ##
Each employee has a file this file is divided up to 7 category, each category represent subject.
every subject has a documents or reports that related to the employee.
now we want to transfer this to DB as soft copy.
## in DB ##
-table for user ,password with login Forms.
– table for employees with information.
– table for each category that contains attachment field.
– Forms to Add,Edit each table.
-Forms to search for employees an there files.
– Report.
So on!