grade -Editing table

• IT
• Primary Education
• Age 12

Insert, Delete, Move, Hide
Which of these actions do you already know from MS Word or Excel? How do you think they work in MS Access?”

Chapter 3

Working with Table

To insert a new field in a table, it should first open in _____ view.

1. Datasheet
2. Index
3. Design
4. All of these

We can change the sequence of fields in a table even after creating it.

1. True
2. False

Select 'Hide fields or Unhide fields option from the _____menu

1. File
2. Context
3. Edit
4. None of these

Leaning Objectives

Explain why modifying table structure is important in databases.

Perform inserting, deleting, moving, hiding, and unhiding fields in a given table.

Learning Outcomes

Will be able to will make a simple addition to the table.

will make a rearranged table structure without unnecessary fields.

will make a table view with hidden/unhidden fields

Our school has added a new rule: every student must provide a parent’s email ID. Which feature of Access would you use to update the table?

Extended Task

You are designing a Library Database. Add a new field “Book Price” (Currency type), move it next to “Book Title”, delete any unnecessary field, and hide/unhide “Publisher Name”.