Microsoft Access 2013 inside out

Introduction

Part 1. Working with Access Services web apps

Chapter 1. What is Access?

What is a database?

Relational databases

The architecture of Access

Database capabilities

Access as an RDBMS

Data definition and storage

Data manipulation

Data control

Access as an application development system

Deciding to move to database software

Extending the power of Access to the web

Chapter 2. Exploring the Access 2013 web app interface

Working with web apps

Opening Access for the first time

Getting started with Access 2013

Opening a web app template

Exploring the Microsoft Office Backstage view

Taking Advantage of the Quick Access Toolbar

Understanding the Office Fluent ribbon

Working with the Navigation pane

Searching for web app objects

Working in the web app design environment

Add Tables screen

Table Selector

App Home View

View Selector

View preview window

Viewing your web app in a web browser

Saving a web app as an app package

Installing app packages

Uploading an app package to a SharePoint corporate catalog

Installing app packages from a SharePoint corporate catalog

Installing apps from the SharePoint Store

Installing apps directly into a SharePoint site

Creating a blank Access web app

Downloading a web app into Access

Chapter 3. Designing tables in a web app

Creating a new blank web app

Creating tables using table templates

Starting with a blank table

Defining fields in web apps

Understanding field data types in web apps

Setting field properties

Completing the fields in the Vendors table

Creating calculated fields

Defining field validation rules for web apps

Defining a table validation rule for web apps

Defining a primary key for web apps

Adding indexes

Single-field indexes

Multiple-field indexes

Creating value list lookup fields in web apps

Working with data in preview datasheets

Creating relationships using lookup fields

Defining a restrict delete relationship

Defining a cascade delete relationship

Importing and linking data into web apps

Considerations for importing lookups

Importing Access desktop database tables

Importing a spreadsheet

Importing SQL tables

Importing a text file

Importing a list from a SharePoint site

Linking a SharePoint list into a web app

Chapter 4. Creating data macros in web apps

Uses of data macros

Touring the Logic Designer

Working with table events

Using On Insert events

Using On Update events

Using On Delete events

Deleting table events

Working with named data macros

Creating named data macros

Using parameters

Saving named data macros

Calling named data macros

Renaming and deleting named data macros

Working with return variables

Studying other named data macros

Debugging data macros with the Trace table

Understanding recursion in data macros

Sharing data macro logic

Chapter 5. Working with queries in web apps

Selecting data from a single table

Specifying fields

Viewing query results

Entering selection criteria

Using expressions

Using the Expression Builder

Sorting data

Working in query preview Datasheet view

Moving around and using keyboard shortcuts

Changing data

Sorting data

Filtering Data

Selecting data from multiple tables

Creating inner joins

Creating outer joins

Summarizing information with totals queries

Totals within groups

Selecting records to form groups

Building a query on a query

Using query parameters

Selecting specific groups

Working with unique values

Using the Top Values query property

Chapter 6. Working with views and the web browser experience

Uses of views

Understanding the App Home View

Working with the Table Selector

Working with the View Selector

Starting with quick-created views

Working within the web design surface

Exploring Action Bar buttons

Defining view properties

Sizing and moving controls

Defining control properties

Understanding related items controls

Customizing Datasheet views

Working with views in a web browser

Navigating to records using the List Control

Filtering in views

Understanding view and edit mode

Using special controls for data entry

Using Datasheet views

Chapter 7. Advanced view design

Creating Summary views

Creating Blank views

Defining subviews

Using web browser controls

Creating stand-alone views

Understanding name fixup

Adding fields

Renaming fields

Renaming objects

Deleting objects

Applying themes to web app views

Exploring sample views in the BOSS app

Extending your web app with desktop database reports

Managing external connections

Setting SharePoint site permissions

Chapter 8. Automating a web app using macros

The macro design surface-an overview

Working with the Logic Designer

Saving your macro

Working with view and control events

Defining macros for view events

Defining macros for control events

Controlling record navigation with macros

Creating an On Start macro

Opening views with OpenPopup actions

Using Where clause syntax

Referencing other view control values

Passing parameters to views

Exploring the audit invoices macros

Using the SetProperty action with view controls

Calling named data macros and using return variables

Navigating to different views using ChangeView actions

Exploring other named data macro parameter examples

Part 2. Creating tables in a desktop database

Chapter 9. Exploring the Access 2013 desktop database interface

Getting started with desktop databases

Opening an existing desktop database

Exploring the Microsoft Office Backstage view

Modifying global settings via the Access Options dialog box

Taking advantage of the Quick Access Toolbar

Understanding content security

Enabling a database that is not trusted

Understanding the Trust Center

Enabling content by defining trusted locations

Understanding the Office Fluent Ribbon

Home tab

Create tab

External Data tab

Database Tools tab

Understanding the Navigation pane

Exploring Navigation pane object views

Working with custom categories and groups

Exploring the Navigation Options dialog box

Sorting and selecting views in the Navigation pane

Searching for database objects

Using the single-document vs. the multiple-document interface

Chapter 10. Designing tables in a desktop database

Creating a new desktop database

Using a database template to create a desktop database

Creating a new empty database

Creating your first simple table by entering data

Creating a table using Application Parts

Creating a table using Data Type Parts

Creating a table in Design view

Defining fields

Understanding field data types

Setting field properties

Completing the fields in the Companies table

Defining simple field validation rules

Defining input masks

Defining a primary key

Defining a table validation rule

Understanding other table properties

Defining relationships

Defining your first relationship

Creating a relationship on multiple fields

Adding indexes

Single-field indexes

Multiple-field indexes

Setting table design options

Database limitations

Chapter 11. Modifying your table design

Before You Get Started

Deleting tables

Renaming tables

Changing field names

Moving fields

Inserting fields

Copying fields

Deleting fields

Changing data attributes

Changing data types

Changing data lengths

Dealing with conversion errors

Changing other field properties

Reversing changes

Taking a look at Lookup properties

Working with Multi-Value Lookup Fields

Compacting your database

Appendix A. Installing your software

Installing the Office system

Choosing options when you have no previous version of the Office system

Choosing options to upgrade a previous version of the Office system

Converting from a previous version of Access

Conversion issues

Installing the Office 64-bit version

Installing the sample files

Index