How to Open & Browse a Microsoft Access Database: Step-by-Step Tutorial

By FinancialDataTools.com Team  ·  March 2026  ·  8 min read  ·  Last updated March 14, 2026

This tutorial walks you through opening and exploring a Microsoft Access database using the free FinancialDataTools.com Access Viewer. The tool reads your .mdb or .accdb file entirely inside your browser — nothing is sent to any server — making it safe for sensitive financial and business data.

Step 1: Locate Your Access File

Find the .mdb or .accdb file you want to inspect. Microsoft Access databases appear in a variety of financial and business contexts:

• Legacy accounting software databases exported in Access format
• CRM and client management databases built on Access
• Financial reporting databases from older business applications
• Historical records that have never been migrated to a modern system
• Any file ending in .mdb (Access 97–2003) or .accdb (Access 2007 and later)

If your Access file is password-protected or encrypted, the viewer will not be able to open it. The viewer works with standard, unencrypted Access databases only.

Step 2: Open the Access Viewer

Navigate to financialdatatools.com/viewers/access-viewer/ in any modern desktop browser (Chrome, Firefox, Edge, or Safari). The viewer works best on desktop — mobile screens are generally too small for comfortable table browsing.

No login, account, or installation is required. The tool loads directly in your browser tab.

Step 3: Load Your Database File

There are two ways to open your database:

• Click the green "Open File" button in the toolbar and browse to your .mdb or .accdb file using the system file picker.
• Drag and drop your file directly onto the viewer window.

The viewer displays a loading indicator while it reads the file. For most Access databases this completes in under a second. Larger databases may take a moment as the JavaScript parser processes the binary format.

Once loaded, the stats bar shows the total record count, visible records, and column count. The tab bar below the toolbar populates with a tab for each table found in the database.

Step 4: Browse Tables and Records

Click any tab to switch between tables. The viewer displays records in a spreadsheet-style grid with one row per database record. Each column header shows:

• The column name — click to sort ascending or descending
• A data type badge showing the inferred Access field type (INT, TEXT, DATE, BOOL, MEMO, etc.)
• A filter button (funnel icon) to open the column filter panel

Click any individual cell to open the Cell Detail Panel on the right side of the screen. This panel shows the full field value without truncation — useful for long text fields or fields containing embedded data.

For tables with more than 50,000 records, the viewer automatically paginates at 5,000 records per page. Use the page navigation bar at the bottom to move between pages.

Step 5: Search and Filter Records

Use the search box in the toolbar to find values across all columns simultaneously. Type any text and the viewer instantly hides records that don't contain that value in any field — no need to know which column holds the data you're looking for.

For column-specific filtering, click the filter icon in any column header to open the filter panel. Two modes are available:

• Values mode: A checklist of all distinct values in that column. Uncheck specific values to hide matching records. Use the search box inside the panel to find values quickly.
• Conditions mode: Apply a custom condition such as "contains", "equals", "greater than", or "is empty". You can apply two conditions combined with AND or OR logic for fine-grained filtering.

Active column filters are indicated by a pink badge in the stats bar showing the count of active filters. Click the badge to clear all column filters at once. The visible record count updates in real time as you apply or remove filters.

Step 6: Inspect the Schema

Click the Schema button in the toolbar to open the column definition modal for the current table. This displays each field's name, Access data type (Text, Number, Date/Time, Boolean, etc.), field size, and nullable status.

This is particularly useful when you are working with an unfamiliar Access database and need to understand the structure before deciding how to export or migrate the data. Use the Copy Column List button to copy the full field list as plain text — helpful for mapping Access fields to a target database table or spreadsheet template.

Step 7: Export Your Data

Click the Export button in the toolbar to open the export dialog. Four formats are available:

• CSV — comma-separated, ideal for importing into Excel, Google Sheets, pandas, or other tools
• JSON — array of objects, useful for developers or API workflows
• Excel (.xlsx) — a workbook with a frozen header row, auto-sized columns, and an attribution sheet
• TSV — tab-separated, useful when field values may contain commas

Two export scopes let you control what gets exported:

• Filtered view — exports only the records visible after applying your current search and column filters
• All records — exports every record in the table, ignoring any active filters

For Excel, the All tables scope exports every table in the Access database to a single workbook with one worksheet per table — a quick way to turn an entire Access database into an Excel file for sharing with colleagues.

Related Articles