Excel建立数据库视频教程 Setting Up a Database in Excel [光盘镜像]

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Excel建立数据库视频教程 英文名: Setting Up a Database in Excel 资源格式: 光盘镜像 发行日期: 2011年 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

语言：英语 网址：http://www.lynda.com/Excel-2007-tutorials/Setting-Up-a-Database-in-Excel/89046-2.html 类别：教程 （xuehui@TLF） Lynda.com 出品的时长43分钟的在Excel中建立一个数据库视频教程。由Dennis Taylor演示了怎样使用Excel创建一个简单的数据库。讲解Excel数据管理工具的限制，创建一个数据库所需设计考虑的问题。以及使用列表简化数据库的建立，利用表单和数据验证工具来管理数据等。本教程附带练习文件。 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 下载链接来自TLF 未经过安装测试与安全检测，使用者后果自负与本论坛无关 软体版权归原作者及其公司所有，如果你喜欢，请购买正版 目录: Introduction Welcome 00m 45s Using the exercise files 00m 35s 08m 20s 1. Database Design Concerns Understanding design concepts for setting up large lists 05m 56s Creating appropriate name, address, and time fields 02m 24s 14m 54s 2. Tables Using Excel tables for database data 03m 40s Using the Ribbon Design tab to control table formatting 03m 53s Expanding tables automatically and adding totals 04m 10s Working with formulas in tables 03m 11s 18m 20s 3. Controlling the Creation of New Data Building and viewing data with the Form tool 07m 21s Restricting data entries with data validation 08m 42s Using the data validation tools to check the validity of existing data 02m 17s 00m 33s Conclusion Next steps 00m 33s 代码 . \ . –:–––\\–––––––––––––––––––––––––––/\–––––:– : \ : . : : \ . : \\ : _ __/\__ _______:___ ________\ __/\__ _______:__ \\____// . / | \ \____/ /ˆ . / ________._ ______/ : /–––––––| _ \ _______/ _ :/ /ˆ | ./ / _, / _, | \ \/ˆ / /_____.___/ _, |. // / \ \ / | \ \ /______ / / || –/–––––/_____/\ \––––––'––––––\______\–––' / '____._/–––––––––––'–/– –:–––––––––––/\\___.___\\–––– – _._________._ –//______//––:–––––––––––––––:– : _ ___ _ ___ _ :__ _ ___ _\ /_ ___ _ ___ : ___ _ ___ _ : –|__\___\__\___\__\:__\__\___\_\__ iRONiSO __/_/___/__/___/:_/___/__/___/__|– : `–––––––––––/––\__._.__/––\–––––––––––––' : \\ \ TiTLE: Lynda.com.Setting.Up.a.Database.in.Excel–iRONiSO TYPE : BOOKWARE CRACKER : iRONiSO FiLE : 8 X 15MB PACKAGER : iRONiSO TOTAL : CD SUPPLiER : iRONiSO PLATFORM : WINDOWS FORMAT : Bin/Cue RLS DATE : 2011.10.26 PROTECTiON : NONE . . . _ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _ \__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/ : `––/––\__._.__/––\––' : Course Outline 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 . . . _ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _ \__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/ : `––/––\__._.__/––\––' : For Additional info http://www.lynda.com/Excel–2007–tutorials/Setting–Up–a–Database–in–Excel/89046–2 _ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _ \__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/ : `––/––\__._.__/––\––' : GROUP NEWS Web access Training Libraries / Education video's Online Training Library Access Anything if u think can be helpful in e–Learning Exclusive team dump on 100 Mbit with 500 GB disk _ _ ___ _ ___ _ :__ _ ___ __._ _/'\_ _.__ ___ _ ___ : ___ _ ___ _ _ \__\___\__\___\__\:__\__\___\_\___\\___//___/_/___/__/___/:_/___/__/___/__/ : `––/––\__._.__/––\––' : NOTICE You Like The Release Please Purchase As It Is Required For All As It Got Lot Of Balls To Make It Online For People Like You And Me As They Deserves The Best. :) . . _._________._ . . : _ ___ _ ___ _ :_ _____ __ _\ /_ __ _____ __ : ___ _ ___ _ : –|__\___\__\___\__\__\\__ \\ \\__ iRONiSO __// // __//__/__/___/__/___/__|– : : – ––\_// /––\__._.__/––\ \\_/–– – : : . –zfr– \ : \_/ \_/ : / 2o! . `––––––––––––––\\–:– – – –:–//––––––––––––' \ : Contact Information :/ : wearenowhere@hush.ai : . /: .