中文名: 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 :/
: [email protected] :
. /:
.