Access 2013 Bible (英文版)
时 间:2015-01-05 09:07:12
作 者:周芳(转) ID:24526 城市:上海
摘 要:Access 2013 Bible
正 文:
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of eight books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 15 years through online forums, blogging, book contributions, and conferences.
目录
Acknowledgments ix
Contents at a Glance xi
Contents xiii
Introduction xxxix
Part I: Access Building Blocks 1
Chapter 1: An Introduction to Database Development 3
Chapter 2: Getting Started with Access 19
Part II: Understanding Access Tables 31
Chapter 3: Creating Access Tables 33
Chapter 4: Understanding Table Relationships 89
Chapter 5: Working with Access Tables 129
Chapter 6: Importing and Exporting Data 167
Chapter 7: Linking to External Data 201
Part III: Working with Access Queries 227
Chapter 8: Selecting Data with Queries 229
Chapter 9: Using Operators and Expressions in Access 261
Chapter 10: Going Beyond Select Queries 301
Part IV: Analyzing Data in Access 337
Chapter 11: Transforming Data in Access 339
Chapter 12: Working with Calculations and Dates 363
Chapter 13: Performing Conditional Analyses 389
Chapter 14: Fundamentals of Using Access SQL 407
Chapter 15: Subqueries and Domain Aggregate Functions 427
Chapter 16: Running Descriptive Statistics in Access 451
Part V: Working with Access Forms and Reports 469
Chapter 17: Creating Basic Access Forms 471
Chapter 18: Working with Data on Access Forms 509
Chapter 19: Working with Form Controls 541
Chapter 20: Presenting Data with Access Reports 575
Chapter 21: Advanced Access Report Techniques 631
Part VI: Access Programming Fundamentals 675
Chapter 22: Using Access Macros 677
Chapter 23: Getting Started with Access VBA 715
Chapter 24: Mastering VBA Data Types and Procedures 757
Chapter 25: Understanding the Access Event Model 799
Chapter 26: Debugging Your Access Applications 821
Part VII: Advanced Access Programming Techniques 853
Chapter 27: Accessing Data with VBA Code 855
Chapter 28: Advanced Data Access with VBA 897
Chapter 29: Integrating Access and SQL Server 915
Chapter 30: Customizing the Ribbon 957
Chapter 31: Preparing Your Access Application for Distribution 993
Part VIII: Access and Windows SharePoint Services 1037
Chapter 32: Understanding Windows SharePoint Services 1039
Chapter 33: Integrating Access with SharePoint 1045
Chapter 34: Understanding Access Services 1059
Chapter 35: Deploying Access Applications to SharePoint 1067
Chapter 36: Using Access Data Macros 1089
Part IX: Appendixes 1109
Appendix A: Access 2013 Specifications 1111
Appendix B: Optimizing Access Applications 1117
Appendix C: Understanding Query Performance and Database Corruption 1139
Appendix D: Function Reference for Data Analysts 1147
Index 1183
Access软件网QQ交流群 (群号:54525238) Access源码网店
常见问答:
技术分类:
源码示例
- 【源码QQ群号19834647...(12.17)
- Access对子窗体数据进行批...(10.30)
- 最精简的组合框行来源数据快速输...(10.25)
- Access仿平台的多值选择器...(10.24)
- 【Access日期区间段查询】...(10.22)
- 【Access源码示例】VBA...(10.12)
- Access累乘示例,Acce...(10.09)
- 数值8.88,把整数8去掉,转...(10.08)
- 【Access自定义函数】一个...(09.30)
- 【Access选项卡示例】Ac...(09.09)
学习心得
最新文章
- Access判断多条明细的配方或订...(11.30)
- 如何让后台数据库在局域网共享时,且...(11.29)
- 【Access月初月末日期设置方法...(11.29)
- 【Access IIF函数嵌套示例...(11.26)
- Access快速开发平台--使用组...(11.25)
- Access快速开发平台--对上传...(11.22)
- Access快速开发平台企业版--...(11.18)
- 不会用多表联合查询,多表查询没结果...(11.16)
- 【案例分享】主键字段值含有不间断空...(11.16)
- Access快速开发平台--后台D...(11.14)