| |
| |
Introduction | |
| |
| |
| |
Working with Access Services web apps | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
Creating tables in a desktop database | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |