Professional Access 2013 Programming

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 ...