0 like 0 dislike
39 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 22 views
0 like 0 dislike
1 answer 37 views
0 like 0 dislike
1 answer 42 views
0 like 0 dislike
1 answer 63 views
0 like 0 dislike
1 answer 26 views
0 like 0 dislike
1 answer 65 views
0 like 0 dislike
1 answer 47 views
asked Feb 13, 2019 in Computer Science by danish (1.0m points)
0 like 0 dislike
1 answer 27 views
0 like 0 dislike
1 answer 29 views
0 like 0 dislike
1 answer 20 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

3.3k users

Free Hit Counters
...