|
Is there going to be an Admin or User Manual?
Yes most definitely. We will produce both User and Admin manual to help support your users. User manual will be covering sections of the system that are relevant to your users, while the Admin manual will go into far more details about the system itself and the layer of complexity that may not be necessary or relevant to your day-to-day user. Although most manuals are different in topics that they cover and the systems that they explain, some of our recent manuals were over 100 pages. We generally provide a lot of screen captures which we found helps a user to feel a bit more comfortable as they see a picture what they should see instead trying to imagine it were only a textual representation.
Is there going to be a Data Dictionary and E-R Diagram?
Yes. We will produce the Data Dictionary and the Entity Relationship Diagram. Both will be an invaluable asset to anyone that may need to look at the database, to enhance it or to correct it. It would also assist the developers and managers to create additional queries or reports.
How about versioning and backup?
Each release of the database provided to you from Datacube will have different release number. Backup is reasonably simple, as MS Access automatically backs up the database when it gets closed. You would still need to perform your normal backup process for the main PC. These would be according to your current process. Although if you need assistance in trying to enhances it we will be able to help you.
How about database corruptions?
If your database gets corrupt for whatever reason (network problems, loss of power, invalid data etc) we will be able to help you to try and recover your database.
What will the database look like?
We will check with you what sort of look and feel you wish to achieve. If you prefer to leave the design to us, we will provide you with functionally best layout. Generally if it is a Microsoft Access database we tend to create Main menu (Switchboard) for easier navigation. If it is a database driven website we will use menu with a dropdown options to maximise the real-estate on the screen. We are always open to your suggestions.
We will follow your company’s colour scheme and will incorporate your logos in to the database / website design.
How about our current data in the excel spreadsheet?
In regards to your current data, we have to options. We either bring it over or data enter it from the scratch. Currently if your data is stored in the excel spreadsheet which makes it easy to keep track of all the details in one spreadsheet, for it to fit in the database it needs to be cleaned up (ie Surnames in surname column, mobile number in mobile number column etc.) and then uploaded to the database.
|