I need to develop a microsoft access database for an offshore compliance company. The database will need to function as a standalone program that will be used by several levels of clearance. Users must be able to log into the system which will determine what data/forms/reports that user will have access to. I have already begun development but am unable to press forward due to prior commitments. In general most of the tables and relationships are already estabished but may need adjusting to achieve desired functionality.
The data consists of: Clients, Operators, Platforms, Inspections, Inspection Types, and Employees. I have attached a preliminary cardinality diagram that can be referenced to understand the data relationships.
The system needs to be highly intuitive for the end user. I will require documentation of the database as well.