Setting Up a Database in Excel 2010
Video: WelcomeSpells out the design considerations and tools needed for creating a database in Excel.
- Next steps
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.
- 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
Hi! I am Dennis Taylor and I am pleased to present Setting Up Tables, Lists and Databases in Microsoft Excel. In this course I'll show the best techniques for structuring data efficiently and coherently. We'll look at how to a setup a form for when you need to view data on a record by record basis or show you how to display your data as a table to provide structure and tools for more efficient layout. And we'll also show you the powerful data validation command to ensure that data will be entered more accurately and with its powerful pick list technique.
It will be entered much faster as well. Let's get started with Setting Up Tables, Lists and Databases in Microsoft Excel.
There are currently no FAQs about Setting Up a Database in Excel 2010.