Cover

Title Page
Introduction
1. Is This Book for You?
2. Conventions Used in This Book
3. How This Book Is Organized
4. How to Use This Book
5. What's on the Website
Part I: Access Building Blocks
1. Chapter 1: An Introduction to Database Development
  1. The Database Terminology of Access
  2. Relational Databases
  3. Access Database Objects
  4. A Five-Step Design Method
2. Chapter 2: Getting Started with Access
  1. The Access Welcome Screen
  2. How to Create a Blank Desktop Database
  3. The Access 2016 Interface
Part II: Understanding Access Tables
1. Chapter 3: Creating Access Tables
  1. Table Types
  2. Creating a New Table
  3. Creating tblCustomers
  4. Changing a Table Design
  5. Understanding tblCustomers Field Properties
  6. Setting the Primary Key
  7. Indexing Access Tables
  8. Printing a Table Design
  9. Saving the Completed Table
  10. Manipulating Tables
  11. Adding Records to a Database Table
  12. Understanding Attachment Fields
2. Chapter 4: Understanding Table Relationships
  1. Building Bulletproof Databases
  2. Data Normalization and Denormalization
  3. Table Relationships
  4. Integrity Rules
  5. Keys
3. Chapter 5: Working with Access Tables
  1. Understanding Datasheets
  2. Looking at the Datasheet Window
  3. Opening a Datasheet
  4. Entering New Data
  5. Navigating Records in a Datasheet
  6. Changing Values in a Datasheet
  7. Using the Undo Feature
  8. Copying and Pasting Values
  9. Replacing Values
  10. Adding New Records
  11. Deleting Records
  12. Displaying Records
  13. Sorting and Filtering Records in a Datasheet
  14. Aggregating Data
  15. Printing Records
  16. Previewing Records
4. Chapter 6: Importing and Exporting Data
  1. How Access Works with External Data
  2. Options for Importing and Exporting
  3. Importing External Data
  4. Exporting to External Formats
5. Chapter 7: Linking to External Data
  1. Linking External Data
  2. Working with Linked Tables
  3. Splitting a Database
Part III: Working with Access Queries
1. Chapter 8: Selecting Data with Queries
  1. Introducing Queries
  2. Creating a Query
  3. Working with Query Fields
  4. Adding Criteria to Your Queries
  5. Printing a Query's Recordset
  6. Saving a Query
  7. Creating Multi-Table Queries
  8. Working with the Table Pane
  9. Creating and Working with Query Joins
2. Chapter 9: Using Operators and Expressions in Access
  1. Introducing Operators
  2. Using Operators and Expressions in Queries
  3. Entering Single-Value Field Criteria
  4. Using Multiple Criteria in a Query
  5. Entering Criteria in Multiple Fields
3. Chapter 10: Going Beyond Select Queries
  1. Aggregate Queries
  2. Action Queries
  3. Crosstab Queries
  4. Optimizing Query Performance
Part IV: Analyzing Data in Access
1. Chapter 11: Transforming Data in Access
  1. Finding and Removing Duplicate Records
  2. Common Transformation Tasks
2. Chapter 12: Working with Calculations and Dates
  1. Using Calculations in Your Analyses
  2. Using Dates in Your Analyses
3. Chapter 13: Performing Conditional Analyses
  1. Using Parameter Queries
  2. Using Conditional Functions
4. Chapter 14: The Fundamentals of Using SQL
  1. Understanding Basic SQL
  2. Getting Fancy with Advanced SQL Statements
  3. Using SQL-Specific Queries
5. Chapter 15: Subqueries and Domain Aggregate Functions
  1. Enhancing Your Analyses with Subqueries
  2. Domain Aggregate Functions
6. Chapter 16: Running Descriptive Statistics in Access
  1. Basic Descriptive Statistics
  2. Advanced Descriptive Statistics
Part V: Working with Access Forms and Reports
1. Chapter 17: Creating Basic Access Forms
  1. Formulating Forms
  2. Working with Controls
  3. Introducing Properties
