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
- [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.
Creating Long Documents with InDesign279,657 Views
Lightroom 5: 02 Optimizing Your Photos120,047 Views
WordPress and Genesis DIY: Showcasing Photography40,479 Views
Bert Monroy: Dreamscapes - Castle on the Mountain9,420 Views
Excel 2010 Essential Training5,995,580 Views
Excel 2013 Essential Training6,242,092 Views
Access 2010 Essential Training3,169,170 Views
PHP with MySQL Essential Training4,259,922 Views
Foundations of Programming: Fundamentals7,707,894 Views