If you ever need to keep track of a large quantity of information one option is to create a database file in a spreadsheet program like Excel. Whether it’s a contact list for an organization, an inventory of parts, or a library catalog of books or DVD’s, Excel has the tools to make the job simple and straightforward.
These database tools can make it easier for you to sort and search through your data to find the specific information you need.
To help you started, read the Excel 2007 Step by Step Database Tutorial. The tutorial covers fields and rows of data, creating tables, and using Excel’s sorting and data filtering tools.
Related Articles
These database tools can make it easier for you to sort and search through your data to find the specific information you need.
To help you started, read the Excel 2007 Step by Step Database Tutorial. The tutorial covers fields and rows of data, creating tables, and using Excel’s sorting and data filtering tools.
Related Articles
nice tutorial site. important tutorial
Hi. I have found this site very helpful but I was wondering if there is a way to setup a database that is dynamic. For example,If I wanted to record the temperature and rainfall everyday, twice a day, and input this into a database from which I could then extract the data and compose curves etc. on a weekly/monthly/annual basis. Can one create this more complex type of database using Access and Excel? Thank you