2. Chapter 18: Working with Data on Access Forms
  1. Using Form View
  2. Changing Values in a Form
  3. Printing a Form
  4. Working with Form Properties
  5. Adding a Form Header or Footer
  6. Working with Section Properties
  7. Changing the Layout
  8. Converting a Form to a Report
3. Chapter 19: Working with Form Controls
  1. Creating a Calculated Control
  2. Working with Subforms
  3. Form Design Tips
  4. Tackling Advanced Forms Techniques
  5. Using the Tab Control
  6. Using Dialog Boxes to Collect Information
  7. Designing a Form from Scratch
4. Chapter 20: Presenting Data with Access Reports
  1. Introducing Reports
  2. Creating a Report, from Beginning to End
  3. Banded Report Design Concepts
  4. Creating a Report from Scratch
  5. Improving the Report's Appearance
5. Chapter 21: Advanced Access Report Techniques
  1. Grouping and Sorting Data
  2. Formatting Data
  3. Adding Data
  4. Adding Even More Flexibility
Part VI: Access Programming Fundamentals
1. Chapter 22: Using Access Macros
  1. Understanding Macro Security
  2. Submacros
  3. Conditions
  4. Temporary Variables
  5. Error Handling and Macro Debugging
  6. Embedded Macros
  7. Macros versus VBA Statements
2. Chapter 23: Using Access Data Macros
  1. Introducing Data Macros
  2. Understanding Table Events
  3. Using the macro designer for Data Macros
  4. Understanding the Action Catalog
  5. Creating Your First Data Macro
  6. Managing Macro Objects
  7. Recognizing the Limitations of Data Macros
3. Chapter 24: Getting Started with Access VBA
  1. Introducing Visual Basic for Applications
  2. Understanding VBA Terminology
  3. Starting with VBA Code Basics
  4. Creating VBA Programs
  5. Understanding VBA Branching Constructs
  6. Working with Objects and Collections
  7. Exploring the Visual Basic Editor
4. Chapter 25: Mastering VBA Data Types and Procedures
  1. Using Variables
  2. Working with Data Types
  3. Understanding Subs and Functions
  4. Creating Functions
  5. Simplifying Code with Named Arguments
5. Chapter 26: Understanding the Access Event Model
  1. Programming Events
  2. Identifying Common Events
  3. Paying Attention to Event Sequence
6. Chapter 27: Debugging Your Access Applications
  1. Organizing VBA Code
  2. Testing Your Applications
  3. Traditional Debugging Techniques
  4. Using the Access Debugging Tools
  5. Trapping Errors in Your Code
Part VII: Advanced Access Programming Techniques
1. Chapter 28: Accessing Data with VBA
  1. Working with Data
  2. Understanding ADO Objects
  3. Understanding DAO Objects
  4. Writing VBA Code to Update a Table
2. Chapter 29: Advanced Data Access with VBA
  1. Adding an Unbound Combo Box to a Form to Find Data
  2. Filtering a Form
3. Chapter 30: Customizing the Ribbon
  1. The Ribbon Hierarchy
  2. Editing the Default Ribbon
  3. Working with the Quick Access Toolbar
  4. Developing Custom Ribbons
  5. Creating a Custom Ribbon
  6. The Basic Ribbon XML
  7. Adding Ribbon Controls
  8. Attaching Ribbons to Forms and Reports
  9. Removing the Ribbon Completely
4. Chapter 31: Preparing Your Access Application for Distribution
  1. Defining the Current Database Options
  2. Developing the Application
  3. Polishing Your Application
  4. Bulletproofing an Application
  5. Securing the Environment
Part VIII: Access and Windows SharePoint Services
1. Chapter 32: Integrating Access with SharePoint
  1. Introducing SharePoint
  2. Understanding SharePoint Sites
  3. Sharing Data between Access and SharePoint
  4. Using SharePoint Templates
2. Chapter 33: Deploying Access Applications to SharePoint
  1. Understanding Web Publishing with Access
  2. Examining the Limitations of Access Web Applications
  3. Publishing a Custom Access Application to SharePoint
End User License Agreement