Generated by All in One SEO v4.9.9, this is an llms.txt file, used by LLMs to index the site.

# WP Data Access

Passionate Programmers B.V.

## Sitemaps

- [XML Sitemap](https://wpdataaccess.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Pages

- [Home](https://wpdataaccess.com/)
- [Demos](https://wpdataaccess.com/demos/)
- [Premium Pricing Plans](https://wpdataaccess.com/pricing/)
- [Order](https://wpdataaccess.com/order/)
- [Features](https://wpdataaccess.com/features/)
- [Remote Database Connections](https://wpdataaccess.com/remote-database-connections/)
- [Query Builder](https://wpdataaccess.com/query-builder/)
- [Data Explorer](https://wpdataaccess.com/data-explorer/)
- [Table Builder](https://wpdataaccess.com/table-builder/)
- [Form Builder](https://wpdataaccess.com/form-builder/)
- [Chart Builder](https://wpdataaccess.com/chart-builder/)
- [Map Builder](https://wpdataaccess.com/map-builder/)
- [Dashboard Builder](https://wpdataaccess.com/dashboard-builder/)
- [App Builder](https://wpdataaccess.com/app-builder/)
- [Services](https://wpdataaccess.com/services/)
- [Tutorials](https://wpdataaccess.com/tutorials/)
- [Privacy Policy](https://wpdataaccess.com/privacy-policy/)
- [Premium Support](https://wpdataaccess.com/premium-support/) - How do I get premium support? Option 1: click the Premium Support icon on your WP Data Access dashboard Option 2: login from your browser https://users.freemius.com/store/2612 Both will bring you to the freemius login page. Please ask for a password reset if you don’t remember your password or login for the first time. Select your
- [Imprint](https://wpdataaccess.com/imprint/)
- [Cookie Policy](https://wpdataaccess.com/cookie-policy/)
- [Contact](https://wpdataaccess.com/contact/)

## Theme Builder Items

- [Category Pages](https://wpdataaccess.com/et_tb_item/category-pages/)
- [All Posts](https://wpdataaccess.com/et_tb_item/all-posts/)
- [Blog](https://wpdataaccess.com/et_tb_item/blog/)
- [Search Results](https://wpdataaccess.com/et_tb_item/search-results/)
- [WPDA Theme](https://wpdataaccess.com/et_tb_item/wpda-theme/)
- [Default Website Template](https://wpdataaccess.com/et_tb_item/default-website-template/)
- [Posts](https://wpdataaccess.com/et_tb_item/posts/)
- [Search Results](https://wpdataaccess.com/et_tb_item/search-results-page/)
- [Blog Page](https://wpdataaccess.com/et_tb_item/blog-page/)

## Projects

- [Demo - Excel-like Editing - Dark Mode](https://wpdataaccess.com/demos/excel-like-editing-dark-mode/) - Demo – Excel-like Editing – Dark Mode Z Demonstrated Features Excel-Like Editing Dark Mode  Required Skills Beginner Level  Required License Premium Insights Excel-Like Editing must be enabled for each individual column in the Table Builder (docs). Dark Mode can be activated in the theme settings (docs).  Transactions are prohibited for anonymous users.
- [Demo - Using Media](https://wpdataaccess.com/demos/using-media/) - Demo – Using Media Z Demonstrated Features Image URL (Beginner Level) Column Renderer  Required Skills Beginner Level JavaScript Hooks  Required License Premium Insights The Image URL feature can be applied to columns in tables (docs) and forms (docs). This feature only works if the table column contains the full image path or a
- [Demo - Dashboard With Table & Charts](https://wpdataaccess.com/demos/dashboard-with-table-charts/) - Demo – Dashboard With Table & Charts Z Demonstrated Features Dashboard Table Widget Chart Widget  Required Skills Beginner Level  Required License Premium Insights This dashboard makes use of the MySQL Classic Model sample database.  Transactions are prohibited for anonymous users. Any attempt to insert, update, or delete data results in an “Unauthorized”
- [Demo - Column Filters In Popup Window](https://wpdataaccess.com/demos/column-filters-in-popup-window/) - Demo – Column Filters In Popup Window Z Demonstrated Features Column Filters  Required Skills Beginner Level  Required License Premium Insights Column filters are defined per column in the Column Actions section (docs). General column filter settings are defined in the Column Filters section and apply to all column filters (docs). The column filters
- [Demo - Interactive Chart Selection](https://wpdataaccess.com/demos/interactive-chart-selection/) - Demo – Interactive Chart Selection Z Demonstrated Features Chart  Required Skills Basic SQL Queries  Required License Premium Insights Your users can interactively change the settings of the chart by clicking the settings icon above it. This chart also accepts URL (docs) and shortcode (docs) parameters. The chart result can be changed by passing
- [Demo - Static and Dynamic Content](https://wpdataaccess.com/demos/static-and-dynamic-content/) - Demo – Static and Dynamic Content Z Demonstrated Features Static Content Programmatic Content  Required Skills HTML JavaScript  Required License Premium Insights The following CSS was added using the CSS Table Editor to save some space when the column filters are displayed left tot the table:  Transactions are prohibited for anonymous users. Any
- [Demo - Map With Search Radius](https://wpdataaccess.com/demos/map-with-search-radius/) - Demo – Map With Search Radius Z Demonstrated Features Map  Required Skills Beginner Level  Required License Premium Insights This map’s location data comes from the markers table. The map can be implemented without any prior SQL knowledge. In the App Manager, simply select the table and the spatial columns (docs). The search radius
- [Demo - Compact Column Filters](https://wpdataaccess.com/demos/compact-column-filters/) - Demo – Compact Column Filters Z Demonstrated Features Column Filters  Required Skills Beginner Level  Required License Premium Insights Column filters are defined per column in the Column Actions section (docs). General column filter settings are defined in the Column Filters section and apply to all column filters (docs). The column filters for this
- [Demo - Conditional Lookups](https://wpdataaccess.com/demos/conditional-lookups/) - Demo – Conditional Lookups Z Demonstrated Features Conditional Lookups Excel-Like Editing (docs)  Required Skills Beginner Level  Required License Premium Insights This demonstration shows how to use lookups that are dependent on one another. This feature works in both the data entry form (docs) and the table with Excel-like editing (docs). Please keep in
- [Demo - Modal Form](https://wpdataaccess.com/demos/modal-form/) - Demo – Modal Form Z Demonstrated Features Modal Form  Required Skills Beginner Level  Required License Premium Insights Opens a modal form when the user clicks the view icon button (docs). Unlock the possibilities of your WordPress dashboard Get Premium
- [Demo - Advanced Chart Options](https://wpdataaccess.com/demos/advanced-chart-options/) - Demo – Advanced Chart Options Z Demonstrated Features Chart URL Parameters Shortcode Parameters Custom Chart Options  Required Skills Basic SQL Queries  Required License Premium Insights Custom options were used to change the chart’s background color and axis (docs). This chart also accepts URL (docs) and shortcode (docs) parameters. The chart result can be
- [Demo - Sydney Harbour Bridge](https://wpdataaccess.com/demos/sydney-harbour-bridge/) - Demo – Sydney Harbour Bridge Z Demonstrated Features Map  Required Skills Beginner Level  Required License Premium Insights This map’s location data comes from the markers table. The map can be implemented without any prior SQL knowledge. In the App Manager, simply select the table and the spatial columns (docs). > The markers table
- [Demo - Location Data With Map](https://wpdataaccess.com/demos/location-data-with-map/) - Demo – Location Data With Map Z Demonstrated Features Embedded Map (docs)  Required Skills Beginner Level  Required License Premium Insights This demo displays a data table with an embedded map based on location information from the markers table. When a user filters data or navigates to another page, the map is updated. Unlock
- [Demo - Salary Per Department](https://wpdataaccess.com/demos/salary-per-department/) - Demo – Salary Per Department Z Demonstrated Features Chart  Required Skills Beginner Level  Required License Premium Insights The chart query can be edited in the App Manager (docs). SQL Query select dname as "Department" , count(empno) as "#Employees" , sum(ifnull(sal,0)) as "Total Salary" , avg(ifnull(sal,0)) as "Average Salary" from emp right join dept
- [Demo - Advanced Detail Table](https://wpdataaccess.com/demos/advanced-detail-table/) - Demo – Advanced Detail Table Z Demonstrated Features Column Filters Excel-Line Editing  Required Skills Beginner Level  Required License Premium Insights This example shows column filtering (docs) and Excel-like editing (docs) on a detail table. These features perform similarly on master tables. The Table Builder button, which opens the Table Builder for a detail
- [Demo - Table with Chart and BUY Button](https://wpdataaccess.com/demos/table-with-embedded-chart/) - Demo – Table with Chart and BUY Button Z Demonstrated Features Column Filters Embedded Charts (docs) Column Renderer Detail Panel Renderer  Required Skills Mostly Beginner Level JavaScript Hooks  Required License Premium Insights This demo app is based on MySQL‘s Classic Model sample database. The following CSS was added using the CSS Table Editor
- [Demo - Responsive Column Filters](https://wpdataaccess.com/demos/responsive-column-filters/) - Demo – Responsive Column Filters Z Demonstrated Features Column Filters  Required Skills Beginner Level  Required License Premium Insights Column filters are defined per column in the Column Actions section (docs). General column filter settings are defined in the Column Filters section and apply to all column filters (docs). The column filter positioning for this data
- [Demo - Interactive Aggregations](https://wpdataaccess.com/demos/interactive-aggregations/) - Demo – Interactive Aggregations Z Demonstrated Features Computed Fields Aggregations (docs) Column Filters Show | Hide Columns Detail Panel  Required Skills Beginner Level JavaScript Hooks  Required License Premium Insights Opening this app in fullscreen mode will display all columns. The salary and commission columns are table columns that are saved in the database.
- [Demo - Dashboard With Multiple Tables](https://wpdataaccess.com/demos/dashboard-with-multiple-tables-2/) - Demo – Dashboard With Multiple Tables Z Demonstrated Features Dashboard Widgets  Required Skills Beginner Level  Required License Premium Insights This dashboard includes two table widgets. The dashboard and widgets can be displayed in fullscreen mode.  Transactions are prohibited for anonymous users. Any attempt to insert, update, or delete data results in an
- [Demo - Advanced Custom Form](https://wpdataaccess.com/demos/advanced-custom-form/) - Demo – Advanced Custom Form Z Demonstrated Features Multi-Level Relationships Authorized Server Calls  Required Skills JavaScript Hooks PHP Programming  Required License Premium Insights This demo illustrates multi-level relationships, allowing teachers to manage student attendance for a specific course. On startup, the module table is queried so that the teacher can select a module
- [Demo - Student Administration System](https://wpdataaccess.com/demos/student-administration-system/) - Demo – Student Administration System Z Demonstrated Features Column Filters Master-Detail Relationships Column Renderer Detail Panel Renderer  Required Skills Mostly Beginner Level JavaScript Hooks Database Relationships  Required License Premium Insights This demo showcases the Student Administration System, frequently featured in our tutorials, built using the App Builder. Anonymous users are not allowed to
- [Demo - Classic Models App](https://wpdataaccess.com/demos/classic-models-app/) - Demo – Classic Models App Z Demonstrated Features Column Filters Master-Detail Relationships Embedded Charts (docs) Column Renderer Detail Panel Renderer  Required Skills Mostly Beginner Level JavaScript Hooks Database Relationships  Required License Premium Insights This demo app is based on MySQL‘s Classic Model sample database. The following CSS was added using the CSS Table
- [Demo - Standard Data Table](https://wpdataaccess.com/demos/standard-data-table/) - Demo – Standard Data Table Z Demonstrated Features Column Filters Show | Hide Columns Detail Panel  Required Skills Beginner Level  Required License Premium Insights Column filtering is enabled by default (docs). Users can use the “show and hide columns” icon button to interactively hide individual columns (docs). The columns displayed in the detail

## Type

- [template](https://wpdataaccess.com/et_tb_item_type/template/)
- [set](https://wpdataaccess.com/et_tb_item_type/set/)

## Project Categories

- [Tables](https://wpdataaccess.com/project_category/table/)
- [Forms](https://wpdataaccess.com/project_category/form/)
- [Dashboards](https://wpdataaccess.com/project_category/dashboard/)
- [Apps](https://wpdataaccess.com/project_category/app/)
- [Charts](https://wpdataaccess.com/project_category/chart/)
- [Maps](https://wpdataaccess.com/project_category/map/)