Computer: Chapter 2 - Access - Creating a Database

-

Computer 

Chapter 2

Access - Creating a Database

Exercise A

1. access
2. record
3. value 
4. Query
5. memo

 

Exercise B

 1. False
2. True
3. True
4. True
5. False
6. False

 

Exercise C

1. Rows and columns
2. Value
3. .accdb [note: the dot (.) should also be put before accdb]
4. OLE object
5. Primary key
6. 255

Exercise D

Ans 1:Unique name given to each field in the table is known as the field name.
Ans 2: Data type controls what type of data can be stored. Ex: We cannot enter letters if the data type of that field is ‘Number’.
Ans 3: It allows you to enter a detailed description of all the fields within the table.
Ans 4: A validation rule is used to limit a field entry to meet certain criteria.

 

Exercise E

1. 

Record: It is a row in a table that contains information.
Field: It is a column in a table that contains information within a record.

2.

Datasheet View: It is used to create a table quickly. It gives general names to field such as Field1, Field2 etc.
Design View: It is used when we need greater control on our table. It will not give names to the fields, instead, we have to give name to the fields ourselves.

3. 

Text: It is used to give small details. It has a limit of 255 characters.
Memo: It is used to give detailed information. It has a limit of 63,999 characters.

Exercise F:

Ans 1: Microsoft Access is a Relational Database Management System (RDBMS) that allows us to create, manage and process data in the form of tables.

 

Ans 2: A template includes pre-built tables and forms. It allows us to fill our data easily.


Ans 3: A primary key is a key that differentiates the records in a file. Access uses this key to relate records of one table to another table.


Ans 4: If most of the fields contain the same data, we can set a default value. It fills the field automatically. We can change the data in the field if the data is wrong.

Exercise G:

Ans 1: A table is a collection of rows and columns. Tables allow us to store our data in an efficient way. It helps us to find what we want very easily.

Ans 2: Some Data types in Access are:

(i) text
(ii) memo
(iii) number
(iv) date/time
(v) currency
(vi) auto number etc.

Ans 3: Field properties of a database are:

(i) Properties Pane
(ii) General Tab
(iii) Lookup Tab
(iv) Drop-down list
(v) Property Information
(vi) Yes/No Properties
 
Ans 4: Changing the field size means we can change the amount of data that can be stored in a field.

Ans 5: By creating validation rules, we make sure that the correct value is entered in the field. If we make an incorrect entry, it will show us a message that there is some error.

Exercise E:

Ans: No, she has not done the right thing. The students can have the same name, which means the field is not unique. Primary Key should have unique values.

Popular posts from this blog

Poem 8 - The Patriot (Workbook Answers 4 & 5)

-
Treasure Trove Poem - 8 The Patriot Extract 4   1. 'I' refers to the speaker. He is going to the Shambles' Gate or by the scaffold's gate. In the context, rain symbolises speaker's inner crisis and sadness. It also creates a tense atmosphere in the poem.   2. The speaker's hands were tied from behind with a rope. This rope cuts his wrist. It signifies how the speaker is treated now. A year earlier, he was a hero, but now he is tied like a criminal, without any kindness.   3. The phrase adds to the ambiguity in the poem as the speaker is depicted as innocent by the poet. The reader tends to sympathise with him, but his own reference to his 'year's misdeeds'  creates ambiguity in the poem.   4. The poem shows the fickleness of the people. A year ago, he was regarded as a hero. Now the same public throes stones at him. The crowd that wanted to fulfill the speaker's wishes, now wants him executed. The poem portrays how the love, respect and honou
Read more

Merchant of Venice: Act 3 - Scene 2 (Workbook Answers 1 to 3)

-
Merchant of Venice Act 3 - Scene 2 (Workbook Answers: 1 to 3)   Extract 1 Answer 1: This scene takes place in a room in Portia's house at Belmont. The first line refers to the fact that if Portia expressed her thought, people will think bad things about her, so she can't speak of her desire. Portia says enough to convey to Bassanio that she loved him. She is doubtful whether Bassanio has understood what she has said and wanted to explain further. But then she is taken over by her maidenly modesty. Answer 2: At the end of her speech, Portia says that she spoke at length to stretch the time and delay Bassanio's act of choosing the caskets. This shows that she has feelings of love for Bassanio and does not want to lose him soon.   Answer 3: Portia cannot teach Bassanio to choose the correct casket as she has promised her father not to reveal the secret of the caskets to anyone. She would never break her promise. If Bassanio were to make an incorrect choice, Portia would ha
Read more