0 like 0 dislike
57 views
in Computer Science by (1.0m points)
Describe the use of database views in MS-Access?

1 Answer

0 like 0 dislike
by (1.0m points)

Views don't determine the physical organization of data; rather they are actually just the ways in which a user looks at the database. Thus, view defines the visual organization of data.There are two types of table views provided by the MS Access as:

1. Design view

2. Datasheet view

In design view, we define the design of a database relation. This view is used to define the structure of relations. By using the design view you can specify that; what are the fields in the relation, what are their names, data types and some description about these fields. Primary key is specified in this view of database too. We can also change the structure of any existing relation.

This view represents the data in a table form that consists of rows and columns. This table form is also called a datasheet .we can easily enter, delete or modify the data of a relation very easily in datasheet view. The column names are displayed on the top of each column/field as described in design view. We can easily switch between these two views by choosing required view from the View menu.Normally, both of these views are used to define and manipulate a database.

Related questions

0 like 0 dislike
1 answer 38 views
0 like 0 dislike
1 answer 54 views
0 like 0 dislike
1 answer 57 views
0 like 0 dislike
1 answer 82 views
0 like 0 dislike
1 answer 41 views
0 like 0 dislike
1 answer 86 views
0 like 0 dislike
1 answer 63 views
asked Feb 13, 2019 in Computer Science by danish (1.0m points)
0 like 0 dislike
1 answer 43 views
0 like 0 dislike
1 answer 48 views
0 like 0 dislike
1 answer 37 views
Welcome to Free Homework Help, where you can ask questions and receive answers from other members of the community. Anybody can ask a question. Anybody can answer. The best answers are voted up and rise to the top. Join them; it only takes a minute: School, College, University, Academy Free Homework Help

19.4k questions

18.3k answers

8.7k comments

6.2k users

Free Hit Counters
...