Question

True and False

1.Find option is used to search a piece of record in Tables and Forms. ............

2. Primary key field cannot be deleted in Access. ...........

3. Filtering by form enables you to filter by single field. .........

4. A relationship works by matching the data in the key field. ...........

5. You cannot move through the record in a form to review or edit any information. ..........​

Answer 1

1 true

Open the table or form, and then click the field that you want to search. On the Home tab, in the Find group, click Find. The Find and Replace dialog box appears, with the Find tab selected. In the Find What box, type the value for which you want to search.

2 false

3 true

The Filter by Form window. Filtering by Form makes it easy to create a filter that uses more than one criterion. The Filter by Form window enables you to enter your filter criterion by picking values that you want the filtered records to have

4 true

table relationship works by matching data in key fields — often a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table

5 false

Answer 2

Answer:

The correct options are as follows:-

1. True

2. False

3. True

4. True

5. False

Explanation:

1. True

Click the field you wish to search in after opening the table or form. Click Find in the Find group under the Home tab. The Find tab is selected, and the Find and Replace dialogue box displays. Enter the value you wish to search for in the Find What box.

2. False

Simply open the table in design mode, pick the field, and press Delete. However, you won't be able to delete without first eliminating the relationship if the key is used in one. Select it and click the PK icon if all you want to do is remove the PK designation.

3. True

The window for filtering by form Making a filter that incorporates multiple criteria is simple when using the Form filtering method. You can input your filter criteria in the Filter by Form window by selecting the values you wish the filtered records to have.

4. True

A key field, which is frequently a field with the same name in both tables, is what makes a real table connection 4 operate. Most often, these matching fields are a foreign key in the other table and the primary key from one table, which gives each record a unique identification.

5. False

Navigation buttons make it possible to scroll through the pages and move between forms. All of the forms you construct with MS Access come with basic navigation buttons. These are the crucial and well-known buttons that are utilized to navigate through the records.

#SPJ3