Lynda com Access 2010 Tutorials Power Shortcuts 巧學Access 2010 系列視頻教學 英文正式版


　


　
軟體簡介:
　
教學名稱：Access2010PowerShortcuts

主講人：AliciaKatzPollock

教學時長：3小時43分鐘

該教學為Lynda.com最新出品的“巧學Access2010系列視頻教學。教學中，資料庫專
家AliciaKatzPollock提供了幾百種技巧、捷徑來極大地提高Access2010的效率並
充分發揮
Access2010的作用。如利用功能區、快速訪問工具欄、檔管理、自定義、快速資料登
錄和編輯、查詢、資料庫管理等......

Welcome
Usingtheexercisefiles

1.TopTips
CustomizingtheNavigationpane
TogglingbetweenDesignandDataviews
Creatingnewfieldswithfieldtemplates
Understandingthe"CannotcontainaNullvalue"error
WorkingwithAutoNumbersasforeignkeys
Usinginputmasks
Fourwaystoaddfieldstoaquery
Fourwaystofilterdata
Selectingmultipleformandreportcontrols
Aligninganddistributingcontrolsonformsandreports

2.FileManagement
Openingrecentfiles
Openingyourmostrecentlyusedfileautomatically
Selectingastartupform
Changingthedefaultsavinglocation

3.RibbonandQuickAccessToolbarTips
ExpandingandcollapsingtheRibbon
ThreewaystocustomizetheQuickAccesstoolbar
SelectingRibbonbuttonsusingKeyTips
Creatingyourownribbons

4.InterfaceShortcuts
TurningtheNavigationpaneintoaswitchboard
Right-clicking
Usingkeyboardshortcuts

5.NavigationShortcuts
Navigatingbetweenrecords
UsingSearch,Goto,andFind
Selectingfields,rows,columns,andtables

6.DataEntryandEditingShortcuts
UndoandRedotips
Enteringdataacross,notdown
Repeatingdatafromtherecordabove
Copyingandpastingcontent
Insertingtoday'sdate
Removingautomatichyperlinks
UsingAutoCorrect
Usingconcatenatedfields
LinkingOutlookcontacts
Savingimportsandexportsforreuse

7.TableTechniques
Creatingatableusingapplicationparts
CreatingQuickStartfields
Savingapplicationparts
Understandingnumberfieldsizes
Settingdefaultfieldtypes
Usingvalidationrules
Usingflagfields
Usinganindex
UsingadatasheetTotalsrow
Filteringbyselection
Resizingcolumnsandrows
Removinggridlinesandshadingfromtables
Hidingandunhidingtablefields
Freezingfieldswhenscrolling
Analyzingyourtableforredundantstructure

8.RelationshipTechniques
SettingastartingAutoNumber
Creatingamulti-fieldprimarykey
Usingsubdatasheets
Usingrelationshipreports

9.QueryTechniques
Usingwildcards
UsingINinsteadofOR
Hidingqueryfields
Changingcaptions
Findingduplicaterecords
Movingrecordswithappendanddeletequeries
Usingmake-tablequeries
Creatinganupdatequery
TurningaqueryintoaPivotTable
TurningaqueryintoaPivotChart
UsingSQLstatements

10.FormTechniques
Usingthepropertysheettoworkwithcontrols
Creatingoptiongroups
UsingaComboBoxtoselectarecord
Creatingtabbedformlayouts
Insertingcharts
Creatingyourownsmarttags
UsingtheCanGrowandCanShrinkproperties
Hidingfieldsinprintouts
Settingtabstops
Clipping,stretching,andzoomingimages
Viewingsingleorcontinuousforms
Changingaform'sdefaultview

11.ReportTechniques
Insertingpagebreaksinreportsandforms
Creatingheadersandfooters
Hidingduplicatesinreports

12.FormattingShortcuts
Usingthemestocustomizethelookofthedatabase
UsingtheFormatPainter
Groupingcontrolsonformsandreports
Settingdefaultappearancefornewdatabases

13.MacroandEventTechniques
UsingaBeforeChangemacrotocreateatimestamp
TriggeringaBeforeDeletewarningmessage
CreatinganAfterUpdatemacrotoemailacustomer
Creatingauserinterfacemacro
UsingAutoExecmacros

14.DatabaseManagementTechniques
Savingtemplates
Lockingfiles

Conclusion
Goodbye