Microsoft Access

Overview Features Supported Objects Download

FEATURES FOR Microsoft Access

Features available to Microsoft Access users.

The following table shows the available features for working with Microsoft Access across the Pro and Free versions of DbVisualizer.

Supported OS'es

Feature

Runs on Windows, macOS, and Linux/UNIX

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Configurable key bindings with pre-defined key maps

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Light and Dark themes

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

High resolution images and icons for HiDPi displays

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Installers with bundled Java (no manual Java install)

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

The DbVisualizer UI

Feature

Rearranging tabs using drag&drop

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Maximize tabs with double-click

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Detach tab in separate Window

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Pin tabs

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Tile/Collapse all tabs in a tab group

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Specify default naming scheme for tabs

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Rename individual tabs

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Save layout of Object View tabs between DbVisualizer sessions

DbVisualizer Pro

Yes

DbVisualizer Free

No

Connection Management

Feature

Dynamic JDBC driver management with Maven, file, and http support

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

JDBC drivers included with DbVisualizer:

Azure SQL Database
Db2 for LUW
Derby
Exasol
H2
Greenplum
MariaDB
Mimer SQL
MySQL
NuoDB
PostgreSQL
Oracle
Redshift
SQLite
SQL Server
Sybase SQL Anywhere
Sybase ASE
Vertica
Yellowbrick

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

SSH support with known_hosts, ssh-agent, and private key support

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Connection Keep-Alive

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Optionally use a single physical connection for all operations

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Organize database connections in folders

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Set individual tab background color and borders for each connection

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Parameterized connection data

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Supports multiple simultaneous open database connections

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Connect a single or multiple connections with a single click

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Export and Import connections and general user settings

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Basic password Security

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Strong master password Security

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Show passwords in plain text if using master password Security

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Database Browser

Feature

A tree structure to browse and manage database objects

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Multi-object support for open, connect, drop, etc

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Generic database support

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

View basic information for
tables, indexes, primary keys, privileges,
schemas, databases, procedures and a lot more

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Type-to-find objects by name

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Database objects filtering

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Hide database objects

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Sort database connections and folders

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Search database objects

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Show only default database/schema

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Organize database connections and folders with drag&drop

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Script multiple database objects using drag&drop

DbVisualizer Pro

Yes

DbVisualizer Free

No

Table

Feature

Create and Alter table

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Define Referential Integrity Constraints

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Rename Table

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Drop Table

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Empty Table

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Create Index

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Table DDL viewer

DbVisualizer Pro

Yes

DbVisualizer Free

No

Procedure, Function, Package and Trigger

Feature

Create Procedure, Function, Package, Trigger

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Edit Procedure, Function, Package, Trigger

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Execute Procedure, Function

DbVisualizer Pro

Yes

DbVisualizer Free

No

Export Schema/‌Database

Feature

Export Formats

DbVisualizer Pro

CSV, HTML, SQL, XML, XLS, XLSX, JSON

DbVisualizer Free

No

Feature

Export object DDLs

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Export Table Data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Custom Data Format Settings

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for BLOB, CLOB and binary data

DbVisualizer Pro

Yes

DbVisualizer Free

No

References Graphs

Feature

Graph or list of referential integry rules

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Several automatic graph layout managers

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Link table nodes by foreign keys

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Link table nodes by all cols in a foreign key

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Bridge link support to improve readability

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Graph zooming, fit, animation and navigator pane

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Show Table details

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Script Tables as SQL by SELECT, INSERT, CREATE, etc.

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Export

DbVisualizer Pro

EMF, GIF, JPEG, PDF, PNG, SVG

DbVisualizer Free

EMF, GIF, JPEG, PDF, PNG, SVG

Feature

Print

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Save/Load manual layouts

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Table Data Viewer/Editor

Feature

Table data editing in grid (spreadsheet like) editor

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Table data editing in form editor

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Auto-complete col names while writing WHERE filter

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Table filters saved between sessions

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Copy/Paste with external spreadsheet tools such as Excel

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

One-click open of grid data in native spreadsheet tool (Excel, Numbers, LibreOffice, etc)

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Quick filtering in grids

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Display references to other tables

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Monitor row count differences

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Support for BLOB, CLOB and binary data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View BMP, TIFF, PNG, GIF and JPEG images

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View PDF documents

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View XML data in tree or text format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Table Export

Feature

Export Formats

DbVisualizer Pro

CSV, HTML, SQL, XML, XLS, XLSX, JSON

DbVisualizer Free

No

Feature

Export CREATE DDL for SQL format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Export INDEX DDL for SQL format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Custom Data Format Settings

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for BLOB, CLOB and binary data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Table Data Import

Feature

Import table data from CSV or Excel files

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for BLOB, CLOB and binary data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support multi-character col separator

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Automatic data type detection

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Automatic mapping of file cols to table cols

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Create table from imported data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Save settings between sessions

DbVisualizer Pro

Yes

DbVisualizer Free

No

Data Navigator

Feature

Expose foreign keys by data selection

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Limit referenced data with filters

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Tag support

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Edit table data directly in Navigator

DbVisualizer Pro

Yes

DbVisualizer Free

No

