Logon on to Access Ch-2 Class 8th

CH-2 LOG ON TO ACCESS

EXERCISES:-

A) tick the correct answers.

1. Which of the following is not a type of database?

Ans-folder database

2. RDBMS stand for

Ans- relational database management system

3. This data type stores a link to a web page.

Ans- hyperlink

4. This component of MS Access window display the objects of the current database.

Ans-navigation pane

5. Which of the following icon indicates that the particular field is set as a primary key?

Ans- key icon

B) fill in the blanks

1. The Microsoft Access is a relational database.

2. The  primary key ensure that each record in a database can pick unequally be identified.

3. Arranging data in ascending or descending order in a table is called short and filter.

4. MS Excel is an example of flat file. database.

C) WRITE TRUE AND FALSE STATEMENTS

1. Data can be inter in data sheet view as well as design view- true

2. Validation rule field property limits the value that can be entered in the field.  True.

3. By default the field set as primary key has autonumber data type false.

4. A table can have multiple primary keys false

5. Pencil I can indicate the edit mode in access true.

D) answer the following questions

1. Define the term database. List any two benefit of database management system.

Ans- a database is maintained everywhere from crockery store to mall school to universities is small companies to be companies and so on.

Some other example of database management are:-

Maintaining detail of employees in a company

Keeping students record in a school.

2. Differentiate between flat file database and relational database.

Ans- A flat file database stores data in a single table structure. A relational database uses multiple table structures, cross-referencing records between tables. Tables in both organize records in rows, with each column containing a single piece of data in the record.

3. Explain the element of a table in access database.

Ans- In Microsoft Access the schema elements are known generically as objects, and include the following: Tables: are used to store data. Fields and indexes are essential parts of the table. Relationships: help to control the data by defining how tables are related.

4. What do you understand by data types? Explain the autonumber data type.

Ans-The AutoNumber data type automatically generates a unique number for each record that's added to a table, and is commonly used for primary key fields. ... Set its FieldSize property to Long Integer and give it the same name as the AutoNumber field in the table whose value you want to change.

5. Define primary key. How does a primary key help in a organising a database?

Ans- The purpose of the primary key in a database is to provide a map of the data. A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. A primary key's main features are: It must contain a unique value for each row of data.