访问是否合适？ [英] Is access suitable?

问题描述

我目前拥有水果和蔬菜业务，并希望计算我的

手工方法，以减少人工成本。我和我的儿子说过，他/她是一个计算机上的高手，他和我聊得很好，并解释说我需要的是可能的，但他不确定他是否有

履行的能力。他已经开始绘制一些计划了，我将会尝试解释我需要从软件中获得什么。这将是b $ b需要用户友好和基于Windows，涵盖三个方面，新的
客户发票，库存控制和客户数据库（类似于

sage）。


所有必须相互关联（我儿子解释过这个）当我输入新的

发票时，它会自动打印3份并删除库存来自

当前（在库存控制中监控）将实际将该发票添加到客户数据库并显示未付金额。首先，我的儿子

想知道是否有任何软件可以创建

这样一个''interlinked''数据库，从阅读其他帖子我想到的/>
ms-access可能是一个？如果不是推荐的语言。如果所有人都没有计划，是否有IT专家会接受这样的项目？


任何给予的帮助都会大大丰富。 J

I currently own a fruit and veg business and wish to compuiterise my
manual methods in order to reduce labour costs. I spoke to my son who
is a whiz on computers and he had a good chat with me and explained
that what I needed was possible but he was unsure if he had the
capabillities to carry it out. He has started drawing some plans and I
will attempt to explain what I will require from the software. It will
need to be user friendly and windows based, cover three areas, new
customer invoice, stock control, and customer database(similar to
sage).

All must be interlinked (my son has explained this) when I enter a new
invoice it will automatically print 3 copies and remove stock from
current(monitored in stock control) which will intern add that invoice
to the customer database and show an outstanding sum. Firstly my son
would like to know if there are any peices of software able to create
such an ''interlinked'' database, from reading other posts I figure
ms-access may be one? If not what language is recommended. If all does
not go to plan are there IT experts who will take on such a project?

Any help given is greatly apprichiated. J

推荐答案

脚本学习者，

这是我熟悉的一句话：购买商业包装因为建筑物/>
你自己几乎总是更昂贵，更耗时，而且更有可能让你的儿子希望你不是他的爸爸。您的电子邮件看起来像

来自英国。如果微软的Great Plains Accounting可以获得
，这是一项很好的投资。有一个便宜（呃）版本的

Peachtree会计，在

Script Learner,
It''s a familiar refrain from me: Buy a commercial package because building
your own is almost always more costly, more time consuming, and more likely
to cause your son to wish you were not his Dad. Your e-mail looks like it
originates out of the UK. If Microsoft''s Great Plains Accounting is
available there it is a good investment. There is a cheap(er) version of
Peachtree Accounting that sells for under

100.00美元下销售。 Intuit的QuickBooks

是另一个以合理价格完成所有这些工作的套餐。

现在，如果你仍然愿意投入时间，那么建立

你自己的软件，从一个细致，详细的计划开始。然后确保你建立，测试，重建，测试，实施，重新评估，重建，测试。 。 。在

有组织的方式。编写软件现在已经是半个世纪以来的一个领域了，并且在那个时候已经学到了很多关于如何做到这一点的好处

。你欠你的理智，你的儿子和你的理智。贵公司需要进行研究

需要找到有关如何规划和存在的丰富资料。构建一个

的应用程序。

至于我最喜欢的最佳实践，我喜欢MSDE或其他一些SQL的版本

Server。 Jet非常好，简化了小项目的工作，但运行一个

公司很容易超过Jet维护

数据的能力 - 所以请使用MSDE或SQL Server，或类似的东西。每当

成为可能时，我会尝试在SQL或Transact SQL中执行所有操作。如果我没有使用包含用户界面的Access ADP项目文件，那么我就不会这样了。

未绑定表格&由于很多原因，报告是一个好主意。并且，给定一个

的选择，我会找出一个我可以在VB中实现的对象模型，它成为我的应用程序的

