Chapter 3 :- Access – Tables and Forms

July 12, 2023 chinu

Chapter 3 :- Access - Tables and Forms

Tick the Correct Answer

1.The selected data appears________ on the screen.

(a) Colored
(b) Highlighted
(c) Gray

2. The shortcut key ‘find’ option is _________

(a) Alt + F
(b) Ctrl + I
(c) Ctrl + F

3. You can modify the structure of the table in _____________ .

(a) Datasheet View
(b) Design View
(c) Qwery view

4. Arranging records in a particular order is called __________ .

(a) Filtering
(b) Sorting
(c) Forming

5. __________ is designed to enter and edit data in a table very easily.

(a) Table
(b) Query
(c) Form

Q.2 Write True or False Statement

1.Find option is used to search a piece of record in Tables and Forms True
2. Primary key field cannot be deleted in Access. True
3. Filtering by form enables you to filter by single field. False
4. Relationship database can contain multiple related tables. True
5. A relationship works by matching the data in the key field.True
6. You cannot move through the record in a form to review or edit any information. False

Q.3 Fill in the blanks.

1. Match case check box allows you to find only text that has the same pattern of uppercase and lowercase characters.
2. Datasheet View and Design view are two views in which you can view your table.
3. Filtering data can help you review and analyze information in your database.
4. Primary key does not allow to enter duplicate values.
5. Relationship are created and managed in a Relationship window.

Q.4 Define the following terms.

1. Multiple items Form :- In Multiple-term form you will see multiple records appears at the same time in it.

2.Datasheet Form :- This form just look like a regular datasheet but it actually a form. It is used to show datasheet on a sub form.

3.Split Form :- This form shows two parts upper part show the form and lower part shows the datasheet for the table.

4. Modal Dialog Form :- Modal dialog form is useful for creating navigational menu system . This form look like a dialog box but it is actually a form.

Q.5 Answer in 1-2 sentences.

1.What is the use of toggle filter option?
Ans :- Toggle Filter is a component that enables a user to quickles access a comman,singular filter criteria.

2. What do you mean by Realtionalship window?
Ans :- Relationship are created and managed in a special database view called relationship window.

3. Why do you create relationship between tables?
Ans :- Relationship allows relational databases to split and store data in different table while linking disperate data items.

4.What do you mean by Form?
Ans :- A form is a view of one or more tables that are designed to be used for data entry and editing

Q.6 Answer Breifly.

1. What is the use of Find and Replace feature in MS-Access?
Ans :- Find allow you to quickly search data in tables,queries and froms for specified database task after finding the data you can replace it with
some other text you can specify with replace text.

2. What do you mean by Filtering data by Seelction and by Form?
Ans :- Filtering by selecting enables at display only those records that contains exactly the same data. Filtering by form enables you to filter
by multiple feilds and specify criteria for as many field as you like.