v

您的位置:VeryCD教育计算机


《巧学Access 2007视频教程》(Lynda.com Access 2007 Tutorials Power Shortcuts)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2011年
    对白语言英语
    文字语言英文
  • 时间: 2011/02/18 21:03:10 发布 | 2011/02/19 13:19:50 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

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

IPB Image

资源简介

Lynda.com 出品的时长3小时25分的 Access 2007的使用捷径 视频教程。由Alicia Katz Pollock分享数以百计个技巧和捷径来提高Access 2007的最大工作效率。内容包括Ribbon功能区和快捷工具栏的使用,管理文件,自定义和自动化数据库,数据快速输入和编辑,工作中的列表,查询,窗体和报表,以及数据库管理等等。本教程附带练习文件。

简介摘自 xuehui@TLF


1. Top Tips
Customizing the Navigation pane
Toggling between Design and Data views
Creating new fields with field templates
Understanding the "Cannot contain a Null value" error
Working with AutoNumbers as foreign keys
Using input masks
Four ways to add fields to a query
Four ways to filter data
Selecting multiple form and report controls
Aligning and distributing controls on forms and reports

2. File Management
Opening recent files
Opening your most recently used file automatically
Selecting a startup form
Changing the default saving location

3. Ribbon and Quick Access Toolbar Tips
Expanding and collapsing the Ribbon
Three ways to customize the Quick Access toolbar
Selecting Ribbon buttons using KeyTips

4. Interface Shortcuts
Turning the Navigation pane into a switchboard
Right-clicking
Using keyboard shortcuts

5. Navigation Shortcuts
Navigating between records
Using Search, Go to, and Find
Selecting fields, rows, columns, and tables

6. Data Entry and Editing Shortcuts
Undo and Redo tips
Entering data across, not down
Repeating data from the record above
Inserting today's date
Removing automatic hyperlinks
Using AutoCorrect
Using concatenated fields
Linking Outlook contacts
Saving imports and exports for reuse

7. Table Techniques
Creating a table using table templates
Setting data types
Understanding number field sizes
Setting default field types
Using validation rules
Using flag fields
Using an index
Using a datasheet Totals row
Filtering by selection
Resizing columns and rows
Removing gridlines and shading from tables
Hiding and unhiding table fields
Freezing fields when scrolling
Analyzing your table for redundant structure

8. Relationship Techniques
Setting a starting AutoNumber
Creating a multi-field primary key
Using subdatasheets
Using relationship reports

9. Query Techniques
Using wildcards
Using IN instead of OR
Hiding query fields
Changing captions
Finding duplicate records
Moving records with append and delete queries
Using make-table queries
Creating an update query
Turning a query into a PivotTable
Turning a query into a PivotChart
Using SQL statements

10. Form Techniques
Using the property sheet to work with controls
Creating option groups
Using a ComboBox to select a record
Creating tabbed form layouts
Inserting charts
Creating your own smart tags
Using the CanGrow and CanShrink properties
Hiding fields in printouts
Setting tab stops
Clipping, stretching, and zooming images
Viewing single or continuous forms
Changing a form's default view

11. Report Techniques
Inserting page breaks in reports and forms
Creating headers and footers
Hiding duplicates in reports

12. Formatting Shortcuts
Using the Format Painter
Setting default appearance for new databases

13. Macro and Event Techniques
Using a Before Change macro to create a time stamp
Triggering a Before Delete warning message
Creating a user interface macro
Using AutoExec macros

14. Database Management Techniques
Exporting to PDF
Compacting and repairing a database
Locking files

Conclusion
Goodbye



目录

代码
/$$ /$$$$$$$ /$$$$$$ /$$ /$$ /$$ /$$$$$$ /$$$$$$
|__/| $$ $$ /$$ $$| $$$ | $$|__/ /$$__ $$ /$$__ $$
/$$| $$ \ $$| $$ \ $$| $$$$| $$ /$$| $$ \__/| $$ \ $$
| $$| $$$$$$$/| $$ | $$| $$ $$ $$| $$| $$$$$$ | $$ | $$
| $$| $$__ $$| $$ | $$| $$ $$$$| $$ \____ $$| $$ | $$
| $$| $$ \ $$| $$ | $$| $$\ $$$| $$ /$$ \ $$| $$ | $$
| $$| $$**| $$| $$$$$$/| $$ \ $$| $$|**$$$$$$/| $$$$$$/
|**/|*****|**/ \******/ |**/ \**/|**/ \******/ \******/

