访问表单设计记录查找 [英] Access form design record look up

问题描述

我试图搜索已经存在的答案，但我缺乏适当的词汇量。


我使用的是Windows 8 - Access 2013

我需要将现有客户和新客户添加到活动中。

我正在寻找一种在表格中做到这一点的好方法。


添加新客户是轻而易举的。添加现有客户并不是那么容易，我不得不相信它应该是。


有人能指点我一个示例数据库吗？

解决方案

RockKandee：

你在问什么？

你想做什么？


如果您要求某人指出正确的模板或帮助您从头开始设计项目，那么这真的不是我们要做的事情......我们也不能从您提供的那么多。


如果您刚刚开始使用Access，那么您应该通过以下教程进行操作，以便加快速度。使用适当的术语和基础技能：

---

• MS Access 2010教程
• 访问基础 - 按水晶
• >数据库规范化和表结构。
• Access 2013的培训课程

---

不，我没有要求任何人提供帮助我从头设计或指向我可以使用的模板。我希望有人知道我能看到的一个例子，这有助于我理解。


我想找到最好的方法来创建我的数据输入表格，当我需要连接两张桌子的信息。


如：

表1 =活动+活动详情（时间，地点等）

表2 =客户+联系信息

我想将客户连接到一个活动。

我想通过拉一下活动并列出与会者来做到这一点并且如果需要，可以添加与会者。


目前我设置了一个搜索名称，以便为我提供客户ID，然后将其添加到活动中。我知道我可以自动添加（稍后将处理）。


我需要这种类型的连接，只需要我使用的2个示例表。对于我在表单上设置的每个搜索，它只需要搜索部分自己的查询。我认为必须有一种方法可以避免所有这些查询。我尝试使用SQL，但是我还没有足够的经验来完成这项工作。


所以我想我会问这样做的常用方法是什么。


我会仔细阅读你发布的教程，看看我是否能找到合适的语言来更好地提问我的问题。


谢谢你

RockKandee

很难从OP中找出你想要的东西。

实际上，一旦你通过工作第一个教程我认为你实际上会拥有你想要的工具！


这听起来非常像你正在准备表的规范化好东西！


在这种情况下，Comboboxes非常友好;但是，请远离表级别的查找字段，除非您要使用sharepoint（查找字段在表级别是CBO等效的。）


基本上，你要去进入数据库工具并设置一个表中的主键和链接表之间的关系...看看：

我有一个非常简单的数据库（信仰跟踪）： http://bytes.com/topic/access/answer...esign-question


你应该可以在这里下载：
http://bytes.com/attachments/attachm...ontracking.zip


请记住数据库是专为线程设计的，实际上并不打算成为日常使用......虽然它可以使用...需要一两个或两个来完成规范化和略微更好的形式。


你会想看看表格关系......一旦你通过教程，它会更有意义。

I have tried to search for answers that already exist, but I lack the proper vocabulary.

I am using Windows 8 - Access 2013

I need to add existing and new customers to events.

I am looking for a good way to do this in a form.

Adding new customers is a breeze. Adding existing customers is not so easy and I have to believe it should be.

Could someone point me to an example database?

解决方案

RockKandee:
What are you asking?
What is it you''re trying to do?

If you are asking someone to point you to the correct templates or help you design a project from scratch, then that''s really not what we''re here to do... nor could we from what little you''ve provided.

If you are just starting out with Access then you should work thru the following tutorials so as to "get to speed" with the proper terms and foundation skill set:
---

• MS Access 2010 Tutorials
• Access Basics - By Crystal
• > Database Normalization and Table Structures.
• Training courses for Access 2013

---

No I wasn''t asking anyone to help me design from scratch or point me to a template I could use. I was hoping someone knew of an example I could look at that would help me understand.

I am trying to find the best way to to create my forms for data entry when I need to connect info from 2 tables together.

Such as:
Table 1 = Event + Event details (time, location, etc)
Table 2 = Customers + contact info
I want to connect a customer to an event.
I want to do it by pulling up the event once and listing the attendees and be able to add attendees as/if needed.

Currently I have a search name set up to give me the customer ID and then I add this to the event. I know I can automate the addition (will deal with that later).

I need this type of connection with more that just the 2 example tables I used. For every search I set up on a form, it requires its own query just for the search part. I think there has to exist a way to avoid making all of these queries. I tried to use SQL but I don''t have enough experience yet to make this work.

So I thought I would ask what a common way of doing this is.

I will read through the tutorials you posted and see if I can find the proper language to use to ask my question in a better way.

Thank You

RockKandee
It was really difficult to figure out what you wanted from the OP.
Actually, once you work thru the first tutorial I think you will actually have the tools you need to do what you want!

And it sounds very much like you''re on the way to having the tables normalized which is a good thing!

Comboboxes are quite friendly in this case; however, Stay away from lookup fields at the table level unless you are going to use sharepoint (lookup fields are CBO equivalent at the table level).

Basically, you''re going to go into databasetools and setup relationships between the primary key in one table and a linking table... take a look at :

I''ve a very simple database (faithformationtracking) at: http://bytes.com/topic/access/answer...esign-question

You should be able to download here:
http://bytes.com/attachments/attachm...ontracking.zip

Keep in mind that the database was designed for the thread and isn''t actually intended to be a day to day use... although it would be serviceable... needs a tweek or two to finish normalizing and a slightly better form.

You''ll want to look at the table relationships... once you get thru the tutorials it will make much more sense.

这篇关于访问表单设计记录查找的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！