SQL Query Tool

Feature

Execute Script with multiple SQL statements

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Execute single SQL statement at cursor position

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Execute selected SQL statement(s)

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Execute Buffer (as a single SQL statement)

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Syntax colored SQL editor

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Auto Completion (aka code completion, intellisense)

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Predefined and user defined editor templates

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for multiple SQL editors

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for procedures producing multiple result sets

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

SQL formatter with extensive customization options

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Execution control (stop on error/warning)

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

View result sets as grid, text or chart

DbVisualizer Pro

Grid, Text, Chart

DbVisualizer Free

Grid

Feature

Editable result sets with the inline or form editors

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Support for BLOB, CLOB and binary data

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View BMP, TIFF, PNG, GIF and JPEG images

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View PDF documents

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

View XML data in tree or text format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Export result sets with Create Table option

DbVisualizer Pro

CSV, HTML, XLS, XLSX, XML, SQL

DbVisualizer Free

CSV, HTML

Feature

Export large result sets directly to file (@export)

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Parameterized SQL queries

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Supports objects dragged from the Database Browser

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Drop files from Desktop or external tools

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

SQL execution logging with filtering options

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Pre-defined editing key maps

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Merge Result Sets in Text Format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Result Set Management

Feature

Auto resize columns, manual column resizing

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Double click column divider to sort column

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Re-arrange columns by drag and drop

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Multi column sort by clicking column header

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

One-click open of grid data in native spreadsheet tool (Excel, Numbers, LibreOffice, etc)

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Copy column name

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Copy selection

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Quick filter with range options

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Quick filter highlights matched cells

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Aggregation data for selection

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Find cell data and column name

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Compare cells

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Manual or automatic merge of result sets in text format

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Export grid data

DbVisualizer Pro

CSV, HTML, JSON, SQL, TXT, XLS, XLSX, XML

DbVisualizer Free

CSV, HTML

Query Builder

Feature

Design queries with a few mouse clicks

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

No SQL expertise is required

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Adapts the generated SQL for the actual database

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Reverse engineer a SELECT statement

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Auto Join of cols by primary/foreign key or name

DbVisualizer Pro

Yes

DbVisualizer Free

No

Client-side commands

Feature

@beep

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@call

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@cd

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@command

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@commit

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@continue on

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@ddl

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@delimiter

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@desc

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@echo

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@export

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@import

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@log

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@mail

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@open

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@rollback

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@run

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@set autocommit

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@set maxchars

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@set maxrows

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@set resultset name

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@set serveroutput

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@sleep

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@stop now

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@stop on

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@window iconify

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

@window restore

DbVisualizer Pro

Yes

DbVisualizer Free

No

SQL History

Feature

SQL History

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Limit number of history entries to save

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Filter by full script content

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

SQL Bookmarks

Feature

Organize bookmarks in a folder structure

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Save bookmark as favorite for fast access

DbVisualizer Pro

Yes

DbVisualizer Free

No

SQL database charts

Feature

Supports Line, Area, Bar, Point, Pie, Stacked Area, Stacked Bar

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Modify serie label without need to use col aliases in select

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Set chart, X-axis and Y-axis labels

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Pre defined color schemes

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Optional legend at top, bottom, left or right

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Zooming, Export, Print

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Export

DbVisualizer Pro

PNG, JPEG, GIF

DbVisualizer Free

No

Feature

Print

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Copy chart image to system clipboard

DbVisualizer Pro

Yes

DbVisualizer Free

No

Favorites

Feature

Display database object details with a single-click

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Load bookmark scripts in current or new editor

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Organize favorites with drag and drop

DbVisualizer Pro

Yes

DbVisualizer Free

No

Monitor

Feature

Instant Monitor of results from SQL

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Automatic monitoring of any result set

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Single view of result sets from multiple databases

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

View data in grid, text or professional charts

DbVisualizer Pro

Grid, Text, Chart

DbVisualizer Free

Grid

Feature

Print and export monitored data

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Compare

Feature

Compare editor buffers

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Compare grid contents

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Compare individual grid cells

DbVisualizer Pro

Yes

DbVisualizer Free

No

Configurable

Feature

Define your own key bindings

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Pre-defined key bindings for TOAD and SQL Server Analyzer

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Set unique properties per database connection

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Permissions checks what commands need confirmation

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Customize the format of Date, Time and Numbers

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Set fonts

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Security

Feature

Basic Security

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Strong master password Security

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Configurable master password Pattern

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Strong password protection of exported user settings

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Show database connection passwords in clear text

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Export/Import User Settings

Feature

Export Tool Properties

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Export JDBC Drivers

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Export Master Password encrypted passwords

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Auto-update

Feature

Check for Update

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Auto-updating to new versions

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Task Management and Memory Monitoring

Feature

Central Task Manager

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Feature

Memory Monitor warns about high memory usage

DbVisualizer Pro

Yes

DbVisualizer Free

Yes

Command-line Interface, dbviscmd

Feature

DbVisualizer command-line interface

DbVisualizer Pro

Yes

DbVisualizer Free

No

Feature

Command-line generator

DbVisualizer Pro

Yes

DbVisualizer Free

No

Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