Access 97 Table, Field INQUIRY 1

[MEM69]

I have a table created,
Now I want to enter at least 6 fields.
I entered some, but don't recall how.
If I want to enter additinal fiedls to an existing ACCESS DATABASE, how do I do this?


Also, does making a field logical or not require selecting keep or not seleting keep in the table? I was thinking that they were (yes or no) fields.


Finally, How do I know that names selected, are considered appropriate for the table, and each of the respective fields?

 

[Nebuchednezzar]

To modify a table, right click on it and choose design. You can add column names here.
To make a column logical (yes/no), you can choose the yes/no datatype for that column while in design mode.

Avoid reserved words for your column names, and I would suggest keeping column names upper case. Avoid punctuation in column names except for underscores (_).

 

[MEM69]

Thanks,

That clarified alot!