If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Reference Database
Hi. I am working on building a database in Access 2002 that will be sort of
an encyclopedia of FAQs and their responses. I am not sure where to start - what I should build first? I have already started putting the information into a table, but I know I can always copy and paste it if I need to make changes or put it into a new database I will build. My first question is what is the best way to enter data, 3 fields of which will be in Memo form, because the questions and/or answers can get very lengthy?? Should I enter into a form or table? Next is what is the best way to set up a "Search" engine to search for key words. Like I said, this will be used as a reference for future questions asked, in hopes that we can eliminate some steps by seeing if the question has been asked before and what the response was. Sorry if I rambled. I would really like some assistance here. Can't seem to find a template to go from, as there are no templates for Access 2002 anyway. I will need specific instructions, as I am still learning. Thank you for all you do! Erika |
#2
|
|||
|
|||
Access Reference Database
Thank you for the response. I will start with that.
To answer your question, the memo field will be: 1. Suggestion/Question (some of these are actually suggestions) 2. Relevant Background 3. Proposed Company Response "KARL DEWEY" wrote: My first question is what is the best way to enter data, 3 fields of which will be in Memo form, because the questions and/or answers can get very lengthy?? Should I enter into a form or table? Always use a form and not directly enter data into a table. What is the third memo field for? Question, answer, and what? Next is what is the best way to set up a "Search" engine to search for key words. Use this as criteria and in design view of the query put it on a separate row for the question and answer fields --- Like "*" & [Enter search] & "*" Type it on the first criteria row and then copy and paste in the second to make sure it is identical so it will only prompt once. -- KARL DEWEY Build a little - Test a little |
#3
|
|||
|
|||
Access Reference Database
Is there a website where I can view templates/instructions on building a
database such as this? I would like to see what the design of the main form looks like. I do better if I have samples of other databases, and my computer will not allow me to download any of the templates Microsoft has online because I have Access 2002 on my pc here at work. "Erika M." wrote: Thank you for the response. I will start with that. To answer your question, the memo field will be: 1. Suggestion/Question (some of these are actually suggestions) 2. Relevant Background 3. Proposed Company Response "KARL DEWEY" wrote: My first question is what is the best way to enter data, 3 fields of which will be in Memo form, because the questions and/or answers can get very lengthy?? Should I enter into a form or table? Always use a form and not directly enter data into a table. What is the third memo field for? Question, answer, and what? Next is what is the best way to set up a "Search" engine to search for key words. Use this as criteria and in design view of the query put it on a separate row for the question and answer fields --- Like "*" & [Enter search] & "*" Type it on the first criteria row and then copy and paste in the second to make sure it is identical so it will only prompt once. -- KARL DEWEY Build a little - Test a little |
#4
|
|||
|
|||
Access Reference Database
My first question is what is the best way to enter data, 3 fields of which
will be in Memo form, because the questions and/or answers can get very lengthy?? Should I enter into a form or table? Always use a form and not directly enter data into a table. What is the third memo field for? Question, answer, and what? Next is what is the best way to set up a "Search" engine to search for key words. Use this as criteria and in design view of the query put it on a separate row for the question and answer fields --- Like "*" & [Enter search] & "*" Type it on the first criteria row and then copy and paste in the second to make sure it is identical so it will only prompt once. -- KARL DEWEY Build a little - Test a little |
#5
|
|||
|
|||
Access Reference Database
Erika M. wrote:
Is there a website where I can view templates/instructions on building a database such as this? I would like to see what the design of the main form looks like. I do better if I have samples of other databases, and my computer will not allow me to download any of the templates Microsoft has online because I have Access 2002 on my pc here at work. Newsgroup Answers MDB - I designed the MDB to assist frequent newsgroup answerers, such as MVPs, in quickly locating and pasting in their favourite snippets of answers. http://www.granite.ab.ca/access/newsgroupanswersmdb.htm Now this has one major flaw in that it doesn't support doing AND/OR searching. Just LIKE searching. But that was all I required for my purposes. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
Thread Tools | |
Display Modes | |
|
|