access2010themissingmanual.pdf
《access2010themissingmanual.pdf》由会员分享,可在线阅读,更多相关《access2010themissingmanual.pdf(832页珍藏版)》请在沃文网上搜索。
1、www.it-ebooks.infowww.it-ebooks.infoAccess 2010BeijingCambridgeFarnhamKlnSebastopolTaipeiTokyoMatthew MacDonaldwww.it-ebooks.infoAccess 2010:The Missing Manualby Matthew MacDonaldCopyright 2010 OReilly Media,Inc.All rights reserved.Printed in the United States of America.Published by OReilly Media,I
2、nc.,1005 Gravenstein Highway North,Sebastopol,CA 95472.OReilly Media books may be purchased for educational,business,or sales promotional use.Online editions are also available for most titles:.For more information,contact our corporate/institutional sales department:800-998-9938 or .Printing Histor
3、y:June 2010:First Edition.Nutshell Handbook,the Nutshell Handbook logo,the OReilly logo,and“The book that should have been in the box”are registered trademarks of OReilly Media,Inc.Access 2010:The Missing Manual,The Missing Manual logo,Pogue Press,and the Pogue Press logo are trademarks of OReilly M
4、edia,Inc.Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks.Where those designations appear in this book,and OReilly Media,Inc.was aware of a trademark claim,the designations have been printed in caps or initial caps.While every precaut
5、ion has been taken in the preparation of this book,the publisher and author assume no responsibility for errors or omissions,or for damages resulting from the use of the information contained herein.ISBN:9781449382377Mwww.it-ebooks.infoiiiTable of ContentsThe Missing Credits.xviiIntroduction.1Part O
6、ne:Storing Information in TablesChapter 1:Creating Your First Database.23Understanding Access Databases.24Getting Started with Your First Database.25Understanding Tables.29Creating a Simple Table.30Editing a Table.34Saving Databases.38Making Backups.38Saving a Database with a Different Name or Forma
7、t.40Shrinking a Database.41Opening Databases.42Designating a Database as Trusted.42Opening Recent Databases.43Opening More Than One Database at Once.44Opening a Database Created in an Older Version of Access.45The Navigation Pane.47Browsing Tables with the Navigation Pane.48Managing Database Objects
8、.50Chapter 2:Building Smarter Tables.51Understanding Data Types.51Design View.52Organizing and Describing Your Fields.54How Updates Work in Design View.56www.it-ebooks.infoivtable of contentsAccess Data Types.56Text.60Memo.61Number.64Currency.66Date/Time.67Yes/No.72Hyperlink.72Attachment.74AutoNumbe
9、r.77Calculated.79The Primary Key.81Creating Your Own Primary Key Field.82Six Principles of Database Design.821.Choose Good Field Names.832.Break Down Your Information.843.Include All the Details in One Place.854.Avoid Duplicating Information.855.Avoid Redundant Information.876.Include an ID Field.88
10、Chapter 3:Mastering the Datasheet:Sorting,Searching,Filtering,and More.89Datasheet Customization.90Formatting the Datasheet.90Rearranging Columns.91Resizing Rows and Columns.92Hiding Columns.94Freezing Columns.95Datasheet Navigation.96Sorting.97Filtering.100Searching.104Advanced Editing.106The Spell
11、 Checker.107AutoCorrect.111Special Characters.113Printing the Datasheet.114Print Preview.115Fine-Tuning a Printout.117Chapter 4:Blocking Bad Data.119Data Integrity Basics.120Preventing Blank Fields.120Setting Default Values.122Preventing Duplicate Values with Indexes.124www.it-ebooks.infovtable of c
12、ontentsInput Masks.128Using a Readymade Mask.130Creating Your Own Mask.133Validation Rules.136Applying a Field Validation Rule.136Writing a Field Validation Rule.138Creating a Table Validation Rule.142Lookups.144Creating a Simple Lookup with Fixed Values.145Adding New Values to Your Lookup List.147C
13、hapter 5:Linking Tables with Relationships.149Relationship Basics.150Redundant Data vs.Related Data.150Matching Fields:The Relationship Link.152Linking with the ID Column.153The Parent-Child Relationship.154Using a Relationship.155Defining a Relationship.155Editing Relationships.160Referential Integ
14、rity.161Navigating a Relationship.164Lookups with Related Tables.167More Exotic Relationships.171One-to-One Relationship.171Many-to-Many Relationship.172Relationship Practice.176The Music School.177The Chocolate Store.181Part Two:Manipulating Data with QueriesChapter 6:Queries That Select Records.18
15、7Query Basics.188Creating Queries.188Creating a Query in Design View.189Creating a Simple Query with the Query Wizard.199Understanding the SQL View.202Queries and Related Tables.207Joining Tables in a Query.208Outer Joins.212Multiple Joins.214www.it-ebooks.infovitable of contentsChapter 7:Essential
16、Query Tricks.217Calculated Fields.217Defining a Calculated Field.218Simple Math with Numeric Fields.221Expressions with Text.223Query Functions.224Using a Function.224The Expression Builder.226Formatting Numbers.230More Mathematical Functions.230Text Functions.232Date Functions.234Dealing with Blank
17、 Values(Nulls).237Summarizing Data.238Grouping a Totals Query.240Joins in a Totals Query.242Query Parameters.244Chapter 8:Queries That Update Records.247Understanding Action Queries.247Testing Action Queries(Carefully).248The Action Query Family.249Update Queries.249Append Queries.254Creating an App
18、end(or Make-Table)Query.256Getting AutoNumbers to Start at Values Other Than 1.259Delete Queries.260Tutorial:Flagging Out-of-Stock Orders.262Finding Out-of-Stock Items.263Putting the Orders on Hold.264Chapter 9:Analyzing Data with Crosstab Queries and Pivot Tables.267Understanding Crosstab Queries.2
19、68Creating Crosstab Queries.270Creating a Crosstab Query with the Wizard.272Creating a Crosstab Query from Scratch.276Pivot Tables.278Building a Pivot Table.279Manipulating a Pivot Table.283Creating a Calculated Field.285Hiding and Showing Details.287Filtering Pivot Tables.288Pivot Charts.290Choosin
20、g a Chart Type.292Printing a Pivot Chart.293www.it-ebooks.infoviitable of contentsPart Three:Printing ReportsChapter 10:Creating Reports.297Report Basics.298Creating a One-Click Report.299Building a Report in Layout View.300The Many Views of a Report.306Rearranging a Report.308Printing,Previewing,an
21、d Exporting a Report.308Previewing a Report.309Export Formats.311Exporting a Report to a PDF.312Exporting a Report to a Different Format.314Formatting a Report.315Applying a Theme.315Formatting Columns and Column Headers.318Conditional Formatting.323Data Bars.326Filtering and Sorting a Report.328Fil
22、tering a Report.329Sorting a Report.330Chapter 11:Designing Advanced Reports.331Improving Reports in Design View.331The Design View Sections.332Understanding Controls.334Moving Fields Out of a Layout.335Adding More Controls.338Creating a Report from Scratch(in Design View).340The Report Wizard.343Th
23、e Label Wizard.345Fine-Tuning Reports with Properties.350Modifying Common Properties.352Expressions.353Grouping.354Report Grouping.356Fine-Tuning with the“Group,Sort,and Total”Pane.359Multiple Groups.362Part Four:Building a User Interface with FormsChapter 12:Creating Simple Forms.367Creating Forms.
24、368Building a Simple Form.368Using AutoNumber Fields in Forms.373Showing Pictures from a Table.374www.it-ebooks.infoviiitable of contentsUsing Forms.375Finding and Editing a Record.375Adding a Record.377Deleting a Record.378Printing Records.378Sorting and Filtering in a Form.379Sorting a Form.380Fil
25、tering a Form.380Using the Filter by Form Feature.381Saving Filters for the Future.383Creating Fancy Forms.384Manipulating Layouts.385Liberating Controls from Layouts.390Using Tabular Layouts.390Showing Multiple Records in any Form.391Split Forms.394More Useful Form Properties.396The Form Wizard.397
- 1.请仔细阅读文档,确保文档完整性,对于不预览、不比对内容而直接下载带来的问题本站不予受理。
- 2.下载的文档,不会出现我们的网址水印。
- 3、该文档所得收入(下载+内容+预览)归上传者、原创作者;如果您是本文档原作者,请点此认领!既往收益都归您。
下载文档到电脑,查找使用更方便
30 积分
下载 | 加入VIP,下载更划算! |
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- access2010themissingmanual