Setting Up a Database in Excel 2010

with Dennis Taylor
please wait ...
Setting Up a Database in Excel 2010
Video duration: 0s 43m 27s Appropriate for all


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
Business IT


- [Voiceover] Hi, I'm Dennis Taylor, and I'm pleased to present Setting Up Tables, Lists, and Databases in Microsoft Excel. In this course, I'll show you the best techniques for structuring data efficiently, and coherently. We'll look at how to set up a form for when you need to view data on a record by record basis. We'll 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 the data will be entered more accurately, and with this powerful pick list technique, be entered much faster, as well.

Let's get started with Setting Up Tables, Lists, and Databases in Microsoft Excel.

please wait ...