Page 116 - Viva ICSE Computer Studies 7 : E-book

C. Name the following.

1. Group and tab of Table Design option ___________________ ___________________
2. Shortcut key to close the table window ___________________

3. Set of records that are retrieved and stored in a separate table ___________________
4. Any two panes of Query window ___________________ ___________________

5. Shortcut key to save the table name ___________________

D. Write the steps to perform the following tasks.

1. Add a fi eld in Design view.

2. Move a fi eld.
3. Hide and unhide a fi eld.

4. Sort data.

5. Create a query in Design view.

E. Answer the following questions.

1. Describe two methods to create a table in Access 2016. Also write the steps.

2. How will you add a fi eld in Datasheet view?
3. How is deleting a fi eld in Datasheet view diff erent from deleting a fi eld from Design view?

4. Defi ne freezing a fi eld. How is it done in Access 2016?
5. Write the steps to build a relationship among tables.

Building Values and Life Skills

Reena creates a database of her classmates. She has been asked to display data of those students
who have failed. Suggest her the method to apply this criteria.

Testing Knowledge

Student table Employee table

ID Name Address ID Name Address
1 Sheena Delhi 1 Roya CS

2 Priya UP 2 Advik Electrical

Suppose a relationship is to be created among tables ‘Student’ and ‘Employee’. Which fi eld can be
used to form a relationship among the given tables?

104