Page 37 - ModularV1.1 _c8_flipbook
P. 37
3. Freezing means to make one or more columns to be visible all times. ............................
4. We can move a column from one place to another in the table. ............................
5. We cannot delete a column from a table. ............................
C. Fill in the blanks using the words given below.
navigation, blue-colour, field properties, hide fields
1. The ............................ option is used to hide a column.
2. ............................ buttons are used to navigate through the records.
3. The ............................ pane is used to set column properties.
4. When you drag a column, a ............................ bar will appear to show the position of the column.
D. Short answer type questions.
1. What do you mean by freezing a column?
..............................................................................................................................................................................
2. How many rows can we add in a table?
..............................................................................................................................................................................
3. Which command is used to delete the records from a table?
..............................................................................................................................................................................
E. Long answer type questions.
1. Write the steps to freeze a column in a table.
2. Write the steps to add a new column in a table.
In the lab Subject Enrichment
Create the following table in MS Access:
Field Name Type
ID (Primary Key) Text
Name Text
Address Text
Email Text
Occupation Text
Age Number
After creating the preceding table, perform the following operations:
• Add a new column with the name ‘School Name’.
• Add 5 records in the table.
Do a walk-through of all the topics covered in this chapter.
Working with Tables in MS Access 35

