Setting Up a Database in Excel 2010
Setting Up a Database in Excel 2010
MP4 | Video: 540p | Duration: 43:23 | English | Subtitles: VTT | 93.6 MB
MP4 | Video: 540p | Duration: 43:23 | English | Subtitles: VTT | 93.6 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.
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