TY - BOOK AU - Alexander,Michael AU - Kusleika,Dick TI - Access 2016 bible SN - 9781119086543 U1 - 005.369 21 PY - 2016/// CY - Indianapolis, IN PB - John Wiley & Sons KW - Database management KW - sears KW - Microsoft Access N1 - "The comprehensive tutorial resource"--Cover. Includes index; design your own -- relational databases -- bulid powerful -- analytics and reporting -- program and publish -- your own applications; Access building blocks. An introduction to database development ; Getting started with Access -- Understanding Access tables. Creating Access tables ; Understanding table relationships ; Working with Access tables ; Importing and exporting data ; Linking to external data -- Working with Access queries. Selecting data with queries ; Using operators and expressions in Access ; Going beyond select queries -- Analyzing data in Access. Transforming data in Access ; Working with calculations and dates ; Performing conditional analyses ; The fundamentals of using SQL ; Subqueries and domain aggregate functions ; Running descriptive statistics in Access -- Working with Access in forms and reports. Creating basic Access forms ; Working with data on Access forms ; Working with form controls ; Presenting data with Access reports ; Advanced Access report techniques -- Access programming fundamentals. Using Access macros ; Using Access data macros ; Getting started with Access VBA ; Mastering VBA data types and procedures ; Understanding the Access event model ; Debugging your Access applications -- Advanced Access programming techniques. Accessing data with VBA ; Advanced data Access with VBA ; Customizing the ribbon ; Preparing your Access application for distribution -- Access and Windows SharePoint services. Integrating Access with SharePoint ; Deploying Access applications to SharePoint ER -