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.