How to get a table in column view

[Guest]

When I click create I get a list of fields side by side. I tried various
things, including office online, to get the table to column view.

Can someboy help?

dennist

 

[Jeff Boyce]

Not sure what you mean by "column view". Try going to the database window,
clicking "View" | "Details".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Joseph Meehan]

When I click create I get a list of fields side by side. I tried
various things, including office online, to get the table to column
view.

Can someboy help?

dennist

If I understand you correctly, you are creating a new table. You see a
list where you add field names and their definitions down the page. You
want to work with something like a spread sheet where most people put the
names of the data they are going to store across the top line.

The problem, if I understand you correctly, is that you are thinking of
a table like a spreadsheet. It is far different. In a database a table is
not a worksheet, it is a storage place for field definitions and a place to
store data. It is not designed as a primary tool to display, enter or edit
that data. Those functions should take place using a form, query or report.
A table does not even store the data in any predictable order.

 

[Joseph Meehan]

When I click create I get a list of fields side by side. I tried
various things, including office online, to get the table to column
view.

Can someboy help?

dennist

If I understand you correctly, you are creating a new table. You see a
list where you add field names and their definitions down the page. You
want to work with something like a spread sheet where most people put the
names of the data they are going to store across the top line.

The problem, if I understand you correctly, is that you are thinking of
a table like a spreadsheet. It is far different. In a database a table is
not a worksheet, it is a storage place for field definitions and a place to
store data. It is not designed as a primary tool to display, enter or edit
that data. Those functions should take place using a form, query or report.
A table does not even store the data in any predictable order.

 

[Rick Brandt]

When I click create I get a list of fields side by side. I tried
various things, including office online, to get the table to column
view.

Can someboy help?

dennist

When you click the "New" button to create a new table you are given some
choices. The first two are "Datasheet View" and "Design View". You want
"Design View".

The fact that MS decided to make datasheet view the default is just another area
that shows that they really have no idea how to use Access properly at all.

 

[Guest]

When I open access 2007 I get an intro. Do I want to open current daabases,
download, templates, etc. One is ceting a new dtabase. I select that and I
get the sideby side view for the fields. I see no options.

dennist