基础。

那是高音。剩下的就是很多。祝你好运。


" script-learner" < JL ****** @ webmasters.freeserve.co.uk>在留言中写道

news：90 ************************** @ posting.google.c om ...

100.00 US. Intuit''s QuickBooks
is another package which will do all this for a reasonable price.
Now, if you are still willing to invest in the time it will take to build
your own software, start with a careful, detailed plan. Then make sure you
build, test, rebuild, test, implement, re-evaluate, rebuild, test . . . in
an organized manner. Writing software is now a field that is over a
half-century old and in that time much has been learned about how to do it
well. You owe it to your sanity, your son & your company to do the research
needed to find the wealth of material that exists on how to plan & build an
application.
As for my favorite best practices, I love MSDE or some other flavor of SQL
Server. Jet is nice and simplifies things for small projects but running a
company is something that will easily outpace Jet''s ability to maintain the
data--so go with MSDE or SQL Server, or something equivilant. Whenever
possible, I try to do everything in SQL or Transact SQL. Failing that I
like working with Access ADP project files that contain the user interface.
Unbound forms & reports are a good idea for lots of reasons. And, given a
choice, I''d work out an object model I can implement in VB that becomes the
foundation for my application.
That''s the high notes. The rest is a lot. Good luck.

"script-learner" <jl******@webmasters.freeserve.co.uk> wrote in message
news:90**************************@posting.google.c om...

我目前拥有水果和蔬菜业务，并希望计算我的手工方法，以减少人工成本。我和我的儿子说过，他是个电脑上的高手，他和我聊得很好，并解释说我需要的是可能的，但他不确定自己是否有能力随身携带出来。他已经开始绘制一些计划，我将尝试解释我将从软件中要求的内容。它将需要用户友好和基于Windows，涵盖三个方面，新的
客户发票，库存控制和客户数据库（类似于圣人）。
所有必须相互关联（我的儿子解释了这一点）当我输入新的
发票时，它会自动打印3份并从
当前（库存控制中监控）中移除库存，这将实习生添加该发票<到客户数据库并显示出色的总和。首先，我的儿子
想知道是否有任何软件可以创建这样一个''interlinked''数据库，从阅读其他帖子我的数字
ms-access可能是一个？如果不是推荐的语言。如果一切都没有按计划进行，那么是否有IT专家会接受这样的项目？

任何给予的帮助都会大大丰富。 J

I currently own a fruit and veg business and wish to compuiterise my
manual methods in order to reduce labour costs. I spoke to my son who
is a whiz on computers and he had a good chat with me and explained
that what I needed was possible but he was unsure if he had the
capabillities to carry it out. He has started drawing some plans and I
will attempt to explain what I will require from the software. It will
need to be user friendly and windows based, cover three areas, new
customer invoice, stock control, and customer database(similar to
sage).

All must be interlinked (my son has explained this) when I enter a new
invoice it will automatically print 3 copies and remove stock from
current(monitored in stock control) which will intern add that invoice
to the customer database and show an outstanding sum. Firstly my son
would like to know if there are any peices of software able to create
such an ''interlinked'' database, from reading other posts I figure
ms-access may be one? If not what language is recommended. If all does
not go to plan are there IT experts who will take on such a project?

Any help given is greatly apprichiated. J

在消息< 90 ************************* *@posting.google.com>，

script-learner< jl ****** @ webmasters.freeserve.co.uk>写道

In message <90**************************@posting.google.com >,
script-learner <jl******@webmasters.freeserve.co.uk> writes

