Chapter – 2 Access – Creating a Database

July 5, 2023 chinu

Chapter :- 2 Access - Creating a Database

Tick the correct answer

1.The software that help to enter and organize data in a database is ___________

a.Access

b.Excel

c.Animation

2.A row in a table that contains information is called ________.

a.Feild

b.Record

c.Datasheet

3.The specific peice of information in a table is known as _________.

a.Feild

b.Value

c.Record

4.________ is the combination of data from multiple related tables into a single datasheet.

a.Query

b.Report

c.Filter

5.The data type that is used for detailed and descriptive feild is __________ .

a.Currency

b.Long Text

c.Auto Number

Q.2 Write True or False

1.A row in a table is called feild False.
2.A DBMS allows you to create a computerized database. True.
3.Navigation pane lists all available database objects. True
4.There must be a unique name for each feild in the table. True
5.Currency data type can store currency data that cannot be used in calcualtions. False
6. The extension of all database files in Access is .exe. False

Q.3 Fill in the blanks.

1. A database is consists of table,organized in rows and columns .
2.Columns can be used to hold data in a table.
3. .accdb extension is used by default, in Access 2016 file.
4.ole object is used to store objects created in another application.
5.A primary key is a key that differentiates the records in a table of database.
6.The maximum length for a default value property is 255 characters.

Q.4 Define the following terms.

1.Feild Name :- There must be a unique name for each feild in the table called feild value.

2.Data Type :- Each feild has a data type that defines what you can store in it.

3.Description:- Detailed description of all the feilds within the table called description.

4.Validation Rule :- A validation rule is used to limit a feild entry to meet certian criteria.

Q.5 Answer in 1-2 sentences.

1.What is Microsoft access ?

Ans :- Microsoft access is a RDBMS that allows you to create,manage and process data in the form of Multiple table.

2.Why do we use templates in Access tables?

Ans :- We use templates in MS Access table beacause we can use it to fill your data easily.

3.Why do we need a Primary key?

Ans :- A primary key is a unique value holder feild that differentiates the record in the feild.

4.What is the use of default value in the properties?
Ans :- We can speed up the data entry that usually contains the same value by making that value as the default.

Q.6 Answer Briefly.

1.What is the role of tables in Database?

Ans :- In database tables play an important role. We can store records and manage record in the table.

2. Name the different data types in Access.

Ans :- The different data types in Access are
(i) short text (ii) long text (iii) Number (iv) Date time (v) Currency
(vi) auto number (vii) Yes/No (viii) OLE object (ix) Hyperlink (x) attachment
(xi) Lookup wizard.

3.Name the different Feild properties of a Database.

Ans :- Properties pane , General tab , Lookup tab , Drop down list, property information , yes/no property.

4.What do you mean by changing the feild size?

Ans :- Each feild has a size that limits the amount of data you can store in it eg :- short text 255 character,Number – Long integer and Auto-number –
Long integer.

5. Why should specify validation rules while creating a table?

Ans :- It is used to limit a feild entry to meet certain criteria , By validation rules , you can ensure that the correct value is entered into the field.