准备做一些困难的事情 [英] preparing to do something difficult

问题描述

大家好，


不久之前，我在构建一系列与某个复杂数据库相关的表单方面获得了很多帮助。现在我回来了一个搜索表单问题。


我为他们构建数据库的人 - 他们让我根据他们会问的问题创建一堆表D b。这需要我创建一堆查询 - 没有太难，但他们访问了许多表。我还根据其他查询的结果构建了一些交叉表查询。


现在他们希望我构建一些搜索表单，以便他们可以在没有问题的情况下提出问题不得不经历我。所以我需要构建一些易于使用的搜索表单（我假设使用了一堆列表框），这些表格会吐出一些可以导出到excel的表格（因为这是他们熟悉的内容）用于格式化报告等）。


所以我的问题是这样的：鉴于对Access的了解有限（我在这个项目上削减了牙齿）是这样可行的吗？我知道这对于一位专家来说是可行的，我在问这对初学者和中级人员是否可行，他能够理解代码并改变她在互联网上找到的代码，但不是从零开始的程序员。


表格示例：一般拖网数据（日期，拖网编号，人员，位置）

捕捞数据（拖网编号，标本编号，捕获的编号，处置时的处置）捕获，释放时的处置）

标本数据（标本ID，标本名称，学名，属）


问题示例：

按捕获的数量排序的样本数量和按位置分组的名称

按捕获的数量排序的样本数量和按日期按位置分组的名称

订购的样本数量按号码捕获并按名称按位置和释放处置按名称分组


感谢您提供任何建议（包括现在放弃姐妹），见解和/或示例链接！ ！

Hello all,

A while ago I got a lot of help on building a bunch of forms tied to a somewhat complicated db. Now I''m back with a search form question.

The guys that I built the db for - they asked me to create a bunch of tables based on questions they would ask of the db. This required me to create a bunch of queries - none too difficult but they accessed a number of tables. I also built some crosstab queries based on the results of other queries.

Now they would like me to build them some kind of search form so that they can ask their questions of the data without having to go through me. So I need to build some kind of easy-to-use search form (I''m assuming utilizing a bunch of listboxes) that will spit out some tables that can be exported to excel (because that''s what they are familiar with using for formatting for reports, etc).

So my question comes to this: given a limited knowledge of Access (I cut my teeth on this project) is something like this doable? I know it''s doable for an expert, I''m asking if its doable for a beginner to intermediate who can understand code and alter given code she finds on the internet, but isn''t a programmer from scratch.

Examples of tables: general trawl data (date, trawl number, staff, location)
Catch data (trawl number, specimen id, number caught, disposition at time of capture, disposition at time of release)
Specimen data (specimen id, specimen name, scientific name, genus)

Examples of questions:
Number of specimens ordered by number caught and name grouped by location
Number of specimens ordered by number caught and name grouped by date by location
Number of specimens ordered by number caught and name grouped by date by location and release dispostion

Thanks for any advice (including "give it up now sister"), insight, and/or links to examples!!

推荐答案

大家好，


前一段时间我在构建一堆表格方面得到了很多帮助绑在一个有点复杂的数据库。现在我回来了一个搜索表单问题。


我为他们构建数据库的人 - 他们让我根据他们会问的问题创建一堆表D b。这需要我创建一堆查询 - 没有太难，但他们访问了许多表。我还根据其他查询的结果构建了一些交叉表查询。


现在他们希望我构建一些搜索表单，以便他们可以在没有问题的情况下提出问题不得不经历我。所以我需要构建一些易于使用的搜索表单（我假设使用了一堆列表框），这些表格会吐出一些可以导出到excel的表格（因为这是他们熟悉的内容）用于格式化报告等）。


所以我的问题是这样的：鉴于对Access的了解有限（我在这个项目上削减了牙齿）是这样可行的吗？我知道这对于一位专家来说是可行的，我在问这对初学者和中级人员是否可行，他能够理解代码并改变她在互联网上找到的代码，但不是从零开始的程序员。


表格示例：一般拖网数据（日期，拖网编号，人员，位置）

捕捞数据（拖网编号，标本编号，捕获的编号，处置时的处置）捕获，释放时的处置）

标本数据（标本ID，标本名称，学名，属）


问题示例：

按捕获的数量排序的样本数量和按位置分组的名称

按捕获的数量排序的样本数量和按日期按位置分组的名称

订购的样本数量按号码捕获并按名称按位置和释放处置按名称分组


