Start learning with our library of video tutorials taught by experts. Get started
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.
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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.