Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Interface Design _ Edms Database

Posted by: napster75 Jun 29 2019, 02:33 AM

Hi,

I would like to hear some comments on my EDMS database trying to build my own database based on my every day task. Still not finish and asking if anyone have any ideas. My problem is revision history how can i make a query that will display only the latest documents. thank you in advance

 EDMS_Sample.zip ( 85.09K ): 84
 

Posted by: orange999 Jun 29 2019, 05:37 AM

In order to comment on your EDMS database, it would be helpful to know what your "every day task" consists of in simple terms.

Posted by: napster75 Jun 29 2019, 06:51 AM

What Im trying to do is make a document management system with revision history (Incoming and Outgoing Documents) based on ms access that will count all the records by type, discipline and status. Currently Im using excel in entering all the data.

Thank you

Posted by: GroverParkGeorge Jun 29 2019, 07:23 AM

Welcome to UtteerAccess.

Does this database have features and functions similar to what you would get with a SharePoint site on Office 365?

What advantages does your Access solution offer over SharePoint's document management?

Posted by: napster75 Jun 29 2019, 07:32 AM

Yes is the same in SharePoint is but the problem is we don't have that we used only excel for all the monitoring and this excel files stored in the network server.

Posted by: napster75 Jun 30 2019, 01:09 AM

Hi orange999,

Here is the flow chart of my every day task outgoing and incoming this is all done in excel and pdf.


 

Posted by: orange999 Jun 30 2019, 01:38 PM

Here's a http://www.databaseanswers.org/data_models/document_management/index.htm that may provide some insight.
Good luck.