when a user opens a database he should be able to go to forms directly and he can edit info in the form but when he closes a form he should not be able to see the tables and other design of database.so how to do this?
If a field has 2 values separated by a delimiter such that a Blood pressure field has a value like 120/80 and i've to perform calculation by taking one value from the field like 120 and another value from other different field then how to do this in access?
By the sounds of it, I'm assuming that the blood pressure field is a text datatype? Maybe you might want to consider splitting this data into two number type fields. In the tables this would look meaningless but you could concatenate these 2 values into 1 text box on your form. Then you would be in easier position to perform your calculations.