Beginner

[KGUY]

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!

 

[bhicks11 via AccessMonster.com]

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

 

[John W. Vinson]

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 here:

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


And you can download a properly structured, normalized survey database from
the esteemed Duane Hookum at:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Jeff Boyce]

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

 

[Piet Linden]

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...5c2?q="Keri+Hardwick"+Survey#afb0a9d0315245c2

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?"

 

[Steve]

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 (e-mail address removed).

Steve

 

[John... Visio MVP]

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 (e-mail address removed).

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)

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

 

[John... Visio MVP]

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

 

[Jeff Boyce]

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