感谢您提供任何建议（包括现在放弃姐妹），见解和/或示例链接！ ！

Hello all,

A while ago I got a lot of help on building a bunch of forms tied to a somewhat complicated db. Now I''m back with a search form question.

The guys that I built the db for - they asked me to create a bunch of tables based on questions they would ask of the db. This required me to create a bunch of queries - none too difficult but they accessed a number of tables. I also built some crosstab queries based on the results of other queries.

Now they would like me to build them some kind of search form so that they can ask their questions of the data without having to go through me. So I need to build some kind of easy-to-use search form (I''m assuming utilizing a bunch of listboxes) that will spit out some tables that can be exported to excel (because that''s what they are familiar with using for formatting for reports, etc).

So my question comes to this: given a limited knowledge of Access (I cut my teeth on this project) is something like this doable? I know it''s doable for an expert, I''m asking if its doable for a beginner to intermediate who can understand code and alter given code she finds on the internet, but isn''t a programmer from scratch.

Examples of tables: general trawl data (date, trawl number, staff, location)
Catch data (trawl number, specimen id, number caught, disposition at time of capture, disposition at time of release)
Specimen data (specimen id, specimen name, scientific name, genus)

Examples of questions:
Number of specimens ordered by number caught and name grouped by location
Number of specimens ordered by number caught and name grouped by date by location
Number of specimens ordered by number caught and name grouped by date by location and release dispostion

Thanks for any advice (including "give it up now sister"), insight, and/or links to examples!!

您所描述的内容可能变得非常复杂，因为您必须创建某种条件表单，然后动态构建涉及多个表和联接的排序，排序顺序，分组级别等反映了这些选项。最简单的方法是让他们提交一份提议的问题列表，然后输入表格，创建一个列出这些问题的组合框，然后创建反映每个问题的存储查询。根据选择，将执行相应的查询，导出到Excel等。添加/删除问题及其相关查询也很容易。我担心的另一种选择可能非常复杂。在做出决定之前，请等待，看看其他一些专家/主持人对主题的看法。

What you are describing could become very complex in that you would have to create some kind of Criteria Form then dynamically build a SQL String involving multiple Tables and Joins, Sort Orders, Grouping Levels, etc. reflecting those options made. The easy way out would be to have ''them'' submit a list of proposed questions, enter then into a Table, create a Combo Box listing these questions, then create Stored Queries reflecting each question. Depending on the selection, the appropriate Query would be executed, Exported to Excel, etc. It would also be easy to Add/Remove questions and their associated Queries. The alternative, I''m afraid, could be very complex. Wait and see what some of the other Experts/Moderators have to say on the Subject before you make a decision.

哇。


看起来像您负责设计超级用户友好的查询构建器功能。

培训那些人使用Access查询构建器比编写逻辑将英语问题转换为SQL中的答案更容易吗？


问候，

鱼

Wow.

Looks like you are charged to design super-userfriendly query builder feature.
Would it be easier to train that guys to use Access query builder than to code logic translating questions in English to answers in SQL?

Regards,
Fish

嗨M :)


那些标本仍然有效在西北海岸那边？


您正在考虑的是一个查询设计引擎。这是有可能的，但对你这个级别的人来说有点强烈。

不要误会我的意思，因为我呐喊你肯定不是傻瓜，但在数据库方面也没有多少经验。

正如我所看到的，这样的任务很大程度上依赖于你理解和编码（非常）逻辑的能力。许多优秀的程序员不能仅仅因为逻辑要求太多而无法做引擎。

想一想在VBA中构建SQL字符串然后通过SQL解释器运行的要求。许多人都难以理解在添加到字符串之前需要处理哪些部分以及哪些部分被添加到字符串中以供解释器稍后处理。设计引擎涉及类似（但显然更复杂的）问题。

Hi M :)

Those specimens still active up there on the North-West coast?

What you''re considering is like a query design engine. It''s possible, but a little strong for someone at your level.
Don''t get me wrong, as I racall you were certainly not stupid, but not vastly experienced on the db side either.
As I see it, a task like this would rely very heavily on your ability to understand and code (very) logically. Many otherwise good programmers can''t do engines simply because the logic requirement is too much.
Think of the requirement to build SQL strings in VBA which are then run through the SQL interpreter. Many struggle with understanding which parts need to be processed before adding to the string and which are added to the string for later processing by the interpreter. Designing an engine involves similar (but obviously more complex still) issues.

这篇关于准备做一些困难的事情的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！