Hi
My query is pertaining to the call tracker template. Since I'm an absolute novice with computers ad have no Knowledge of MS-Access whatsoever I needed help to understand the template better!(PS I'm unaware of SQL or any technologies since I'm a Mechanical Engineering student). We are doing a project at a company that functions on calls. I need help to understand MS-Access better only with regard to this template! I'm really sorry people.. You may laugh at the fact that i have no understanding of Access but i DESPERATELY NEED YOUR HELP! I did try MS's office help.. It isn't exactly too simple or its just that i am too dumb!
My queries are as follows:
1)The ID generation of the template is great, but it can't be edited so if there is any mistake in the form entry.. that value is gone for a toss and the next number comes into play, so one value got skipped!
2)Is it possible to manipulate the field values such that there is a prefix.. alpha-numeric values come into use rather than just numbers?
3)Can anyone let me know how i can absorb existing information from a excel table and integrate only the data into the access forms/tables?
4)If for one come company there are multiple contract numbers existing and i need to choose a contract number from the form drop down box, how can i limit the values from all contract numbers to only the relevant ones of that particular company?
5)Is there any way in which i can lock down the form so that there is only data selection rather than entry? The company would prefer it that way because employees there do tend to make a hash of things!
Thats it for now! I'm really sorry since this is my first query, I may have asked very silly questions! But I'm a quick learner and desperately need this thing to start working for me! I'd really appreciate any help on any of the questions!!
Thanks in advance!