how to find a data in a database

[Guest]

how i can search a data from database containing all tables.

i have four querys each query have one date filed. if i serach a record in
a particular date. i want to open all the query records on the paricular date

eg :- i have some transactions in 10/10/2006 in all tables
if i search date , i want to ope the all the transactions from the
particular date in all tables
..please help me to solve this problem

 

[Guest]

Hi Rajeev,

The solution to this problem is to normalize your database. Your tranactions
should be in one table only (okay, perhaps two if you have a dedicated
archive table). However, if you have separate tables for, say, 2004, 2005,
2006, 2007, etc., then you definately have a database that is not properly
normalized. If that is the case, you can, in the interim, create a Union
query to assist in searching a date field in several tables. Here is a
tutorial on creating union queries:

http://home.comcast.net/~tutorme2/samples/unionqueries.zip


You should spend some time gaining an understanding of database design and
normalization before attempting to build something in Access (or any RDBMS
software for that matter). Here are some links to get you started. Don't
underestimate the importance of gaining a good understanding of database
design. Brew a good pot of tea or coffee and enjoy reading!

http://www.seattleaccess.org/
(See the last download titled "Understanding Normalization" in the
Meeting Downloads page)

<Begin Quote (from page 23 of document)>
"The most important point for you to remember is that you will always
re-introduce data integrity problems when you de-Normalize your structures!
This means that it becomes incumbent upon you or the user to deal with this
issue. Either way, it imposes an unnecessary burden upon the both of you.
De-Normalization is one issue that you'll have to weigh and decide for
yourself whether the perceived benefits are worth the extra effort it will
take to maintain the database properly."
<End Quote>

This web page includes links to lots of database design papers:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

Also recommended: Find the copy of Northwind.mdb that is probably already
installed on your hard drive. Study the relationships between the various
tables (Tools > Relationships...)


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[aaron.kempf]

fully agree; if you ever want to 'seach all your fields at once' then
you need to do more normalization

-Aaron