Checking data in Access??

Question

ok, in excel i know there's a feature called FIND (Main menu ->Edit->find) which helps one locate words/features in the datasheet.
but my question is do we have such in MS Access? the point is that i have to work on a huge database and i contineously add new words there and sometimes i do add an already existing word there which is not acceptable.
or alternatively,how do i check (or control)if a word is already in existance in the database?

Answer 1

the same as in MS Access main menu > edit > find but you have to put your cursor in the column where you are looking for the word, or you can press Ctrl + F as a short key for the find window.

make sure that you select match case as Any Part of The Field

or use the binoculars icon if it is appeared in your window.

Answer 2

Yes,

Open the table.
Click the Edit menu then Find.
In the "Find What" textbox, type what you're looking for.
In the "Look In" dropdown, choose whether you want to look in the entire table or the current column (you want the entire table).
In the "Match" dropdown, choose "Any part of the field"

It will then match like Excel does.

Answer 3

all the data is held in tables, which in certain views look like excel spreadsheets, open a table use control f, just as in excel, but I havn;t used acces for about 5 years so maybe im wrong

Answer 4

In the TABLE DESIGN window, there is a way to NOT ALLOW DUPLICATES. If you set this to TRUE, then you won't be able to have duplicate words in the database.