苦苦挣扎在Access窗体中创建此Excel工作表的版本 [英] Struggling creating a version of this Excel sheet in Access form

问题描述

嗨



我正在尝试在Access中创建一个与附加文档中显示的电子表格相同的表单


我最初的问题是我不知道如何将所有项目编号放入交叉表查询 - 每个项目都是表格中的一个字段


从我的内容可以看到交叉表查询最多有三个字段可以用作行标题，而我有19个!!


一个简单的查询将显示用Quarters转换为行的数据作为列的项目，但我希望Access可以这样做，因为它显示在附件中


是否可能，如果是这样的技术是什么？

我还希望根据患者ID字段更改数据


感激不尽的任何建议



谢谢

附加文件

HoNOS PrintScreen.doc （315.0 KB，122 views）

解决方案

Hargo，


我的第一个也是最好的建议是规范你的数据（见这里数据库规范化）。你的项目应该都在同一个领域，而不是单独的领域。


一旦你这样做，你会发现创建你的交叉标签查询将是一个快速！


构建图表和图形将是另一个故事，但同样的原则将适用于Excel中存在的Access。您可以使用相同的Cross选项卡查询。


我希望这能让您指向正确的方向。我们会根据需要提供进一步的帮助。

谢谢twinnyfo


我怀疑这可能是问题，但无法理解我的意思记录每个患者每个项目的季度分数


这些项目是个人评估，得分为五分，总分为


每位患者在入院时都会接受评估，然后每季度进行一次评估


显然，我无法想到这张桌子的主键


我读了标准化的东西（再次），虽然我得到了要点，但我仍然无法想象如何将''one-field''Items表链接到患者身上。我假设需要第3个表（也许称为评估），但仍然无法在脑海中看到所有内容如何链接到项目中的一个字段 - 例如，项目的主键是什么？


认为我的基本技能已经碰壁了!!哈哈

Hargo，


你的桌子在填充时会喜欢什么的基础知识，而不是宽的表格。桌子，你有一个高的一个。


根据您提供的数据，您的表格将包含以下字段：

展开 | 选择 | Wrap | 行号

Hi


I am trying to create a form in Access that does the same as the spreadsheet shown in the attached doc

My initial problem is that I don''t know how to get all the Item Numbers into a cross tab query - each item is a field in a table

From what I can see cross tab queries have a maximum of three fields that can be used as row headings whereas I have 19!!

A simple query would show the data transposed with Quarters as rows and the Items as columns but I was hoping Access could do this as it is shown in the attachment

Is it possible and if so what''s the technique?

I would also want the data to change depending upon the Patient ID Field

Any suggestions gratefully received


Thanks

Attached Files

HoNOS PrintScreen.doc (315.0 KB, 122 views)

解决方案

Hargo,

My first and best piece of advice would be to Normalize your data (see here Database Normalization). Your Items should all be in the same field, rather than separate fields.

Once you do this, you will find that creating your Cross Tab Query will be a snap!

Building the charts and graphs will be another story, but the same priniciple will apply in Access that exists for Excel. You can probably use the same Cross tab Query.

I hope this gets you pointed in the right direction. We''ll stand by for further assistance as needed.

Thanks twinnyfo

I suspected that might be the issue but cannot grasp how I would record quarterly scores for each of the items for each of the patients

The items are individual assessments which are scored out of five leading to an overall score

Each patient has an assessment upon admission and then quarterly after that

It''s obviously pertinent that I couldn''t think of a primary key for this table

I read the normalization stuff (Again) and whilst I get the gist, I still cannot envisage how to link the ''one-field'' Items table to the patient. I assume a 3rd table (Perhaps called assessments) would be needed but still cannot see in my mind how everything links to one field in Items - what would be the primary key of Items for instance?

Think my basic skills have hit a wall!! haha

Hargo,

The basics of what your table would loo like when populated is that rather than having a "wide" table, you have a "tall" one.

Based on the data you''ve provided, your Table would have the following fields:

Expand|Select|Wrap|Line Numbers

这篇关于苦苦挣扎在Access窗体中创建此Excel工作表的版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！