I am a programmer, and my father uses Access to collect the patients information (my father is a doctor),
我是程序员,我的父亲使用Access来收集患者信息(我父亲是医生),
He wants me to teach him how to use it.
他希望我教他如何使用它。
I don't like Access (I'm a linux guy), and I cannot find any replacement of it. Do you guys know of any? (it must be easy enough for my father to use)
我不喜欢Access(我是一个Linux人),我找不到任何替代品。你们知道吗? (它必须很容易让我父亲使用)
13 个解决方案
#1
5
Access is not always the monster it is made out to be. A poorly coded database in any application or language is a poorly coded database. Access' dominance of the market at a critical time led to more people coming across a higher ratio of poorly designed databases. There's a great deal of support out there for Access users and programmers too. I particularly like Access World Forums. As ilivewithian said, if you're not happy telling him about it, get someone else to.
访问并不总是成为它的怪物。任何应用程序或语言中编码不良的数据库都是编码不良的数据库。在关键时刻获得市场主导地位导致更多人在设计不良的数据库中遇到更高的比例。 Access用户和程序员也有很多支持。我特别喜欢Access World论坛。正如ilivewithian所说,如果你不高兴告诉他这件事,那就让其他人来。
If however you are keen to take on the role of tutor to your dad (and I can see the attraction - a chance to give something back, perhaps), then I would suggest a web-based database interface. Unlike Oli, I have no experience of Django, but I would recommend Dabble or blist. (Blist is particularly good at handling images, Dabble is better at flexible report formats, though neither is as good at reports as Access, IMHO).
但是,如果你热衷于担任导师的角色(我可以看到吸引力 - 也许有机会回馈),那么我会建议一个基于网络的数据库界面。与Oli不同,我没有Django的经验,但我会推荐Dabble或blist。 (Blist特别擅长处理图像,Dabble在灵活的报告格式方面表现更好,尽管两者在报告中都不如Access,恕我直言)。
#2
21
Maybe you need to be a bit more pragmatic about this.
也许你需要对此更加务实。
I'm not a fan of Access either, but if your father already understands it and he already has the system in place, you need to ask the question, why change? If it aint broke don't try to fix it.
我也不是Access的粉丝,但是如果你父亲已经理解了它并且他已经有了系统,你需要问这个问题,为什么要改变?如果它没有破坏,请不要尝试修复它。
You may find that a few simple changes in the existing system gives your father everything he needs, it'll save you a whole lot of time and means you don't need to retrain your father.
您可能会发现现有系统中的一些简单更改可以为您的父亲提供他所需要的一切,它可以为您节省大量时间并且意味着您无需重新训练您的父亲。
#4
8
Your father wants you to teach him how to use access but you're a linux guy and don't like access. Access isn't the problem here I don't think you and your father a good fit for this.
你的父亲希望你教他如何使用访问,但你是一个Linux家伙,不喜欢访问。访问不是问题在这里我不认为你和你的父亲适合这一点。
Get someone else to teach him how to use Access
让其他人教他如何使用Access
#5
2
I think the natural successor to Access is a simple web-interface database system.
我认为Access的自然继承者是一个简单的Web界面数据库系统。
They're simple enough to create in a billion different ways but I would seriously suggest trying Django (because you'll find its admin area does 90% of the real work for you in this case)
它们很简单,可以用十亿种不同的方式创建,但我会认真地建议尝试使用Django(因为在这种情况下,你会发现它的管理区域为你提供了90%的实际工作)
#6
2
FileMaker Inc. is subsidiary of Apple. It runs on Mac OS X as well as Windows (whereas MS Access only runs on Windows). Many people claim FileMaker is easier to use than MS Access. Sounds like FileMaker might be the perfect solution for you! (although I do agree with ilivewithian)
FileMaker Inc.是Apple的子公司。它可以在Mac OS X和Windows上运行(而MS Access只能在Windows上运行)。许多人声称FileMaker比MS Access更容易使用。听起来像FileMaker可能是你的完美解决方案! (虽然我同意ilivewithian)
There's also Sun's counterpart to MS Access in OpenOffice/StarOffice called BASE (someone already mentioned this), which is also cross-platform compatible.
在OpenOffice / StarOffice中还有Sun与MS Access的对应名称为BASE(有人已经提到过这个),它也是跨平台兼容的。
#7
1
Rather than develop his own record keeping application he would probably be better off purchasing an already developed system from one of the numerous medical record system vendors. He'll get a better application and have people he can call on for support. Plus there are all of the legal issues about medical record storage and access. A vendor will have worked out those problems already.
与其开发自己的记录保存应用程序,他可能最好从众多医疗记录系统供应商之一购买已经开发的系统。他会得到一个更好的应用程序,并有他可以请求支持的人。此外,还有关于医疗记录存储和访问的所有法律问题。供应商已经解决了这些问题。
That having been said there are many other file based databased systems out there: http://www.google.com/search?q=file+based+database
据说那里有许多其他基于文件的数据库系统:http://www.google.com/search?q = file+based+database
I haven't used any of them so I can't make a recommendation.
我没有使用过它们,所以我无法提出建议。
Of course, there's always the various enterprise databases (Oracle, MySQL, SQL Server, etc...) as well. Of those SQL Server is probably the easiest to learn for a newbie. Since there's no 64 bit version of Access I'm starting to see people replace Access with SQL Server Express (free!) for small applications that need to run on 64 bit windows.
当然,总有各种企业数据库(Oracle,MySQL,SQL Server等)。其中SQL Server可能是最容易学习新手的。由于没有64位版本的Access,我开始看到人们用需要在64位窗口上运行的小型应用程序替换Access与SQL Server Express(免费!)。
#8
1
I am using Viravis now for more than 6 months in a multi-language organization with several projects and I find it very good. It's not only easy to build (I am a beginner) but they give also very good support!
我现在使用Viravis在一个有多个项目的多语言组织中工作超过6个月,我发现它非常好。它不仅易于构建(我是初学者),而且它们也提供了非常好的支持!
#9
1
Gambas ist a very good alternative for Access if one used Access as a database frontend and programmed with VBA (Visual Basic fro Applications). One can reuse a lot of code written for Access and create forms and reports easily.
如果使用Access作为数据库前端并使用VBA(Visual Basic for Applications)编程,Gambas是Access的一个非常好的替代品。可以重用大量为Access编写的代码,并轻松创建表单和报表。
So for a VB or VBA programmer, who wants to use the own knowledge under Linux, Gambas is a wonderful solution.
因此,对于想要在Linux下使用自己的知识的VB或VBA程序员来说,Gambas是一个很棒的解决方案。
#10
0
No first hand experience, but you can try out OpenOffic.org Database. Or, you may teach your Dad to use the MySQL GUI tool.
没有第一手经验,但您可以试用OpenOffic.org数据库。或者,您可以教您的爸爸使用MySQL GUI工具。
#11
0
Getting the database structure is the toughest part for most. Creating a simple form or report is not that tough either. As far as being a users (data entry, reports, etc.) is probably easier than most applications. You also have all the searching and sorting capabilities; why reinvent the wheel?
获取数据库结构是大多数人最难实现的部分。创建一个简单的表单或报告也不是那么困难。就用户而言(数据输入,报告等)可能比大多数应用程序更容易。您还拥有所有搜索和排序功能;为什么重新发明*?
#12
0
Viravis may be an online alternative to the access database. You should better to check it out if it fit your need.
Viravis可能是访问数据库的在线替代品。如果符合您的需要,您最好检查一下。
#13
-1
For Windows and simple data, I would use Excel, so I think Open Office should be ok. Unless your father has a hospital, it will probably fit... Or you can do some programming, take embedded database like Firebird and write something on your own, say - in Java?
对于Windows和简单数据,我会使用Excel,所以我认为Open Office应该没问题。除非你的父亲有医院,否则它可能适合......或者你可以做一些编程,像Firebird那样使用嵌入式数据库并自己写一些东西,比如说 - 用Java?
#1
5
Access is not always the monster it is made out to be. A poorly coded database in any application or language is a poorly coded database. Access' dominance of the market at a critical time led to more people coming across a higher ratio of poorly designed databases. There's a great deal of support out there for Access users and programmers too. I particularly like Access World Forums. As ilivewithian said, if you're not happy telling him about it, get someone else to.
访问并不总是成为它的怪物。任何应用程序或语言中编码不良的数据库都是编码不良的数据库。在关键时刻获得市场主导地位导致更多人在设计不良的数据库中遇到更高的比例。 Access用户和程序员也有很多支持。我特别喜欢Access World论坛。正如ilivewithian所说,如果你不高兴告诉他这件事,那就让其他人来。
If however you are keen to take on the role of tutor to your dad (and I can see the attraction - a chance to give something back, perhaps), then I would suggest a web-based database interface. Unlike Oli, I have no experience of Django, but I would recommend Dabble or blist. (Blist is particularly good at handling images, Dabble is better at flexible report formats, though neither is as good at reports as Access, IMHO).
但是,如果你热衷于担任导师的角色(我可以看到吸引力 - 也许有机会回馈),那么我会建议一个基于网络的数据库界面。与Oli不同,我没有Django的经验,但我会推荐Dabble或blist。 (Blist特别擅长处理图像,Dabble在灵活的报告格式方面表现更好,尽管两者在报告中都不如Access,恕我直言)。
#2
21
Maybe you need to be a bit more pragmatic about this.
也许你需要对此更加务实。
I'm not a fan of Access either, but if your father already understands it and he already has the system in place, you need to ask the question, why change? If it aint broke don't try to fix it.
我也不是Access的粉丝,但是如果你父亲已经理解了它并且他已经有了系统,你需要问这个问题,为什么要改变?如果它没有破坏,请不要尝试修复它。
You may find that a few simple changes in the existing system gives your father everything he needs, it'll save you a whole lot of time and means you don't need to retrain your father.
您可能会发现现有系统中的一些简单更改可以为您的父亲提供他所需要的一切,它可以为您节省大量时间并且意味着您无需重新训练您的父亲。
#3
#4
8
Your father wants you to teach him how to use access but you're a linux guy and don't like access. Access isn't the problem here I don't think you and your father a good fit for this.
你的父亲希望你教他如何使用访问,但你是一个Linux家伙,不喜欢访问。访问不是问题在这里我不认为你和你的父亲适合这一点。
Get someone else to teach him how to use Access
让其他人教他如何使用Access
#5
2
I think the natural successor to Access is a simple web-interface database system.
我认为Access的自然继承者是一个简单的Web界面数据库系统。
They're simple enough to create in a billion different ways but I would seriously suggest trying Django (because you'll find its admin area does 90% of the real work for you in this case)
它们很简单,可以用十亿种不同的方式创建,但我会认真地建议尝试使用Django(因为在这种情况下,你会发现它的管理区域为你提供了90%的实际工作)
#6
2
FileMaker Inc. is subsidiary of Apple. It runs on Mac OS X as well as Windows (whereas MS Access only runs on Windows). Many people claim FileMaker is easier to use than MS Access. Sounds like FileMaker might be the perfect solution for you! (although I do agree with ilivewithian)
FileMaker Inc.是Apple的子公司。它可以在Mac OS X和Windows上运行(而MS Access只能在Windows上运行)。许多人声称FileMaker比MS Access更容易使用。听起来像FileMaker可能是你的完美解决方案! (虽然我同意ilivewithian)
There's also Sun's counterpart to MS Access in OpenOffice/StarOffice called BASE (someone already mentioned this), which is also cross-platform compatible.
在OpenOffice / StarOffice中还有Sun与MS Access的对应名称为BASE(有人已经提到过这个),它也是跨平台兼容的。
#7
1
Rather than develop his own record keeping application he would probably be better off purchasing an already developed system from one of the numerous medical record system vendors. He'll get a better application and have people he can call on for support. Plus there are all of the legal issues about medical record storage and access. A vendor will have worked out those problems already.
与其开发自己的记录保存应用程序,他可能最好从众多医疗记录系统供应商之一购买已经开发的系统。他会得到一个更好的应用程序,并有他可以请求支持的人。此外,还有关于医疗记录存储和访问的所有法律问题。供应商已经解决了这些问题。
That having been said there are many other file based databased systems out there: http://www.google.com/search?q=file+based+database
据说那里有许多其他基于文件的数据库系统:http://www.google.com/search?q = file+based+database
I haven't used any of them so I can't make a recommendation.
我没有使用过它们,所以我无法提出建议。
Of course, there's always the various enterprise databases (Oracle, MySQL, SQL Server, etc...) as well. Of those SQL Server is probably the easiest to learn for a newbie. Since there's no 64 bit version of Access I'm starting to see people replace Access with SQL Server Express (free!) for small applications that need to run on 64 bit windows.
当然,总有各种企业数据库(Oracle,MySQL,SQL Server等)。其中SQL Server可能是最容易学习新手的。由于没有64位版本的Access,我开始看到人们用需要在64位窗口上运行的小型应用程序替换Access与SQL Server Express(免费!)。
#8
1
I am using Viravis now for more than 6 months in a multi-language organization with several projects and I find it very good. It's not only easy to build (I am a beginner) but they give also very good support!
我现在使用Viravis在一个有多个项目的多语言组织中工作超过6个月,我发现它非常好。它不仅易于构建(我是初学者),而且它们也提供了非常好的支持!
#9
1
Gambas ist a very good alternative for Access if one used Access as a database frontend and programmed with VBA (Visual Basic fro Applications). One can reuse a lot of code written for Access and create forms and reports easily.
如果使用Access作为数据库前端并使用VBA(Visual Basic for Applications)编程,Gambas是Access的一个非常好的替代品。可以重用大量为Access编写的代码,并轻松创建表单和报表。
So for a VB or VBA programmer, who wants to use the own knowledge under Linux, Gambas is a wonderful solution.
因此,对于想要在Linux下使用自己的知识的VB或VBA程序员来说,Gambas是一个很棒的解决方案。
#10
0
No first hand experience, but you can try out OpenOffic.org Database. Or, you may teach your Dad to use the MySQL GUI tool.
没有第一手经验,但您可以试用OpenOffic.org数据库。或者,您可以教您的爸爸使用MySQL GUI工具。
#11
0
Getting the database structure is the toughest part for most. Creating a simple form or report is not that tough either. As far as being a users (data entry, reports, etc.) is probably easier than most applications. You also have all the searching and sorting capabilities; why reinvent the wheel?
获取数据库结构是大多数人最难实现的部分。创建一个简单的表单或报告也不是那么困难。就用户而言(数据输入,报告等)可能比大多数应用程序更容易。您还拥有所有搜索和排序功能;为什么重新发明*?
#12
0
Viravis may be an online alternative to the access database. You should better to check it out if it fit your need.
Viravis可能是访问数据库的在线替代品。如果符合您的需要,您最好检查一下。
#13
-1
For Windows and simple data, I would use Excel, so I think Open Office should be ok. Unless your father has a hospital, it will probably fit... Or you can do some programming, take embedded database like Firebird and write something on your own, say - in Java?
对于Windows和简单数据,我会使用Excel,所以我认为Open Office应该没问题。除非你的父亲有医院,否则它可能适合......或者你可以做一些编程,像Firebird那样使用嵌入式数据库并自己写一些东西,比如说 - 用Java?