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
|
|||
|
|||
Beginner
I have never used Access before. I have an employee survery that was created
in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! |
#2
|
|||
|
|||
Beginner
You can begin by importing the table into Access. You may need to adjust or
modify some of the import results but you agree/disagree fields would be yes/no field type. When you design a form and place the fields on the form they will be check boxes. Bonnie http://www.dataplus-svc.com KGUY wrote: I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200905/1 |
#3
|
|||
|
|||
Beginner
On Mon, 4 May 2009 18:50:01 -0700, KGUY
wrote: I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! Access and Excel are VERY different programs. A table datasheet looks (deceptively!) like a spreadsheet, but the entire conceptual basis for the programs are different. You'll have nothing but frustration if you try to apply Excel principles to Access tables. You can get started with some of the resources and tutorials he Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...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 And you can download a properly structured, normalized survey database from the esteemed Duane Hookum at: http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000' -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Beginner
John's response offers excellent advice and direction.
I'll add my observations ... Access is NOT like Word or Excel. Most folks deal with words and numbers on a daily basis, and have some familiarity with the related concepts. Most (normal) folks don't deal with relational databases on a daily basis, and don't have any familiarity with the precepts of normalization. Access is NOT a "bookcase", like Word or Excel (folks know how to use a "bookcase") -- Access is a power saw. You use it to BUILD a bookcase. I see four areas a "beginner" needs to spend time on: 1) relational design/normalization (put data in the form Access expects) 2) Acces tricks (how Access does things) 3) user interface (if you don't make it easy to use, it won't get used) 4) development (if you've never built a bookcase before, where do you start, and how do you do it?) Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "KGUY" wrote in message ... I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! |
#5
|
|||
|
|||
Beginner
Keri Hardwick posted an interesting article on the subject a long time
ago... which Duane implemented in At Your Survey (or so it seems). Basically, she points out that building your survey incorrectly is going to make it VERY difficult to summarize. Read this thread: http://groups.google.com/group/comp....b0a9d0315245c2 After that, I would probably download At Your Survey, from the link that John provided. Then at least you'll be going in the right direction. And starting right in this case is important... I spent a few months working on a database that was not set up right, and I always wondered "What does Null (no answer) mean?" |
#6
|
|||
|
|||
Beginner
Your last four words express a real sense of urgency. If so, I can convert
your Excel employee survet to an Access employee survey for you for a modest fee. I provide help with Access, Excel and Word applications for a reasonable fee. If you would like my help, email me at . Steve "KGUY" wrote in message ... I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! |
#7
|
|||
|
|||
Beginner - Stevie still thinks he is an ASSet
"Steve" wrote in message
... Your last four words express a real sense of urgency. If so, I can convert your Excel employee survet to an Access employee survey for you for a modest fee. I provide help with Access, Excel and Word applications for a reasonable fee. If you would like my help, email me at . Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. A few gems gleaned from the Word New User newsgroup over the Christmas holidays to show Stevie's "expertise" in Word. Dec 17, 2008 7:47 pm Word 2007 .......... In older versions of Word you could highlght some text then go to Format - Change Case and change the case of the hoghloghted text. Is this still available in Word 2007? Where? Thanks! Steve Dec 22, 2008 8:22 pm I am designing a series of paystubs for a client. I start in landscape and draw a table then add columns and rows to setup labels and their corresponding value. This all works fine. After a landscape version is completed, I next need to design a portrait version. Rather than strating from scratch, I'd like to be able to cut and paste from the landscape version and design the portrait version. Steve Dec 24, 2008, 1:12 PM How do you protect the document for filling in forms? Steve One of my favourites: Dec 30, 2008 8:07 PM - a reply to stevie (The original poster asked how to sort a list and stevie offered to create the OP an Access database) Steve wrote: Yes, you are right but a database is the correct tool to use not a spreadsheet. Not at all. If it's just a simple list then a spreadsheet is perfectly adequate... John... Visio MVP |
#8
|
|||
|
|||
Beginner
Last FOUR words? So "Access" is a sign of desperation? I guess with your
help, it would be. So even after admitting you are not a resource, you pretend to know something about Access, Excel and Word. So why are you not pestering posters in those newsgroups? Why are you not flogging your wares on UtterAccess or CDMA. Is it possible that you would be out of your depth and they may be less tolerant of your behaviour? John... Visio MVP "Steve" wrote in message ... Your last four words express a real sense of urgency. If so, I can convert your Excel employee survet to an Access employee survey for you for a modest fee. I provide help with Access, Excel and Word applications for a reasonable fee. If you would like my help, email me at . Steve "KGUY" wrote in message ... I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! |
#9
|
|||
|
|||
Beginner
"Steve" schreef in bericht ... Your last four words express a real sense of urgency. If so, I can convert your Excel employee survet to an Access employee survey for you for a modest fee. I provide help with Access, Excel and Word applications for a reasonable fee. If you would like my help, email me at . Steve Well of course the 'advertising machine' sees an opportunity to 'help' here... I very much doubt if you are *really* capable of helping here but anyway... OP please look at http://home.tiscali.nl/arracom/whoissteve.html Regards, ArnoR |
#10
|
|||
|
|||
Beginner
Despite Steve's blatant disregard for newsgroup etiquette, he does offer a
reminder that there's more than one way to get help. These newsgroups are "staffed" by volunteers. If your need is severe and immediate, plan to hire someone rather than spend the considerable time/effort to come up to speed in all four of the areas my previous post mentioned. Just also be sure to take the time to 'vet' the person/firm you hire... Regards Jeff Boyce Microsoft Office/Access MVP "KGUY" wrote in message ... I have never used Access before. I have an employee survery that was created in Microsoft Excel that has multiple agree and disagree questions. How can I create this same survey in ACCESS. PLEASE HELP ME! |
Thread Tools | |
Display Modes | |
|
|