Database Search

[How Do I Search]

Once I have set up the database, how do I set up a search to search the
database for information stored?

 

[Jerry Whittle]

Setting up the database properly is the most important part. You should have
every piece of information in it's own column/field. For example you have a
table of employees. There should be a LastName field. Therefore you can
search by the last name of an employee in just that table within that field.
What you don't want is a Name field where there is something like "John
Smith" as it's hard to parse out just the last name. You also don't want a
table for different kinds of employees such as a Management table and a
WorkerBee table. You would have to search in more than one table to find
Smith (plus the ugly problem when Smith gets promoted into Management). You
certainly don't want more than one LastName field in a table OR something
bizzare like a table for each year.

Once you have the tables set up, you can click on the field in a table, or
better yet a field on a form, and use the Find (or Ctrl + f) to look up the
data. This has some drawback if there are tens of thousands of records. If
that happens you can create a parameter query to look up all the Smiths
faster or even John and Smith with two parameters.

 

[Jeff Boyce]

"How" depends on "what". What data structure do you have set up?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

On Mon, 6 Apr 2009 10:39:01 -0700, How Do I Search <How Do I

Once I have set up the database, how do I set up a search to search the
database for information stored?

By creating appropriate Queries (and usually basing a form and/or report on
the queries).

For a more detailed answer post a more detailed question; or see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Tom Wickerath]

Perhaps this sample will be useful to you:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip

More advanced forms of QBF, where one is creating the WHERE clause of a SQL
statement in VBA code, can be found here:

http://www.accessmvp.com/TWickerath/downloads/elements.zip

http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________