Microsoft Office Forums Creating a Form: Word or Excel?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-15-2012, 11:24 AM
adam.morin adam.morin is offline Creating a Form: Word or Excel? Windows XP Creating a Form: Word or Excel? Office 2003
Novice
Creating a Form: Word or Excel?
 
Join Date: Aug 2012
Posts: 2
adam.morin is on a distinguished road
Default Creating a Form: Word or Excel?


Hello all,

I need to make this form (pic.) into a semi-protected digital form (i.e. all the text you see on the form already needs to stay like that, the information needs to be filled in).

Would I be better off doing this in Word, Excel or maybe even Access?

If you could point me towards a more focused forum, that would be great.

Adam
Attached Images
File Type: jpg IMG-20120814-00007.jpg (52.4 KB, 13 views)
Reply With Quote
  #2  
Old 08-15-2012, 04:56 PM
Venky62 Venky62 is offline Creating a Form: Word or Excel? Windows 7 64bit Creating a Form: Word or Excel? Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

Depends on what you want to do with the data. If you want to store all the data in a database and then use that data later, then Access, or use Excel or Word as front-end and use Access as back-end.

Though experts can make any of the programs do what they want, one has to remember the primary purpose do each program:

Access: for storing large amounts of data and retrieving it as needed. It does not have great text formatting tools, and is definitely not meant for creating long documents.

Excel: for smaller amounts of data where calculations are important. Very easy to create fillable forms like you have uploaded, but not for large quantities of text. Also, has limited formatting tools

Word: essentially a word processor. Very useful for long docs and rich formatting. Can create fill able forms, but more tedious. Definitely not ideal for performing calculations. Cannot store data.

Based on the info you have given, I think you will find Excel or Access, or a combination of these two to be most convenient for your needs.
Reply With Quote
  #3  
Old 08-15-2012, 09:36 PM
macropod's Avatar
macropod macropod is offline Creating a Form: Word or Excel? Windows 7 64bit Creating a Form: Word or Excel? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,616
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Just to clarify, re Word:

Word is especially useful if the form is to be filled in by multiple users who don't have access to the PC on which the data might be stored or if you don't plan to add the data to a database or worksheet. In the latter scenario, PDF forms are equally useful and, given that most PC users have at least Adobe Acrobat Reader whereas they might not have Word, more widely accessible. Word forms are relatively easy to extract data from for loading into a database or worksheet.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 08-16-2012, 04:42 AM
adam.morin adam.morin is offline Creating a Form: Word or Excel? Windows XP Creating a Form: Word or Excel? Office 2003
Novice
Creating a Form: Word or Excel?
 
Join Date: Aug 2012
Posts: 2
adam.morin is on a distinguished road
Default

Thanks everyone, it actually helped a lot in clearing it up.

Basically I need it to input the information, and then print off the sheet. It doesn't need to store any of the data, so based on the descriptions I'm going to go with Word or a PDF. Everyone who would be using it does have access to Word, so that might be easiest.

Thanks again.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print word form using excel data sheet LS1015 Office 1 07-16-2012 08:16 PM
Creating a Form: Word or Excel? Creating a form jamiesword Word VBA 1 04-21-2011 02:24 PM
Creating custom tabs for Word & Excel 2003 on a Windows 7 OS Skarab Office 1 07-05-2010 09:23 AM
Word Fill-in form with Excel spreadsheet karik Word 0 01-11-2010 08:45 AM
Creating Formulas in a Word Form pittz2002 Word 0 08-25-2009 08:36 AM


All times are GMT -7. The time now is 10:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft