please solve this computer Questions
Attachments:
Answers
Answered by
1
1. no. we cannot enter duplicate values of primary field in an access table
2. yes
2. yes
Answered by
1
(Answer 2) = In Access, you can create table fields that calculate values. The calculations can include values from fields in the same table as well as built-in Access functions.
Notes:
The calculation cannot include fields from other tables or queries.
The results of the calculation are read-only.
Calculated fields are only available in Access databases using the .accdb file format.
You must be using Access 2010 or higher.
Create a calculated field in table datasheet view
Open the table by double-clicking it in the Navigation Pane.
Scroll horizontally to the rightmost column in the table, and click the Click to Add column heading.
In the list that appears, click Calculated Field, and then click the data type that you want for the result.
Access displays the Expression Builder.
Begin typing the calculation that you want for this field, for example:
[Quantity] * [Unit Price]
Note: It is not necessary to precede the expression with an equal sign (=).
Click OK.
Access adds the calculated field, and then highlights the field header so that you can type a field name.
Type a name for the calculated field, and then press ENTER.
Modify a calculated field in table datasheet view
Open the table by double-clicking it in the Navigation Pane.
Click on the calculated field that you want to modify.
On the Fields tab, in the Properties group, click Modify Expression.
Access displays the Expression Builder.
In the expression box, make the necessary modifications to the calculation.
Note: It is not necessary to precede the expression with an equal sign (=).
Click OK.
Answer 1 = Yes(Duplicates Ok). but if you am in the form design..like for example you have a combo box and there is a lot of list and every list there is a corresponding value that goes to another column. But if that value is the same the fields will not be selected. Thanks...
Hope it help you friend
Notes:
The calculation cannot include fields from other tables or queries.
The results of the calculation are read-only.
Calculated fields are only available in Access databases using the .accdb file format.
You must be using Access 2010 or higher.
Create a calculated field in table datasheet view
Open the table by double-clicking it in the Navigation Pane.
Scroll horizontally to the rightmost column in the table, and click the Click to Add column heading.
In the list that appears, click Calculated Field, and then click the data type that you want for the result.
Access displays the Expression Builder.
Begin typing the calculation that you want for this field, for example:
[Quantity] * [Unit Price]
Note: It is not necessary to precede the expression with an equal sign (=).
Click OK.
Access adds the calculated field, and then highlights the field header so that you can type a field name.
Type a name for the calculated field, and then press ENTER.
Modify a calculated field in table datasheet view
Open the table by double-clicking it in the Navigation Pane.
Click on the calculated field that you want to modify.
On the Fields tab, in the Properties group, click Modify Expression.
Access displays the Expression Builder.
In the expression box, make the necessary modifications to the calculation.
Note: It is not necessary to precede the expression with an equal sign (=).
Click OK.
Answer 1 = Yes(Duplicates Ok). but if you am in the form design..like for example you have a combo box and there is a lot of list and every list there is a corresponding value that goes to another column. But if that value is the same the fields will not be selected. Thanks...
Hope it help you friend
Similar questions