"Editing a Table Directly
Editing a table directly is the purist's way of adjusting a
database. It is not hard to do, but some users find it intimidating
and may prefer one of the other methods.
"To edit a table in a database directly, open the database and
change the view in the Database pane on the left side of the window
to Tables. Then, select the Table in the Tables pane, and
right-click for the context menu.
"If you want to add a field to the database, select Edit to open
a view of the table. Click the first vacant role to start adding a
new field. As with other fields, you need to enter a name in the
first column and a field type in the second column. You also can
enter the field properties in the window of the pane that opens
below the main editing window, setting whether the field is
required, the number of characters it can contain and, optionally,
a default value and example. In addition, back in the main window,
you have the option of adding a brief description of the new field
in the unnamed third column."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.