Configure an Access Database to work on a network with <50 users for exercise scenario management

In the bid for providing an Exercise Capability, there is a requirement for a simple scenario management tool that is one level up from a basic spreadsheet. There will be 4 exercises per year for two years. The basic requirement is as follows:  10 events over a 3 day period with a daily maximum of 25 injects.  Injects nested within events.  Unique indicator and owner (appointment), per event and inject.  Event Status – start/end date & time, ready, active, complete.  Inject Status – start time date, ready, active, complete.  Training Objectives – selectable against events.  Free text follow-up detail box per inject.  Timeline view with all data interactive and ‘draggable’.  Event view – filterable and sortable.  Inject View – filterable and sortable.  Training Objective view – filterable and sortable.  Multi User with client server architecture.  Permissions - admin, edit, view.  Static data entry ahead of event.