A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i add extra columns (in table view) in Access?



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2005, 03:58 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default how do i add extra columns (in table view) in Access?

I do not mean colums as they appear in the design view (e.g., formatted) but
rather in the excel looking sheet. I need to have some questions that require
extra columns so as to designate there are extra parts to this question.

Not sure if that makes sense...

Thanks!
  #2  
Old November 22nd, 2005, 04:07 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default how do i add extra columns (in table view) in Access?

kricket wrote:
I do not mean colums as they appear in the design view (e.g.,
formatted) but rather in the excel looking sheet. I need to have some
questions that require extra columns so as to designate there are
extra parts to this question.

Not sure if that makes sense...


No, it doesn't. The columns you see in the datsheet are those that are defined
in design view. You can have "calculated" or "derived" columns in queries that
use expressions and/or data from other columns, but in a table the only columns
you see are those that are defined in the design view of the table.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #3  
Old November 22nd, 2005, 04:12 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default how do i add extra columns (in table view) in Access?

I think that Table Design View is the easiest way to add them. (There
are others, but I don't think any of them are any less difficult.) Just
give each field a name, select the data type, and save the Table.

Do you maybe mean that you want different numbers of fields (columns) to
be shown for different records (rows)? To do that, Access provides
features such as subforms or subqueries. Ask for assistance here if you
need it.

-- Vincent Johns
Please feel free to quote anything I say here.


kricket wrote:

I do not mean colums as they appear in the design view (e.g., formatted) but
rather in the excel looking sheet. I need to have some questions that require
extra columns so as to designate there are extra parts to this question.

Not sure if that makes sense...

Thanks!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
Toolbars, Drop-Down Menus Rick New Users 1 September 21st, 2005 11:17 AM
Access combo box-show name, not ID, in table? write on New Users 30 April 30th, 2005 09:11 PM
Why is a French Spellchecker a "required" update for English speak French Spellcheck Required? General Discussion 23 April 26th, 2005 01:17 AM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM


All times are GMT +1. The time now is 06:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.