Microsoft Access 2013 inside out
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 da...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Redmond, Wash.
Microsoft Press
2013
|
| Series: | Inside out
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Intro
- Contents at a glance
- Table of contents
- 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
- 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: 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
- 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
- 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
- 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