MS Access: List All Tables

When working with Microsoft Access, managing and understanding your database's structure is crucial. One common task is to list all tables in your database. This can help you identify tables, understand your database's structure, and perform maintenance tasks. Here's a comprehensive guide on how to list all tables in Microsoft Access.

Before we dive into the methods, let's ensure you're familiar with the Access interface. The Navigation Pane, located on the left side of the window, is where you'll find all your database objects, including tables. Now, let's explore two primary methods to list all tables in Microsoft Access.

Using the Navigation Pane

The Navigation Pane is the most straightforward way to view all tables in your database.

Microsoft Access Asset Tracking Management Database Templates for Microsoft Access 2016 Software - Verified: June 2026 ✅

1. Open your database in Microsoft Access.

2. Look at the left side of the window. You'll see the Navigation Pane, which displays all the objects in your database, including tables.

Sorting and Filtering Tables

Access allows you to sort and filter the tables in the Navigation Pane for easier navigation.

1. Click on the 'Sort by' drop-down list at the top of the Navigation Pane. You can sort tables by name, type, or date created.

2. To filter tables, click on the 'Filter by' drop-down list. You can filter by table type, such as 'Table' or 'Linked Table'.

Using VBA Code

For those comfortable with programming, using VBA (Visual Basic for Applications) code can provide a more automated approach to listing all tables.

1. Press ALT + F11 to open the Visual Basic Editor.

2. Go to Insert > Module to insert a new module.

Handy Cheat Sheets – Microsoft Office | CustomGuide

Class and Course Online Registration Software MS Access for Microsoft Access 2016 Software - Verified: May 2026 ✅

MS Access - Stored Procedure as Recordset for Forms

MS Access: Search As You Type - Multi Fields - Microsoft Access Programs

a screenshot of an excel table with the text field name and data type highlighted

the quick reference card for microsoft access 2010 is shown in this screenshote image

MS Access Do-While Statement - Microsoft Access Programs

Microsoft Access 2013/2016 pt 4 (Table Relationship)

Microsoft Access 2007 2010 part 1 (Tables)

Access Inventory Order Shipment Management Database Templates for Microsoft Access 2013 Software - Verified: May 2026 ✅

Get all source code in mdb file (msaccess) using C#/VBScript

Data Types in Microsoft Access with Examples VBA Access

I Will do better salary sheet made at Ms Excel

✅Checked: June 2026 Download Access Database Membership Tracking Templates Examples For Access 2010

Dynamic Data List using Excel Tables | MyExcelOnline

Top 10 hidden gems when using Microsoft Lists

Excel Budget Tutorial: Master Task Management Templates for Seamless Organization

Listing Tables in the Immediate Window

You can list all tables in the Immediate Window, which is a handy tool for testing and debugging VBA code.

1. In the new module, type the following code and press F5 to run it:

Sub ListTables()
    Dim db As Database
    Dim tdf As TableDef

    Set db = CurrentDb()
    Debug.Print "Tables in database:"

    For Each tdf In db.TableDefs
        Debug.Print tdf.Name
    Next tdf

    Set db = Nothing
End Sub

2. After running the code, press CTRL + G to open the Immediate Window. You'll see a list of all tables in your database.

Listing all tables in Microsoft Access is a straightforward process, whether you're using the user-friendly Navigation Pane or the more advanced VBA code. Understanding your database's structure is essential for efficient data management and maintenance. Happy database exploring!