You are previewing Microsoft Access 2013 Inside Out.
O'Reilly logo
Microsoft Access 2013 Inside Out

Book Description

Conquer Microsoft Access 2013—from the 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

    Table of Contents

    1. Microsoft Access 2013 Inside Out
    2. Dedication
    3. A Note Regarding Supplemental Files
    4. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Features and conventions used in this book
        1. Text conventions
        2. Design conventions
      4. Your companion ebook
      5. About the companion content
        1. Using the sample files
        2. System requirements
      6. Acknowledgments
      7. Support and feedback
        1. Errata
        2. We want to hear from you
        3. Stay in touch
    5. I. Working with Access Services web apps
      1. 1. What is Access?
        1. What is a database?
          1. Relational databases
          2. The architecture of Access
          3. Database capabilities
        2. Access as an RDBMS
          1. Data definition and storage
          2. Data manipulation
          3. Data control
        3. Access as an application development system
        4. Deciding to move to database software
        5. Extending the power of Access to the web
      2. 2. Exploring the Access 2013 web app interface
        1. Working with web apps
        2. Opening Access for the first time
        3. Getting started with Access 2013
          1. Opening a web app template
          2. Exploring the Microsoft Office Backstage view
            1. Info tab
            2. New tab
            3. Open tab
            4. Save command
            5. Save As tab
            6. Close command
            7. Account tab
            8. Options command
          3. Taking Advantage of the Quick Access Toolbar
        4. Understanding the Office Fluent ribbon
        5. Working with the Navigation pane
        6. Searching for web app objects
        7. Working in the web app design environment
          1. Add Tables screen
          2. Table Selector
          3. App Home View
          4. View Selector
          5. View preview window
        8. Viewing your web app in a web browser
        9. Saving a web app as an app package
        10. Installing app packages
          1. Uploading an app package to a SharePoint corporate catalog
          2. Installing app packages from a SharePoint corporate catalog
          3. Installing apps from the SharePoint Store
          4. Installing apps directly into a SharePoint site
          5. Creating a blank Access web app
          6. Downloading a web app into Access
      3. 3. Designing tables in a web app
        1. Creating a new blank web app
        2. Creating tables using table templates
        3. Starting with a blank table
          1. Defining fields in web apps
          2. Understanding field data types in web apps
          3. Setting field properties
          4. Completing the fields in the Vendors table
          5. Creating calculated fields
          6. Defining field validation rules for web apps
        4. Defining a table validation rule for web apps
        5. Defining a primary key for web apps
        6. Adding indexes
          1. Single-field indexes
          2. Multiple-field indexes
        7. Creating value list lookup fields in web apps
        8. Working with data in preview datasheets
        9. Creating relationships using lookup fields
          1. Defining a restrict delete relationship
          2. Defining a cascade delete relationship
        10. Importing and linking data into web apps
          1. Considerations for importing lookups
          2. Importing Access desktop database tables
          3. Importing a spreadsheet
          4. Importing SQL tables
          5. Importing a text file
          6. Importing a list from a SharePoint site
          7. Linking a SharePoint list into a web app
      4. 4. Creating data macros in web apps
        1. Uses of data macros
        2. Touring the Logic Designer
        3. Working with table events
          1. Using On Insert events
            1. Including comments
            2. Grouping macros
            3. Raising errors in data macros to cancel events
            4. Testing your data macro
            5. Using If blocks to create conditional expressions
            6. Using LookupRecord data blocks to find records
            7. Using local variables
            8. Collapsing and expanding actions
            9. Moving actions
            10. Studying other On Insert events
          2. Using On Update events
          3. Using On Delete events
          4. Deleting table events
        4. Working with named data macros
          1. Creating named data macros
          2. Using parameters
          3. Saving named data macros
          4. Calling named data macros
          5. Renaming and deleting named data macros
          6. Working with return variables
        5. Studying other named data macros
        6. Debugging data macros with the Trace table
        7. Understanding recursion in data macros
        8. Sharing data macro logic
      5. 5. Working with queries in web apps
        1. Selecting data from a single table
          1. Specifying fields
          2. Viewing query results
          3. Entering selection criteria
            1. Working with dates and times in criteria
            2. AND vs. OR
            3. Between, In, and Like
          4. Using expressions
            1. Creating text expressions
            2. Defining arithmetic expressions
          5. Using the Expression Builder
          6. Sorting data
        2. Working in query preview Datasheet view
          1. Moving around and using keyboard shortcuts
          2. Changing data
            1. Adding a new record
            2. Selecting and changing data
            3. Copying and pasting data
            4. Deleting rows
          3. Sorting data
          4. Filtering Data
        3. Selecting data from multiple tables
          1. Creating inner joins
          2. Creating outer joins
        4. Summarizing information with totals queries
          1. Totals within groups
          2. Selecting records to form groups
        5. Building a query on a query
        6. Using query parameters
        7. Selecting specific groups
        8. Working with unique values
        9. Using the Top Values query property
      6. 6. Working with views and the web browser experience
        1. Uses of views
        2. Understanding the App Home View
          1. Working with the Table Selector
            1. Changing the table display order
            2. Customizing table captions
            3. Hiding table captions
            4. Choosing table icons
            5. Viewing the Table Selector in a web browser
          2. Working with the View Selector
            1. Customizing view captions
            2. Switching view caption positions
            3. Duplicating views
            4. Using the View Selector in a web browser
            5. Deleting views
        3. Starting with quick-created views
          1. Working within the web design surface
            1. The view design contextual tab
            2. The Field list
            3. Property callouts
          2. Exploring Action Bar buttons
            1. Moving and deleting Action Bar buttons
            2. Defining custom Action Bar buttons
          3. Defining view properties
          4. Sizing and moving controls
          5. Defining control properties
            1. Specifying a format for numbers
            2. Specifying a format for date/time
          6. Understanding related items controls
          7. Customizing Datasheet views
        4. Working with views in a web browser
          1. Navigating to records using the List Control
          2. Filtering in views
          3. Understanding view and edit mode
          4. Using special controls for data entry
            1. Combo boxes
            2. Hyperlink controls
            3. Multiline text boxes
            4. Check boxes
            5. Image controls
            6. Autocomplete controls
            7. Date Picker controls
            8. Related items controls
          5. Using Datasheet views
      7. 7. Advanced view design
        1. Creating Summary views
        2. Creating Blank views
        3. Defining subviews
        4. Using web browser controls
        5. Creating stand-alone views
        6. Understanding name fixup
          1. Adding fields
          2. Renaming fields
          3. Renaming objects
          4. Deleting objects
        7. Applying themes to web app views
        8. Exploring sample views in the BOSS app
        9. Extending your web app with desktop database reports
        10. Managing external connections
        11. Setting SharePoint site permissions
      8. 8. Automating a web app using macros
        1. The macro design surface—an overview
          1. Working with the Logic Designer
          2. Saving your macro
        2. Working with view and control events
          1. Defining macros for view events
          2. Defining macros for control events
        3. Controlling record navigation with macros
        4. Creating an On Start macro
        5. Opening views with OpenPopup actions
          1. Using Where clause syntax
          2. Referencing other view control values
          3. Passing parameters to views
        6. Exploring the audit invoices macros
          1. Using the SetProperty action with view controls
          2. Calling named data macros and using return variables
          3. Navigating to different views using ChangeView actions
        7. Exploring other named data macro parameter examples
    6. II. Creating tables in a desktop database
      1. 9. Exploring the Access 2013 desktop database interface
        1. Getting started with desktop databases
          1. Opening an existing desktop database
          2. Exploring the Microsoft Office Backstage view
            1. Info tab
            2. New tab
            3. Open tab
            4. Save command
            5. Save As tab
            6. Print tab
            7. Close command
            8. Account tab
          3. Modifying global settings via the Access Options dialog box
          4. Taking advantage of the Quick Access Toolbar
        2. Understanding content security
          1. Enabling a database that is not trusted
          2. Understanding the Trust Center
          3. Enabling content by defining trusted locations
        3. Understanding the Office Fluent Ribbon
          1. Home tab
          2. Create tab
          3. External Data tab
          4. Database Tools tab
        4. Understanding the Navigation pane
          1. Exploring Navigation pane object views
          2. Working with custom categories and groups
          3. Exploring the Navigation Options dialog box
          4. Sorting and selecting views in the Navigation pane
          5. Searching for database objects
        5. Using the single-document vs. the multiple-document interface
      2. 10. Designing tables in a desktop database
        1. Creating a new desktop database
          1. Using a database template to create a desktop database
          2. Creating a new empty database
        2. Creating your first simple table by entering data
        3. Creating a table using Application Parts
        4. Creating a table using Data Type Parts
        5. Creating a table in Design view
        6. Defining fields
          1. Understanding field data types
          2. Setting field properties
          3. Completing the fields in the Companies table
          4. Defining simple field validation rules
          5. Defining input masks
        7. Defining a primary key
        8. Defining a table validation rule
        9. Understanding other table properties
        10. Defining relationships
          1. Defining your first relationship
          2. Creating a relationship on multiple fields
        11. Adding indexes
          1. Single-field indexes
          2. Multiple-field indexes
        12. Setting table design options
        13. Database limitations
      3. 11. Modifying your table design
        1. Before You Get Started
        2. Deleting tables
        3. Renaming tables
        4. Changing field names
        5. Moving fields
        6. Inserting fields
        7. Copying fields
        8. Deleting fields
        9. Changing data attributes
          1. Changing data types
          2. Changing data lengths
          3. Dealing with conversion errors
          4. Changing other field properties
        10. Reversing changes
        11. Taking a look at Lookup properties
        12. Working with Multi-Value Lookup Fields
        13. Compacting your database
    7. A. Installing your software
      1. Installing the Office system
        1. Choosing options when you have no previous version of the Office system
        2. Choosing options to upgrade a previous version of the Office system
      2. Converting from a previous version of Access
        1. Conversion issues
      3. Installing the Office 64-bit version
      4. Installing the sample files
    8. B. About the author
    9. Index
    10. About the Author
    11. Copyright