Setting Up a Database in Excel 2010
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.
Excel 2010 Essential Training5,756,965 Views
Excel 2013 Essential Training5,659,883 Views
Access 2010 Essential Training3,079,123 Views
PHP with MySQL Essential Training3,907,848 Views
Foundations of Programming: Fundamentals6,728,971 Views
Access 2013 Essential Training2,494,302 Views
Excel 2010: Pivot Tables in Depth1,309,159 Views
Excel 2010: Advanced Formulas and Functions968,662 Views