Access2002是正确的选择 [英] Is Access2002 the right choice

问题描述

是的，我的家族企业想要创建一个会计数据库来保持发票，生产，库存，工时等的跟踪....


将有两种用户访问数据库，最多两台不同的计算机。 （管理员和用户）


桌子尺寸不会太大。我想最大的桌子上有1万条记录

。 （它们将每年更换，即：

表格中的所有记录将被删除并每年备份。）


将会有很多表格加入以打印查询

报告。我认为它在

表之间被称为多对多关系。


我的问题是MS Access 2002又名：MSAccessXP能够<如果它用于后端和前端，则
处理此工作负载？比如，5个月后或明年，
，Access数据库是否仍然可以运行，并且
不会给我们带来任何麻烦（崩溃，太慢等）。


我有一些计算机编程经验，我愿意学习

任何新东西。

我不想做这个数据库太复杂了，因为剩下的

家庭对计算机的了解并不是很好。


感谢您的帮助。

Yes, my family business wants to create an accounting database to keep
track of invoices, production, inventory, man hours, etc....

There will be two kinds of users to access the database, on two
different computers at max. (Admin and User)

The table sizes won''t get too big. I am thinking 10 thousand records
at max for the biggest table. (they will be replaced each year, ie:
all the records in the tables will be removely and backed up yearly).

There will be alot of table joining to make queries to print out
reports though. I think it''s called Many to Many relationships between
tables.

The question i have is will MS Access 2002 aka: MSAccessXP be able to
handle this workload if it''s used for the backend and frontend? Like,
5 months later, or next year, will the Access database still work and
not give us any troubles (crashing, too slow, etc).

I have some computer programming experience and i''m willing to learn
anything new.
I don''t wanna make this database too complicated because the rest of
family doesn''t know computers very well.

Thanks for your help.

推荐答案

保存自己很多悲伤并购买像quickbooks这样的东西。

" Mark" < MC ****** @ uoguelph.ca>在消息中写道

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

Save yourself alot of grief and buy something like quickbooks.
"Mark" <mc******@uoguelph.ca> wrote in message
news:14**************************@posting.google.c om...

是的，我的家族企业想要创建一个会计数据库来跟踪发票，生产，库存，工时等等....

那里将两种用户访问数据库，最多两台不同的计算机。 （管理员和用户）

表的大小不会太大。我想最大的桌子上有一万条记录。 （它们将每年更换，即：
表中的所有记录将被删除并每年备份。）

将有很多表连接以进行打印查询
报道。我认为它在
表之间被称为多对多关系。

我的问题是MS Access 2002又名：MSAccessXP能够处理这个工作量，如果它用于后端和前端？比如，
5个月后或明年，Access数据库是否仍然有用，并且不会给我们带来任何麻烦（崩溃，太慢等）。

我有一些计算机编程经验，我愿意学习任何新的东西。
我不想让这个数据库太复杂，因为其他的家庭对计算机的了解并不是很好。

感谢您的帮助。

Yes, my family business wants to create an accounting database to keep
track of invoices, production, inventory, man hours, etc....

There will be two kinds of users to access the database, on two
different computers at max. (Admin and User)

The table sizes won''t get too big. I am thinking 10 thousand records
at max for the biggest table. (they will be replaced each year, ie:
all the records in the tables will be removely and backed up yearly).

There will be alot of table joining to make queries to print out
reports though. I think it''s called Many to Many relationships between
tables.

The question i have is will MS Access 2002 aka: MSAccessXP be able to
handle this workload if it''s used for the backend and frontend? Like,
5 months later, or next year, will the Access database still work and
not give us any troubles (crashing, too slow, etc).

I have some computer programming experience and i''m willing to learn
anything new.
I don''t wanna make this database too complicated because the rest of
family doesn''t know computers very well.

Thanks for your help.

Access数据库，配置良好，编写良好，维护良好，将

对这种工作量没有任何问题。


会计产品遍布市场。库存产品不太多b $ b很难找到。时间表应用无处不在。考虑一下家庭的业务是否确实需要建立自己的数据库，或者购买一个或多个产品是否能够更好地完成工作。

>

Jeremy


-

Jeremy Wallace

AlphaBet City Dataworks
< a rel =nofollowhref =http://www.ABCDataworks.comtarget =_ blank> http://www.ABCDataworks.com

" Mark" < MC ****** @ uoguelph.ca>在消息中写道

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

An Access database, well configured, well written, and well maintained, will
have no trouble with that kind of workload.

