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
Download File Size:125.46 MB