MSA Query
 

This application manages MS Access databases using DAO (need to be installed).
It has built-in powerful query tool, BLOB editor, data editor, object viewer, user and permission manager.
You can also import data from CSV and export to CSV, Excel, dBase, XML and HTML format.
 

To add a column (field) to a table, type in the SQL command using:
ALTER TABLE [name of table] ADD COLUMN [name of field] [type]
 Press the query Execute button.

To remove a field from a table use this:

Create a new table like this:
If field is of type text, put the length in parentheses after the data type declaration:

To Delete a table:

• Use Compact on the File menu to remove all deleted records.

Freeware  MSA Query.ZIP (ver 1.6)(990k)

Installation: Contains one file. Put it somewhere and run it.

Download SQL queries help file reference