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

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

资源信息： 中文名: 巧学Access 2007视频教程 英文名: Lynda.com Access 2007 Tutorials Power Shortcuts 资源格式: 光盘镜像 发行日期: 2011年 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

资源简介 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 未经过安装测试与安全检测，使用者后果自负与本论坛无关 软件版权归原作者及其公司所有，如果你喜欢，请购买正版 [公告]公开招募VeryCD U 开放课程整理、发布人员报名 点此进入 希望更多的网友加入到国外名校开放课程整理、发布的队伍中来... 资源来自网络收集 未经过一 一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源