我目前拥有水果和蔬菜业务，并希望计算我的手工方法，以减少人工成本。我和我的儿子说过，他是个电脑上的高手，他和我聊得很好，并解释说我需要的是可能的，但他不确定自己是否有能力随身携带出来。他已经开始绘制一些计划，我将尝试解释我将从软件中要求的内容。它将需要用户友好和基于Windows，涵盖三个方面，新的
客户发票，库存控制和客户数据库（类似于圣人）。
所有必须相互关联（我的儿子解释了这一点）当我输入新的
发票时，它会自动打印3份并从
当前（库存控制中监控）中移除库存，这将实习生添加该发票<到客户数据库并显示出色的总和。首先，我的儿子
想知道是否有任何软件可以创建这样一个''interlinked''数据库，从阅读其他帖子我的数字
ms-access可能是一个？如果不是推荐的语言。如果一切都没有按计划进行，那么是否有IT专家会接受这样的项目？

任何给予的帮助都会大大丰富。 J

I currently own a fruit and veg business and wish to compuiterise my
manual methods in order to reduce labour costs. I spoke to my son who
is a whiz on computers and he had a good chat with me and explained
that what I needed was possible but he was unsure if he had the
capabillities to carry it out. He has started drawing some plans and I
will attempt to explain what I will require from the software. It will
need to be user friendly and windows based, cover three areas, new
customer invoice, stock control, and customer database(similar to
sage).

All must be interlinked (my son has explained this) when I enter a new
invoice it will automatically print 3 copies and remove stock from
current(monitored in stock control) which will intern add that invoice
to the customer database and show an outstanding sum. Firstly my son
would like to know if there are any peices of software able to create
such an ''interlinked'' database, from reading other posts I figure
ms-access may be one? If not what language is recommended. If all does
not go to plan are there IT experts who will take on such a project?

Any help given is greatly apprichiated. J

当然可以访问你所描述的所有内容，

但这并不一定能使它成为正确的工具为了工作。如果你的b $ b儿子不知道那么他可能不太了解Access

自己无需帮助就能完成这项工作。他或许能够学习，但是这需要时间。在那段时间你会犯错误而且

会引起很多焦虑。


有些人可以进来看看你的生意，分析你做了什么
然后编程Access以帮助你做到这一点。你可能无法承担雇佣任何好人的费用。好的定制软件很贵。


我的建议是与其他类似企业的人交谈并询问

他们使用什么软件。与他们购买软件的人交谈

来看看它是否适合您的需求。


您可能会发现没有合适的东西在市场上。在那个

的情况下，您可能想要设计自己的系统。访问是

那个工作的好工具。但是不要指望在一个下午建立完整的系统，

甚至一年。你应该首先构建一些东西以帮助你现有的手动流程，并在你需要时添加新的功能

确保你设计的东西每次都正常工作。 br />

你可以期待通过像这样的新闻组获得一些帮助，但在

一般来说，困难的问题不是技术问题。它们可能与您的业务运作方式有关，以及业务如何将b $ b流程转换为可编写程序的内容。


-

Bernard Peek

伦敦，英国。 DBA，经理，培训师和作者。会为钱而努力。

Access can certainly be made to do everything that you have described,
but that doesn''t necessarily make it the right tool for the job. If your
son didn''t know that then he probably doesn''t know enough about Access
to do the job himself without help. He may be able to learn, but that
will take time. During that time you will both make mistakes and that
could cause a lot of angst.

There are people who can come in and look at your business, analyse what
you do and then program Access to help you do it. You probably can''t
afford to hire anyone who is any good. Good custom-made software is
expensive.

My advice would be to talk to other people in similar businesses and ask
them what software they use. Talk to whoever they bought their software
from to see if it can be adapted to your needs.

You may find that there isn''t anything suitable on the market. In that
case you may want to design your own system. Access is a good tool for
that job. But don''t expect to build the complete system in an afternoon,
or even in a year. You should start by building something to assist some
of your existing manual processes, and add new functions when you are
sure that what you have designed works right every time.

You can expect to get some help through newsgroups like this one, but in
general the difficult questions aren''t technical ones. They are more
likely to be about the way your business works, and how business
processes can be translated into something you can write a program for.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

这篇关于访问是否合适？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！