TiTLE: Lynda.com.Access.2007.Tutorials.Power.Shortcuts-iRONiSO

TYPE : BOOKWARE Cracker : iRONiSO

FiLE : 40 X 15MB PACKAGER : iRONiSO

TOTAL : 1 * CD SUPPLiER : TEAM iRON

PLATFORM : WINDOWS FORMAT : Bin/Cue

RLS DATE : 15/02/11 PROTECTiON : NONE

Course Contents

Introduction

Welcome
Using the exercise files

1. Top Tips
Customizing the Navigation pane
Toggling between Design and Data views
Creating new fields with field templates
Understanding the "Cannot contain a Null value" error
Working with AutoNumbers as foreign keys
Using input masks
Four ways to add fields to a query
Four ways to filter data
Selecting multiple form and report controls
Aligning and distributing controls on forms and reports

2. File Management
Opening recent files
Opening your most recently used file automatically
Selecting a startup form
Changing the default saving location

3. Ribbon and Quick Access Toolbar Tips
Expanding and collapsing the Ribbon
Three ways to customize the Quick Access toolbar
Selecting Ribbon buttons using KeyTips

4. Interface Shortcuts
Turning the Navigation pane into a switchboard
Right-clicking
Using keyboard shortcuts

5. Navigation Shortcuts
Navigating between records
Using Search, Go to, and Find
Selecting fields, rows, columns, and tables

6. Data Entry and Editing Shortcuts
Undo and Redo tips
Entering data across, not down
Repeating data from the record above
Inserting today's date
Removing automatic hyperlinks
Using AutoCorrect
Using concatenated fields
Linking Outlook contacts
Saving imports and exports for reuse

7. Table Techniques
Creating a table using table templates
Setting data types
Understanding number field sizes
Setting default field types
Using validation rules
Using flag fields
Using an index
Using a datasheet Totals row
Filtering by selection
Resizing columns and rows
Removing gridlines and shading from tables
Hiding and unhiding table fields
Freezing fields when scrolling
Analyzing your table for redundant structure

8. Relationship Techniques
Setting a starting AutoNumber
Creating a multi-field primary key
Using subdatasheets
Using relationship reports

9. Query Techniques
Using wildcards
Using IN instead of OR
Hiding query fields
Changing captions
Finding duplicate records
Moving records with append and delete queries
Using make-table queries
Creating an update query
Turning a query into a PivotTable
Turning a query into a PivotChart
Using SQL statements

10. Form Techniques
Using the property sheet to work with controls
Creating option groups
Using a ComboBox to select a record
Creating tabbed form layouts
Inserting charts
Creating your own smart tags
Using the CanGrow and CanShrink properties
Hiding fields in printouts
Setting tab stops
Clipping, stretching, and zooming images
Viewing single or continuous forms
Changing a form's default view

11. Report Techniques
Inserting page breaks in reports and forms
Creating headers and footers
Hiding duplicates in reports

12. Formatting Shortcuts
Using the Format Painter
Setting default appearance for new databases

13. Macro and Event Techniques
Using a Before Change macro to create a time stamp
Triggering a Before Delete warning message
Creating a user interface macro
Using AutoExec macros

14. Database Management Techniques
Exporting to PDF
Compacting and repairing a database
Locking files

Conclusion
Goodbye

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!! For Additional info !!!!!!!!!!!!!!!!!!!!!!!!

http://www.lynda.com/home/DisplayCourse.aspx?lpk2=73286

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!!!!!! GROUP NEWS !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!! Web access Training Library's / Education video's !!!!!!!!!

!!!!!!!!! Online Training Library Access / Coders are Welcome !!!!!!!!!

!!!!!!!!! Anything if u think can be helpful in e-Learning !!!!!!!!!

!!!!!!!!! Team Dump and 100 Mbpit BNC's !!!!!!!!!

!!!!!!!!! .no / Asia Affilations !!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

!!!!!!!!!!!!! Contact Information: wearenowhere@hush.ai !!!!!!!!!!!!!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!! If 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. :) !!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


引用
下载链接来自TLF
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软件版权归原作者及其公司所有,如果你喜欢,请购买正版


引用

引用
希望更多的网友加入到国外名校开放课程整理、发布的队伍中来...

引用
资源来自网络收集 未经过一 一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

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

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

点击查看所有39网友评论

 

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

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