Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Microsoft Access 2013 Inside Out
Dedication
A Note Regarding Supplemental Files
Introduction
Who this book is for
How this book is organized
Features and conventions used in this book
Text conventions
Design conventions
Your companion ebook
About the companion content
Using the sample files
System requirements
Acknowledgments
Support and feedback
Errata
We want to hear from you
Stay in touch
I. Working with Access Services web apps
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
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
Info tab
New tab
Open tab
Save command
Save As tab
Close command
Account tab
Options command
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
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
4. Creating data macros in web apps
Uses of data macros
Touring the Logic Designer
Working with table events
Using On Insert events
Including comments
Grouping macros
Raising errors in data macros to cancel events
Testing your data macro
Using If blocks to create conditional expressions
Using LookupRecord data blocks to find records
Using local variables
Collapsing and expanding actions
Moving actions
Studying other 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
5. Working with queries in web apps
Selecting data from a single table
Specifying fields
Viewing query results
Entering selection criteria
Working with dates and times in criteria
AND vs. OR
Between, In, and Like
Using expressions
Creating text expressions
Defining arithmetic expressions
Using the Expression Builder
Sorting data
Working in query preview Datasheet view
Moving around and using keyboard shortcuts
Changing data
Adding a new record
Selecting and changing data
Copying and pasting data
Deleting rows
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
6. Working with views and the web browser experience
Uses of views
Understanding the App Home View
Working with the Table Selector
Changing the table display order
Customizing table captions
Hiding table captions
Choosing table icons
Viewing the Table Selector in a web browser
Working with the View Selector
Customizing view captions
Switching view caption positions
Duplicating views
Using the View Selector in a web browser
Deleting views
Starting with quick-created views
Working within the web design surface
The view design contextual tab
The Field list
Property callouts
Exploring Action Bar buttons
Moving and deleting Action Bar buttons
Defining custom Action Bar buttons
Defining view properties
Sizing and moving controls
Defining control properties
Specifying a format for numbers
Specifying a format for date/time
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
Combo boxes
Hyperlink controls
Multiline text boxes
Check boxes
Image controls
Autocomplete controls
Date Picker controls
Related items controls
Using Datasheet views
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
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
II. Creating tables in a desktop database
9. Exploring the Access 2013 desktop database interface
Getting started with desktop databases
Opening an existing desktop database
Exploring the Microsoft Office Backstage view
Info tab
New tab
Open tab
Save command
Save As tab
Print tab
Close command
Account tab
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
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
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
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
B. About the author
Index
About the Author
Copyright
← Prev
Back
Next →
← Prev
Back
Next →