<< WIN Lynda.com - Setting Up a Database in Excel
Lynda.com - Setting Up a Database in Excel
This spotter is already whitelisted
Category Applications
PlatformWindows
GenreEducational
GenreOffice
GenreSystem software
Date 1 decade, 3 years
Size 123.88 MB
 
Website http://www.lynda.com/Excel-2007-tutorials/Setting-Up-a-Database-in-Excel/89046-2.html
 
Sender Sluwesjaak (1z0ZfQ)            
Tag
 
Searchengine Search
NZB NZB
 
Number of spamreports

Post Description

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. Exercise files are included with the course.
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

Comments # 0