Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 AM.


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