Accounting products are all over the market. Inventory products are not too
hard to find. Time sheet applications are everywhere. Consider whether
you''re family''s business really needs to build their own database or whether
buying one or more products would do the job better.

Jeremy

--
Jeremy Wallace
AlphaBet City Dataworks
http://www.ABCDataworks.com
"Mark" <mc******@uoguelph.ca> wrote in message
news:14**************************@posting.google.c om...

是的，我的家族企业想要创建一个会计数据库来跟踪发票，生产，库存，工时等等....

那里将两种用户访问数据库，最多两台不同的计算机。 （管理员和用户）

表的大小不会太大。我想最大的桌子上有一万条记录。 （它们将每年更换，即：
表中的所有记录将被删除并每年备份。）

将有很多表连接以进行打印查询
报道。我认为它在
表之间被称为多对多关系。

我的问题是MS Access 2002又名：MSAccessXP能够处理这个工作量，如果它用于后端和前端？比如，
5个月后或明年，Access数据库是否仍然有用，并且不会给我们带来任何麻烦（崩溃，太慢等）。

我有一些计算机编程经验，我愿意学习任何新的东西。
我不想让这个数据库太复杂，因为其他的家庭对计算机的了解并不是很好。

感谢您的帮助。

Yes, my family business wants to create an accounting database to keep
track of invoices, production, inventory, man hours, etc....

There will be two kinds of users to access the database, on two
different computers at max. (Admin and User)

The table sizes won''t get too big. I am thinking 10 thousand records
at max for the biggest table. (they will be replaced each year, ie:
all the records in the tables will be removely and backed up yearly).

There will be alot of table joining to make queries to print out
reports though. I think it''s called Many to Many relationships between
tables.

The question i have is will MS Access 2002 aka: MSAccessXP be able to
handle this workload if it''s used for the backend and frontend? Like,
5 months later, or next year, will the Access database still work and
not give us any troubles (crashing, too slow, etc).

I have some computer programming experience and i''m willing to learn
anything new.
I don''t wanna make this database too complicated because the rest of
family doesn''t know computers very well.

Thanks for your help.

" Mark"写了

"Mark" wrote

是的，我的家族企业想要创建一个会计数据库来跟踪发票，生产，库存，工时等等....


正如您所知，有许多会计应用程序，

商业，不太昂贵，经过充分测试和证明。他们中很少使用

Access / Jet数据库;在Access中实现的更少。但是，如果您获得一个_is_，那么您可以增强功能并分析

商业数据...

我有的问题是MS Access
2002又名：MSAccessXP能够处理这个工作量，如果它用于
后端和前端吗？ ...


是的，它应该。

我有一些计算机编程经验，我愿意学习
任何新的东西。

Yes, my family business wants to
create an accounting database to keep
track of invoices, production, inventory,
man hours, etc....
As you have been told, there are many accounting applications available,
commercial, not too expensive, well-tested, and proven. Few of them use
Access / Jet databases; even fewer are implemented in Access. But, if you
get one that _is_, you can enhance the functionality and analyze the
business data...
The question i have is will MS Access
2002 aka: MSAccessXP be able to
handle this workload if it''s used for the
backend and frontend? ...
Yes, it should.
I have some computer programming
experience and i''m willing to learn
anything new.

我有理由相信你可以花费数百甚至数千美元来创建一个数据库应用程序为完整的业务做会计

。但是，您可能希望在商业数据库中执行一些额外的操作，或者对信息执行分析。所以这里

是另一种选择：

访问 http://www.databasecreations.com 并看看他们有什么......

他们已经更改了名称，但他们有一个他们以前打电话的产品是的，

我可以使用Access运行我的业务 - 你得到了源代码，所以如果你想用数据做其他事情，你可以添加它们或改变它们的内容。


那里是其他Access实施的会计数据库，但我不熟悉他们或与他们熟悉的公司。


Larry Linson

Microsoft Access MVP

I am reasonably sure that you can expect to expend hundreds, if not
thousands, of hours to create a database application to do the accounting
for a complete business. But, you may want to do some additional things not
in the commercial databases, or perform analyses on the information. So here
is another option:

Visit http://www.databasecreations.com and take a look at what they have...
they have changed the name, but they have a product they used to call "Yes,
I Can Run My Business With Access" -- you get the source, so if you want to
do other things with the data, you can add them or change what is there.

There are other Access-implemented accounting databases, but I am not
familiar either with them or with the companies that do them.

Larry Linson
Microsoft Access MVP

这篇关于Access2002是正确的选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！