创建搜索框，返回四个不同的响应 [英] Create Search Box that returns four different responses

问题描述

我有一个包含4个工作表的Excel数据库，每个工作表完全相同，所有41,364行（A = Zip，B = city，C = State，D = days，E = carrier）。任何工作表的唯一区别是Days（D）和Carrier（E）。每个邮政编码都在每个工作表中一次，或者我有一个工作表，其中包含所有四个工作表。我想创建一个程序/搜索框，以便我们办公室的人，在不同的计算机上，可以输入邮政编码，并显示四个不同的运营商信息（即输入29492到一个框中，点击输入和4方框填写邮政编码，城市名称（Cainhoy），州（SC），天和运营商名称）。我不希望他们必须打开数据库并进行搜索，我需要尽可能使用户友好。不确定这是否可行，或者Excel或Access是最好的。任何帮助都将不胜感激。

I have an Excel database with 4 worksheets, each worksheet is exactly the same, all 41,364 rows (A=Zip, B=city, C=State, D=days, E=carrier). The only difference in any of the worksheets is the Days(D) and Carrier(E). Each zip code is in each worksheet once, or I have a worksheet with all of the four worksheets combined. I want to create a program/search box so that the people in our office, on different computers, can type in a zip code and have the four different carriers'' information show up (i.e. type 29492 into a box, hit enter and 4 boxes fill with the zip code, city name(Cainhoy), State(SC), Days and Carrier name). I don''t want them to have to open the database and search it, I need to make it as user friendly as possible. Not sure if this is possible, or if Excel or Access is the best to do it in. Any help would be appreciated.

推荐答案

首先，Excel不是数据库应用。

其次，当你只需要一张床单或桌子时，我不明白为什么你有4张不同的床单。


你可以在Excel中做到这一点或访问。我更喜欢Access的灵活性和易维护性。但Excel对于这个非常简单的场景也是合理的，在Excel中，你可以使用Excel中包含的查找函数之一。


我不明白你的意思你不想打开数据库，因为无论你构建什么前端接口，在某些时候你需要打开一个数据连接，这样你就可以检索你正在寻找的信息。

First, Excel is not a database application.
Second, I don''t understand why you have 4 different sheets when you only need one sheet or table.

You can do this in either Excel or Access. I prefer Access for it''s flexibility and ease of maintenance. But Excel is plausible as well for this very simple scenario, in Excel, you can just use one of the lookup functions included in Excel.

I don''t understand what you mean by you don''t want to open the database because whatever front end interface you build, at some point you need to open a connection to the data so you can retrieve the information you''re looking for.

4个工作表，每个工作表完全相同，所有41,364行

4 worksheets, each worksheet is exactly the same,all 41,364 rows

然后你还有另一个包含所有这些数据的工作表......再次？


世界上你如何维护大约200,000行数据？


你应该请看：访问教程

我有四个工作表，因为信息来自四个来源（运营商）。我将所有信息合并到一个工作表中，对其进行操作和格式化，按邮政编码对其进行排序，它的工作原理与我想要的完全相同。我不想让他们打开数据库的意思是我想要一个首页。或类似的东西，以便当他们打开它时，他们唯一看到的是一个盒子，他们键入一个邮政编码，然后获取他们的信息。我假设Access是要走的路，我知道如何将Excel导入Access，我只是不知道如何创建我需要的搜索框功能，或者是否可能。

I have four worksheets because the information came from four sources(the carriers). I combined all the information into one worksheet, manipulated and formatted it, sorted it by zip code and it works exactly like I want it to. What I mean by not wanting them to open the database is that I want a "front page" or something like it so that when they open it, the only thing they see is a box where they type a zip code and then get their information. I assumed Access would be the way to go, I know how to import the Excel into Access, I just don''t know how to create the search box function that I need, or if it is possible.

这篇关于创建搜索框，返回四个不同的响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！