Access 2016 Bible

Book description

Master database creation and management

Access 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it — this book gives you an expert Access 2016 companion on call 24/7.

Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions — but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.

  • Understand database objects and design systems objects
  • Build forms, create tables, manipulate datasheets, and add data validation
  • Use Visual Basic automation and XML Data Access Page design
  • Exchange data with other Office applications, including Word, Excel, and more

From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2016 and build the database you need.

Table of contents

  1. Title Page
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. End User License Agreement

Product information

  • Title: Access 2016 Bible
  • Author(s): Michael Alexander, Richard Kusleika
  • Release date: November 2015
  • Publisher(s): Wiley
  • ISBN: 9781119086543