Professional Access 2013 Programming

CONTENTS

INTRODUCTION

PART I: ACCESS WEB APPLICATION DESIGN AND DEVELOPMENT

CHAPTER 1: INTRODUCTION TO ACCESS WEB APPS AND ARCHITECTURE

Deprecated Components

Access Data Projects

Jet Replication

Menus and Toolbars

Import/Export/Link to Jet 3.x and dBASE Files

PivotTables and PivotCharts

Collect Data via E-mail

SharePoint Workflow

Source Code Control Extension

Packaging Wizard

Upsizing Wizard

Creating Access Web Databases

New Components Added

Database Compare

Audit and Control Management Server

What Is an App?

How Is an App Hosted?

How Is an App Distributed?

App Marketplace for Publicly Available Solutions

App Catalogs for Internal-Facing Solutions

How Are Security and Trust Managed in Apps?

Setting Up a SharePoint Site for Your Apps

Setting Up an Office 365 Trial Account

Solving Business Problems

The Maid To Order Work Schedule Database

Summary

CHAPTER 2: DESIGNING TABLES

Creating a Blank App

Keeping Your Log Ins Straight

Creating Tables

Creating Tables Using Nouns

Creating Tables from Imported Data Sources

Creating Tables the Traditional Way

Tables and Their Related Views

Data Type Changes from Previous Versions

Text Data Type

Hyperlink Fields

Numeric Data Type

Date/Time Data Type

Image Data Type

Lookup Data Type

Field Properties

Linking SharePoint Lists

Summary

CHAPTER 3: UNDERSTANDING THE NEW USER INTERFACE

Web Navigation

Navigation Tools

The New Approach to Layout

The New Ribbon

Mobile Devices Support

SharePoint and Office 365

Creating a Web App via Team Site

Deleting Web Apps ...