Table Views in MS Access

Asked By Abhi5 390 points N/A Posted on - 05/09/2011

How many table views are available in Ms Access? And is it possible to switch between them or not? Help me understand the concept.

• Status: Open
• Question Views: 3360
• Answer Count: 8
• Vote Up 13 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by JBond

Go To Solution

Answered By JBond 0 points N/A #90737

Table Views in MS Access

Table view is the way of looking at a table. MS Access provides two table views, design view and datasheet view. And by selecting the desired view from the view menu you can switch from one view to another.

About JBond

Questions
0

Answers
25

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By Aish5 350 points N/A #90738

Table Views in MS Access

Waiting for the solution.

About Aish5

Questions
2

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By Abhi5 390 points N/A #90739

Table Views in MS Access

What is the difference between design view and datasheet view?  Explain with details.

About Abhi5

Questions
2

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Best Answer

Best Answer

Answered By JBond 0 points N/A #90740

Table Views in MS Access

Design View:

The table view that is used to design the structure of the tables is known as Design View. It is used to specify the name, data type and description of the field. Primary key is also specified in this view. The structure of the designed table can also be changed in the design view.

Datasheet View:

The table view that is used to enter, modify and delete the data of the table is called “Datasheet view”. The table in this view is displayed in rows and columns. The name of each field is displayed at the top of the column as its header. And each row in the table contains a complete record. The query is opened in datasheet view to perform different operations on data in the table. These operations include adding, deleting, updating and searching data etc.

About JBond

Questions
0

Answers
25

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By Abhi5 390 points N/A #90741

Table Views in MS Access

Really impressive way of teaching and guiding. I am extremely thankful to you for this effort. Now tell me how to switch between these two views while working in the same window.

About Abhi5

Questions
2

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By MRobert 0 points N/A #90742

Table Views in MS Access

Following steps are used to switch between the table views:

• Click on “View” menu.
• Select Datasheet View or Design View from the menu. The table will be displayed according to your selected view.

About MRobert

Questions
0

Answers
20

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By Abhi5 390 points N/A #90743

Table Views in MS Access

Thanks a lot dear experts. Regards.

About Abhi5

Questions
2

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/09/2011
• Question Category: MS Access

Answered By Osimeon 0 points N/A #90744

Table Views in MS Access

Hello-There is Design View, Data sheet view, Pivot Table View and Pivot Chart View. And yes it is possible for you to switch between them. 

Lemme give you a quick description of what each is.

              i) Design View-is where you can add other fields in the table or delete or set validation and other field properties to the    table.

             ii) Datasheet View is the view that is moved to immediately after design view where you can actually test your database and the rules you just set in design view to see how they are working. Actually the main function of this view is to enter data into these fields that you just created.

            iii) Pivot table view enables you to view your table as pivot table.

            iv) Pivot chart view enables you to view your table as a pivot chart in excel.

About Osimeon

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Access