v

您的位置:VeryCD教育计算机


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

  • 状态: 精华资源
  • 摘要:
    发行日期2011年
    对白语言英语
    文字语言英文
  • 时间: 2011/10/31 20:07:57 发布 | 2011/11/02 14:50:29 更新
  • 分类: 教育  计算机 

MTina

精华资源: 3862

全部资源: 3863

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Excel建立数据库视频教程
英文名Setting Up a Database in Excel
资源格式光盘镜像
发行日期2011年
地区美国
对白语言英语
文字语言英文
简介

IPB Image

语言:英语
网址: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 :
. /:
.

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有50网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。