Search results

Thank you for your reply. Are there any good references(Books, PDFs,etc) to design databases for beginners? Paper or electronic, either would be fine. Also, what's PTB?

I am not creating a new record in the excel sheet as it cant be updated in access 2010. Or are you talking about the contents of the field in the resultant table from the query?

HAHA! It was too long. Anyway here it is - "You cannot record your changes because a value you entered violates the settings defined for this table or list( for example, a value is less than the minimum or greater than the maximum). Correct the error and try again" A strange thing happened...

Hi all, I have an excel sheet linked into(not imported) my access project. I have a form with 5 combo boxes. These combo boxes list the fields for a particular column like year, week number, project numbers,etc and allow the user to either select a value listed in the excel sheet or enter their...

Hi Stopher, Thanks for your reply. At the moment, my aim is to take this excel sheet and make it easier for the boss to query it. The querying being done right now is through complex pivot tables which will get cumbersome with more data being added in the future. So I thought I could put the...

Mihail, The excel file is updated manually/by hand, every week from the data from the online app which is downloaded as an excel sheet. Then after updating this sheet, it is used locally to extract whatever information is needed, which at the moment is in other sheets(but same workbook) through...

So I talked to one of the employees who uses this sheet and understood what is being inputted and outputted from it.Here's what the situation is- The company has another app online from where it gets data from its various sites about the work that the labour has done so far. This data is...

Thank you for your advice guys.I am still quite confused about what exactly they want. They have basically provided me with an excel workbook, with lots of excel sheets. The main excel sheet, called as 'Input', with approximately 20,000 rows, apparently has all the raw data from which all the...

Thank you for your replies and links. I have reading about normalization and has been very informative so far. I was looking for some kind of guide to help me through it as I was getting an intuitive feeling that I would somehow need to organise this particular raw data excel sheet, that I...

Hi all, I am recent computer science and electronics engineering graduate. I recently got hired part time as an IT assistant for a small company that does sub-contracting for the construction industry. Basically the company comprises of 7 people (including me) almost all of whom are not...