Course Outline


Description


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




For Additional info

http://www.lynda.com/Excel-2007-tutorials/Setting-Up-a-Database-in-Excel/89046-2

Download File Size:124.68 MB

---