Access 2019 Bible
Learn the essentials of using Microsoft Access to store data, analyze information, build reports, create applications and much more! With "Microsoft Access 2019 bible", you'll gain a solid understanding of how Access works from the ground up. Starting with basic database concepts, y...
Otros Autores: | , |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Indianapolis, IN :
Wiley
[2019]
|
Edición: | 1st ed |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009657466106719 |
Tabla de Contenidos:
- 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 Microsoft 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 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
- Microsoft 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 ; Integrating Access with SharePoint.