Microsoft access 2013 inside out

You're beyond the basics, so dive right into Access 2013--and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2013--and challenge yourself to new levels of mastery.

Build an Access Services web app with Microsoft SharePoint Server Automate your Access web app with data macros Create tables in your Access web app using built-in templates Aggregate and display your web app data using totals queries Use the Autocomplete control to quickly search for related data Create a Summary view to consolidate and group information Display related data on your views with the Related Items control Package your web app for use by others in your organization Plus--download chapters on building desktop databases

For Intermediate and Advanced Users and Database Designers

Author Notes

Jeff Conrad, a software test engineer with the Access development team, maintains a Microsoft website with a wealth of information and resource links for those needing Access guidance. Jeff is a former Microsoft MVP and the author of Microsoft Access 2010 Inside Out.

Introduction	p. xiii
Part 1 Working with Access Services web apps
Chapter 1 What is Access?	p. 3
What is a database?	p. 3
Relational databases	p. 4
The architecture of Access	p. 5
Database capabilities	p. 7
Access as an RDBMS	p. 7
Data definition and storage	p. 8
Data manipulation	p. 10
Data control	p. 12
Access as an application development system	p. 13
Deciding to move to database software	p. 15
Extending the power of Access to the web	p. 17
Chapter 2 Exploring the Access 2013 web app interface	p. 21
Working with web apps	p. 21
Opening Access for the first time	p. 22
Getting started with Access 2013	p. 27
Opening a web app template	p. 28
Exploring the Microsoft Office Backstage view	p. 32
Taking Advantage of the Quick Access Toolbar	p. 43
Understanding the Office Fluent ribbon	p. 45
Working with the Navigation pane	p. 46
Searching for web app objects	p. 49
Working in the web app design environment	p. 50
Add Tables screen	p. 50
Table Selector	p. 52
App Home View	p. 52
View Selector	p. 53
View preview window	p. 54
Viewing your web app in a web browser	p. 54
Saving a web app as an app package	p. 55
Installing app packages	p. 58
Uploading an app package to a SharePoint corporate catalog	p. 59
Installing app packages from a SharePoint corporate catalog	p. 62
Installing apps from the SharePoint Store	p. 66
Installing apps directly into a SharePoint site	p. 72
Creating a blank Access web app	p. 77
Downloading a web app into Access	p. 79
Chapter 3 Designing tables in a web app	p. 83
Creating a new blank web app	p. 84
Creating tables using table templates	p. 87
Starting with a blank table	p. 92
Defining fields in web apps	p. 94
Understanding field data types in web apps	p. 98
Setting field properties	p. 101
Completing the fields in the Vendors table	p. 104
Creating calculated fields	p. 106
Defining field validation rules for web apps	p. 113
Defining a table validation rule for web apps	p. 117
Defining a primary key for web apps	p. 120
Adding indexes	p. 121
Single-field indexes	p. 121
Multiple-field indexes	p. 123
Creating value list lookup fields in web apps	p. 124
Working with data in preview datasheets	p. 127
Creating relationships using lookup fields	p. 130
Defining a restrict delete relationship	p. 132
Defining a cascade delete relationship	p. 137
Importing and linking data into web apps	p. 139
Considerations for importing lookups	p. 140
Importing Access desktop database tables	p. 142
Importing a spreadsheet	p. 150
Importing SQL tables	p. 155
Importing a text file	p. 158
Importing a list from a SharePoint site	p. 163
Linking a SharePoint list into a web app	p. 167
Chapter 4 Creating data macros in web apps	p. 173
Uses of data macros	p. 174
Touring the Logic Designer	p. 175
Working with table events	p. 178
Using On Insert events	p. 179
Using On Update events	p. 209
Using On Delete events	p. 215
Deleting table events	p. 219
Working with named data macros	p. 220
Creating named data macros	p. 220
Using parameters	p. 223
Saving named data macros	p. 230
Calling named data macros	p. 230
Renaming and deleting named data macros	p. 236
Working with return variables	p. 238
Studying other named data macros	p. 249
Debugging data macros with the Trace table	p. 250
Understanding recursion in data macros	p. 258
Sharing data macro logic	p. 259
Chapter 5 Working with queries in web apps	p. 261
Selecting data from a single table	p. 264
Specifying fields	p. 267
Viewing query results	p. 268
Entering selection criteria	p. 271
Using expressions	p. 278
Using the Expression Builder	p. 286
Sorting data	p. 293
Working in query preview Datasheet view	p. 295
Moving around and using keyboard shortcuts	p. 295
Changing data	p. 297
Sorting data	p. 303
Filtering Data	p. 305
Selecting data from multiple tables	p. 308
Creating inner joins	p. 308
Creating outer joins	p. 313
Summarizing information with totals queries	p. 315
Totals within groups	p. 315
Selecting records to form groups	p. 320
Building a query on a query	p. 321
Using query parameters	p. 325
Selecting specific groups	p. 330
Working with unique values	p. 331
Using the Top Values query property	p. 334
Chapter 6 Working with views and the web browser experience	p. 337
Uses of views	p. 338
Understanding the App Home View	p. 338
Working with the Table Selector	p. 340
Working with the View Selector	p. 347
Starting with quick-created views	p. 356
Working within the web design surface	p. 356
Exploring Action Bar buttons	p. 368
Defining view properties	p. 371
Sizing and moving controls	p. 372
Defining control properties	p. 380
Understanding related items controls	p. 395
Customizing Datasheet views	p. 402
Working with views in a web browser	p. 409
Navigating to records using the List Control	p. 412
Filtering in views	p. 414
Understanding view and edit mode	p. 419
Using special controls for data entry	p. 422
Using Datasheet views	p. 447
Chapter 7 Advanced view design	p. 453
Creating Summary views	p. 454
Creating Blank views	p. 470
Defining subviews	p. 480
Using web browser controls	p. 486
Creating stand-alone views	p. 490
Understanding name fixup	p. 497
Adding fields	p. 497
Renaming fields	p. 499
Renaming objects	p. 499
Deleting objects	p. 501
Applying themes to web app views	p. 501
Exploring sample views in the BOSS app	p. 508
Extending your web app with desktop database reports	p. 521
Managing external connections	p. 533
Setting SharePoint site permissions	p. 536
Chapter 8 Automating a web app using macros	p. 541
The macro design surface-an overview	p. 543
Working with the Logic Designer	p. 543
Saving your macro	p. 548
Working with view and control events	p. 550
Defining macros for view events	p. 552
Defining macros for control events	p. 557
Controlling record navigation with macros	p. 568
Creating an On Start macro	p. 573
Opening views with OpenPopup actions	p. 576
Using Where clause syntax	p. 580
Referencing other view control values	p. 584
Passing parameters to views	p. 588
Exploring the audit invoices macros	p. 591
Using the SetProperty action with view controls	p. 592
Calling named data macros and using return variables	p. 597
Navigating to different views using ChangeView actions	p. 602
Exploring other named data macro parameter examples	p. 605
Part 2 Creating tables in a desktop database
Chapter 9 Exploring the Access 2013 desktop database interface	p. 613
Getting started with desktop databases	p. 613
Opening an existing desktop database	p. 614
Exploring the Microsoft Office Backstage view	p. 617
Modifying global settings via the Access Options dialog box	p. 627
Taking advantage of the Quick Access Toolbar	p. 640
Understanding content security	p. 642
Enabling a database that is not trusted	p. 643
Understanding the Trust Center	p. 646
Enabling content by defining trusted locations	p. 649
Understanding the Office Fluent Ribbon	p. 651
Home tab	p. 652
Create tab	p. 653
External Data tab	p. 654
Database Tools tab	p. 655
Understanding the Navigation pane	p. 656
Exploring Navigation pane object views	p. 658
Working with custom categories and groups	p. 664
Exploring the Navigation Options dialog box	p. 666
Sorting and selecting views in the Navigation pane	p. 670
Searching for database objects	p. 671
Using the single-document vs. the multiple-document interface	p. 674
Chapter 10 Designing tables in a desktop database	p. 679
Creating a new desktop database	p. 680
Using a database template to create a desktop database	p. 681
Creating a new empty database	p. 684
Creating your first simple table by entering data	p. 686
Creating a table using Application Parts	p. 688
Creating a table using Data Type Parts	p. 692
Creating a table in Design view	p. 696
Defining fields	p. 697
Understanding field data types	p. 699
Setting field properties	p. 703
Completing the fields in the Companies table	p. 709
Defining simple field validation rules	p. 711
Defining input masks	p. 713
Defining a primary key	p. 718
Defining a table validation rule	p. 718
Understanding other table properties	p. 721
Defining relationships	p. 724
Defining your first relationship	p. 726
Creating a relationship on multiple fields	p. 729
Adding indexes	p. 731
Single-field indexes	p. 732
Multiple-field indexes	p. 733
Setting table design options	p. 735
Database limitations	p. 739
Chapter 11 Modifying your table design	p. 741
Before You Get Started	p. 742
Deleting tables	p. 746
Renaming tables	p. 747
Changing field names	p. 749
Moving fields	p. 754
Inserting fields	p. 758
Copying fields	p. 760
Deleting fields	p. 763
Changing data attributes	p. 764
Changing data types	p. 765
Changing data lengths	p. 769
Dealing with conversion errors	p. 770
Changing other field properties	p. 771
Reversing changes	p. 772
Taking a look at Lookup properties	p. 773
Working with Multi-Value Lookup Fields	p. 777
Compacting your database	p. 781
Appendix A Installing your software	p. 783
Installing the Office system	p. 784
Choosing options when you have no previous version of the Office system	p. 785
Choosing options to upgrade a previous version of the Office system	p. 790
Converting from a previous version of Access	p. 793
Conversion issues	p. 793
Installing the Office 64-bit version	p. 794
Installing the sample files	p. 796
Index	p. 799

Available:*

On Order

Summary

Summary

Author Notes

Table of Contents