v

您的位置:VeryCD教育计算机


《Access 2010视频教程》(Trainsignal Access 2010 Training)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    主讲人Heather Ackmann
    发行日期2010年
    对白语言英语
    文字语言英文
  • 时间: 2010/12/26 14:15:57 发布 | 2010/12/26 14:40:30 更新
  • 分类: 教育  计算机 

life_is_good

精华资源: 6571

全部资源: 7301

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Access 2010视频教程
英文名Trainsignal Access 2010 Training
资源格式光盘镜像
学校Trainsignal
主讲人Heather Ackmann
发行日期2010年
地区美国
对白语言英语
文字语言英文
简介

IPB Image

语言:英语
网址:http://www.trainsignal.com/Access-2010-Training.aspx
类别:教程

Trainsignal出品的时长12小时的Access 2010视频教程。由Heather Ackmann主讲。本教程涵盖了如何创建和使用表,使用查询语句获取数据,利用函数和表达式进行计算,创建数据透视表(PivotTable)和数据透视图(PivotChart),以及生成报告等等。(文:life_is_good@YDY)

Learn How To Create and Use Forms, Utilize Queries to Retrieve Data, Perform Calculations Using Expressions and Functions, Create PivotCharts and PivotTables, Run Reports and Much More!

Frequently Asked Questions for Access 2010 Training

Can I Take This Access 2010 Training Course?
YES! Whether you’re a total beginner to database design or Access 2010, or even if you are self-taught, this course will fill in the gaps and provide you the most thorough Access 2010 training anywhere!
YES! If you are familiar with the other Office applications (i.e. Word and Excel) and have a basic understanding of data entry, this course will get you up to speed and make you a bonafide Access 2010 expert!


代码
Name: Access 2010 Training (DVD1)
Extracted size: 4.2GB
Compressed size (m1): 3.5GB
URL: http://www.trainsignal.com/Access-2010-Training.aspx
Description:
Learn How To Create and Use Forms, Utilize Queries to Retrieve Data,
Perform Calculations Using Expressions and Functions, Create PivotCharts
and PivotTables, Run Reports and Much More!
Plus, Discover the New Features of Access 2010!

Name: Access 2010 Training (DVD2)
Extracted size: 4.2GB
Compressed size (m1): 3.1GB
URL: http://www.trainsignal.com/Access-2010-Training.aspx
Description:
Learn How To Create and Use Forms, Utilize Queries to Retrieve Data,
Perform Calculations Using Expressions and Functions, Create PivotCharts
and PivotTables, Run Reports and Much More!
Plus, Discover the New Features of Access 2010!

Name: Access 2010 Training (Additional Content)
Extracted size: 4.2GB
Compressed size (m1): 3.5GB
URL: http://www.trainsignal.com/Access-2010-Training.aspx
Description:
Learn How To Create and Use Forms, Utilize Queries to Retrieve Data,
Perform Calculations Using Expressions and Functions, Create PivotCharts
and PivotTables, Run Reports and Much More!
Plus, Discover the New Features of Access 2010!
iPod video files to watch Train Signal on the go! - A popular request amongst
our students who wish to study while they commute (i.e. train, plane, bus).
These 320x240 M4V files are compressed versions of the original course, and
play on any iPod that supports video. Also great for reviewing "on the job."



目录

Lesson 01 - Getting Started with Access 2010 Training

* Introduction to the Course
* About the Instructor
* Tour of the Course

Lesson 02 - Lab Setup

* Access 2010 Database Specifications
* Minimum Requirements for Access 2010
* Exercise Files

Lesson 03 - Introduction to Databases and Normalization

* Introduction to Relational Databases
* Flat–File Databases
* Relational Databases
* Introduction to Normalization
* Normalization Example
* Denormalization
* Designing Database Guidelines
* Normalization Example
* Trivia Time

Lesson 04 - Overview of Microsoft Access 2010 Objects

* Database Objects
* Queries
* Forms
* Reports
* Macros
* Modules

Lesson 05 - Tour of Microsoft Access 2010

* Starting Microsoft Access 2010
* Creating a New File
* Creating a New Table
* Saving a Database
* Opening a Database
* Trusting a File
* The Quick Access Toolbar
* Backstage View
* Access Options Overview
* The Ribbon
* Contextual Tabs
* The Navigation Pane

Lesson 06 - Understanding Object Views

* Introduction to Microsoft Access Object Views
* Table Views
* Query Views
* Form Views
* Report Views

Lesson 07 - Navigating Microsoft Access 2010 Database Objects

* Navigating a Table of Query
* Keyboard Shortcuts
* Navigating a Form
* Navigating a Report

Lesson 08 - Creating Simple Forms

* Creating a Single Item Form
* Automatic Subdatasheet Creation
* Creating a Multiple Items Form
* Creating a Split Form
* The Form Wizard
* Creating a Navigation Form

Lesson 09 - Form Formatting Basics

* Introduction to Controls
* Resizing Controls
* Moving Controls
* Working with Layouts
* Adjusting the Tab Order
* Applying Themes

Lesson 10 - Introduction to Queries

* Kinds of Queries
* Creating a Select Query Using the Simple Query Wizard
* Creating a Select Query from Design View
* Working with Fields
* Sorting and Filtering Records

Lesson 11 - Finding Specific Data Using Criteria, Operators, and Wildcards

* Introduction to Criteria
* Introduction to Operators
* Adding Criteria to a Query
* Combining Criteria
* Adding Alternate Criteria
* Locating Blank Values (Nulls)
* Introduction to Wildcards

Lesson 12 - Creating Parameter Queries

* Introduction to Parameter Queries
* Creating a Parameter Query
* Changing the Parameter Prompt Order
* Using Wildcards and Functions with Parameter Queries

Lesson 13 - Understanding Joins

* Introduction to Joins
* Types of Joins
* Creating an Inner Join
* Creating an Outer Join
* Creating a Self–Join

Lesson 14 - Creating Calculated Expressions

* Introduction to Expressions
* Creating a Calculated Detail Field
* Building Expressions Using the Expression Builder
* Building Expressions in Forms and Reports

Lesson 15 - Summarizing Data

* Introduction to Aggregate Queries
* Calculating a Group of Query Records
* Calculating a Group of Query Records From Datasheet View
* Calculating a Group of Query Records From Design View
* Grouping with Criteria and Calculated Fields
* Pitfalls of Summarizing Data

Lesson 16 - Introduction to Built-in Functions

* Introduction to Functions
* Basic Date/Time Functions
* The Month Function
* The Year Function
* Text Functions
* The LCase and UCase Functions
* The Left and Right Functions
* The Trim Function
* The Format Function
* Conversion & Math Functions
* The FormatCurrency Function
* The CCur Function
* The Round Function

Lesson 17 - Advanced Functions

* Advanced Date/Time Functions
* The DatePart Function
* The DateAdd Function
* The DateDiff Function
* The Sum Function
* The Max & Min Function
* The DMax & DMin Functions
* The DLookup Function
* Handling Null Values & Program Flow
* The Nz Function
* The IIf Function
* The Switch Function
* Using Functions in Macros
* Nesting Functions

Lesson 18 - Creating PivotTables

* Introduction to PivotTables
* Creating a PivotTable
* Creating a Calculated Field
* Manipulating a PivotTable
* Exporting Data to Microsoft Excel

Lesson 19 - Creating PivotCharts

* Introduction to PivotCharts
* Creating a PivotChart
* Manipulating a PivotChart
* Changing Chart Types

Lesson 20 - Creating Reports

* Creating a Report Using the Report Tool
* Creating a Report Using the Report Wizard
* Creating a Report from Design View
* Creating Mailing Labels

Lesson 21 - Basic Report Formatting

* Formatting Basics
* Controls
* Control Layouts
* Sections and Grouping
* Adding Controls & Page Elements
* Labels
* Text Boxes
* Pictures
* Page Numbers
* Date/Time
* Borders & Rectangles

Lesson 22 - Advanced Report Formatting

* Advanced Format Properties
* Filtering Reports
* Conditional Formatting
* Creating Data Bars
* Adding a Chart

Lesson 23 - Printing and Exporting Reports

* Previewing a Report
* Printing a Report
* Exporting a Report

Lesson 24 - Next Steps

正在读取……

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

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

点击查看所有91网友评论

 

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

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