In ACCESS, is it possible to make new columns???

[dandyboy]

I have an ACCESS db that I am trying to insert additional columns into mydata base (db) for accurate record keeping. The standard start-up window gives you 3 columns; Field Name, Data Type and Description. I Want to make several more columns. Is it possible to divide the Description field into sub-fields or any way to add columns?
I realize that this can easily be done in EXCEL but in my top-secret clearance area, I would prefer to always have the extra security of ACCESS databases(db).

 

[jrbarnett]

Dandyboy

If you are in the table design screen, put what you want to come up as columns in each row down the bottom, then save the table and when you open it, they will appear horizontally (the nearer the top, the nearer the left).

John

 

[JeremyNYC]

Dandyboy,

Programmer? Top-Secret? Not with Access. There's nothing you can do to make an Access database significantly more secure than an excel spreadsheet.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.