Lesson 17: Excel Database EntryForm
NOTE: If Excel recognizes your set of data as a database you can sort the data
You don't need to do any VBA programming (macros) to create a form that allows you to enter/delete data in an Excel database.
In Excel 2007: Unfortunatly the form is not part of any ribbon in Excel 2007. You can add it to your Quick Access toolbar at the top of the screen.
- Right click on the toolbar
- Select "Customize.."
- Select "All Commands" in the upper text box
- Select "Form" from the lst on the left  and click add
It is now on your Quick Access toolbar
Once you have created a database in Excel, you can click anywhere in the database and go to the menu bar Data/Form (in Excel 2003 or the "Form" icon that you have added to your Quick Access toolbar in Excel 2007) and here comes the form to enter/delete/search/filter data. The fields wont be "Name, "Address" , "City" ...they will be what you have chosen as title in each column of YOUR database.
Instead of using the mouse to move from " Name" to " Address" , to " City" ....
use the TAB key.
There are five sections in this website
Section 1: About Databases: 4 Lessons
In this section we review the basic notions on databases and evaluate Excel as a database. You will then see how Excel can be used downstream from most centralized databases and data management programs. Finally we will discuss the "upgrade" from Excel to Access..
Section 2: Excel and External Data: 7 Lessons
There are many ways to get data into your Excel Workbooks and there are many ways to easily extract data from all the databases in your organization and the Internet. This section is centered on querying data
Section 3: Analyzing Data with Excel: 8 Lessons
Once you have the data in the right formats within your Excel workbook it is time to use the powerful analytical tools of Excel including the database functionalities (sort, filter, subtotals), the integrated calculator, the comparative analysis tools and the mysterious and not so complicated pivot tables.
Section 4: Reporting with Excel: 7 Lessons
The report is a communication tool and you can not accept to compromise on its presentation. Excel is the best reporting tool allowing you to easily develop popular dashboards and to share these reports with multiple colleagues.
Section 5: Other Functionalities in Excel: 3 Lessons
In this fifth section you will review the useful CTRL and ALT keystrokes, the conditional formatting, the drop-down lists and other interesting functionalities.
|
