How to Build a Data Dictionary in Access. A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types ...

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

In Microsoft Access, you can rename or delete a database table or other objects such as forms, reports, and queries. We show you how to do it.

Is there a way that I can have a form in Access show the user a list of the tables that are IN Access as a dropdown list?What I want to do is let the user view data based off the actual table it ...

My SQL is a little ugly with all the parens in there<BR>' (I cheated and did a design view query, then modded the SQL view - mostly just to get Access' naming convention right)<BR><BR>/code<BR>I ...

It is a highly effective tool that performs exhaustive recovery of all database information in minimum time (including password-protected data and deleted tables or records).

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.