Excel 2003.novice user wants to set up database for research
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 13, 2008 10:23 AM
UPDATED:
August 14, 2008 6:20 PM
Answer Wiki:
Excel is a spreadsheet program, though you can set up a datbase using it, here is a site
<a href="http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm">http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm</a>
that will explain how that is done.
You might be better off using Access (another componant of the MS office suite) there are training videos here:
<a href="http://office.microsoft.com/en-us/training/CR061829401033.aspx">http://office.microsoft.com/en-us/training/CR061829401033.aspx</a>
That you might find helpful.
To see all answers submitted to the Answer Wiki: View Answer History.
Are you familiar with macros or VB Script at all?