A database is a collection of information, and when setting up a database, you need to setup the restrictions and structure to collect the data the way you need it. You may need to limit the amount of characters that can be entered into a field, allow or disallow duplicate entries, require certain fields to contain data and so on…
Excel isn’t considered the first choice when creating a database and storing hundreds of thousands of records, but it can be a useful tool when you need to create a form that you can quickly fill out to store information in a structured manner.
Whether your storing a list of phone numbers and contacts, weekly payroll records for employees, a list of your stamp collection or coin collection, excel is a good choice that will provide you with a structured way to store and see the information.
Excel Database Builder:
With the Excel Database Builder, You can setup custom formulas so certain fields can automatically be filled in for you.
Posting entries into the database has been made simple with auto-posting. Just tab through the entry screen, fill in your fields and when you reach the end of the fields, your entry will automatically post. This can also be turned off and you can manually click a button to submit your entry.
Have a list in another excel spreadsheet that you need to link to for information? You can link to that list or just copy the page to a new sheet in the Excel Database Builder, and you can easily make a drop down list or VLookup so that information can be used in your database.
-Requires Excel 2010 or Newer
-Requires macros to be enabled