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



　


　
軟體簡介:
　
Lynda.com出品的時長3小時25分的Access2007的使用捷徑視頻教學。由Alicia
KatzPollock分享數以百計個技巧和捷徑來提高Access2007的最大工作效率。內容
包括Ribbon功能區和快捷列的使用，管理檔，自定義和自動化資料庫，資料快速輸
入和編輯，工作中的列表，查詢，表單和報表，以及資料庫管理等等。本教學附帶
練習文件。

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

4.InterfaceShortcuts
TurningtheNavigationpaneintoaswitchboard
Right-clicking
Usingkeyboardshortcuts

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

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

7.TableTechniques
Creatingatableusingtabletemplates
Settingdatatypes
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
UsingtheFormatPainter
Settingdefaultappearancefornewdatabases

13.MacroandEventTechniques
UsingaBeforeChangemacrotocreateatimestamp
TriggeringaBeforeDeletewarningmessage
Creatingauserinterfacemacro
UsingAutoExecmacros

14.DatabaseManagementTechniques
ExportingtoPDF
Compactingandrepairingadatabase
Lockingfiles

Conclusion
Goodbye