Lynda.com Setting Up a Database in Excel-iRONiSO | ISO | 105 MB
In this course, author Dennis Taylor shows how to use Excel for creating a simple database. The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Exercise files are included with the course.
Topics include: *Understanding database design concepts *Using the Text to Columns feature *Creating fields *Using tables *Adding total fields *Formatting tables with the Design tab *Using the Form tool to build and view data *Using data validation to restrict data entries