Authoritative and comprehensive coverage for building Access 2013 Solutions
Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments. This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects.
* Explores the new development environment for Access web apps
* Focuses on the tools and techniques for developing robust web applications
* Demonstrates how to monetize your apps with Office Store and create e-commerce solutions
* Explains how to use SQL Server effectively to support both web and client solutions
* Provides techniques to add professional polish and deploy desktop application
* Shows you how to automate other programs using Macros, VBA, API calls and more.
Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.
Autorentext
Teresa Hennig, an Access MVP and business owner of 15
years, creates innovative and effective Access solutions for her
clients. She is the president of two Access User Groups, the author
of six books on Access, and an acclaimed presenter and trainer.
Ben Clothier, an Access MVP since 2009, is an Access and
SQL Server expert at the forefront of Access web apps. Ben is an
administrator at UtterAccess.
George Hepworth, an Access MVP, is an Access/SQL Server
developer and consultant. He has written numerous books on Access
and Access web apps, and is an administrator on UtterAccess.
Dagi Yudovich, an Access MVP, develops Access SQL Server
solutions to support BI needs. He is an administrator on
UtterAccess.
Wrox Professional guides are planned and written by
working programmers to meet the real-world needs of programmers,
developers, and IT professionals. Focused and relevant, they
address the issues technology professionals face every day. They
provide examples, practical solutions, and expert education in new
technologies, all designed to help programmers do a better job.
Inhalt
INTRODUCTION xxvii
PART I: ACCESS WEB APPLICATION DESIGN AND DEVELOPMENT
CHAPTER 1: INTRODUCTION TO ACCESS WEB APPS AND ARCHITECTURE 3
Deprecated Components 4
Access Data Projects 5
Jet Replication 6
Menus and Toolbars 6
Import/Export/Link to Jet 3.x and dBASE Files 7
PivotTables and PivotCharts 8
Collect Data via E-mail 8
SharePoint Workflow 8
Source Code Control Extension 9
Packaging Wizard 10
Upsizing Wizard 10
Creating Access Web Databases 11
New Components Added 12
Database Compare 12
Audit and Control Management Server 13
What Is an App? 13
How Is an App Hosted? 15
How Is an App Distributed? 16
App Marketplace for Publicly Available Solutions 16
App Catalogs for Internal-Facing Solutions 16
How Are Security and Trust Managed in Apps? 18
Setting Up a SharePoint Site for Your Apps 20
Setting Up an Office 365 Trial Account 21
Solving Business Problems 24
The Maid To Order Work Schedule Database 24
Summary 24
CHAPTER 2: DESIGNING TABLES 25
Creating a Blank App 26
Keeping Your Log Ins Straight 27
Creating Tables 29
Creating Tables Using Nouns 29
Creating Tables from Imported Data Sources 31
Creating Tables the Traditional Way 36
Tables and Their Related Views 37
Data Type Changes from Previous Versions 38
Text Data Type 38
Hyperlink Fields 39
Numeric Data Type 39
Date/Time Data Type 40
Image Data Type 40
Lookup Data Type 40
Field Properties 40
Linking SharePoint Lists 41
Summary 42
CHAPTER 3: UNDERSTANDING THE NEW USER INTERFACE 45
Web Navigation 46
Navigation Tools 46
The New Approach to Layout 51
The New Ribbon 55
Mobile Devices Support 60
SharePoint and Office 365 65
Creating a Web App via Team Site 67
Deleting Web Apps 69
Sharing Web Apps with Others 69
Summary 70
CHAPTER 4: DESIGNING VIEWS 73
View Design Surface 74
Ribbon 75
Tiles 76
Links and Creating Views 78
Field List 79
Popup Properties 84
Manipulating Control Placement 88
Duplicating a View 92
Action Bar and Action Bar Buttons 93
Action Bar Button Properties 93
Default Action Button 94
Custom Action Buttons 95
Controls 96
Changed Controls 96
New Controls 103
Common Properties 108
Client Controls with No Counterparts 109
Web Browser Control 110
Summary 114
CHAPTER 5: CREATING QUERIES AND WRITING EXPRESSIONS 115
Query Architecture 116
SQL Server Views 116
Table-Valued Functions 117
Changes in the Query Designer 119
Creating, Editing, Saving, and Previewing Queries 119
Action Queries 125
Parameterized Queries 125
Aggregates, Unique Values, and Top Values 126
Query Properties 127
Functions and Expressions 128
Delimiters 129
Operator Differences 129
New Constants 131
Data Type Inspection and Conversion 132
String Functions 135
Date and Time Functions 139
Math Functions 141
Other Functions 145
Availability by Context 146
Summary 148
CHAPTER 6: Creating Macros 149
Why We Need a New Web-Compatible Macro Language 150
Where We've Been 150
Access's Traditional Role as Tool of First Choice 151
Macro Designer 152
Action Catalog 153
Expressions and Expression Builder 153
Data Macro Tracing ...