Hmm, I'm confused what you are asking for here seeneedee. What type of data are you storing and what types of queries do you want to be able to execute? Could you give us some sample data and a sample query?
Access is good for simple database and query uses and many helpful how-to's can be found online. If you want something a little more robust you could always try something like Oracle 10g Express Edition which is a free home version of Oracle. Also, mySQL is available for free, but requires a more complicated and advanced setup.
we maintaining the so excel sheets as day wise ,it will be consolidated week wise &month wise by manually,my requirement is i want to automise the weekly and monthly reports generation by rising some query on daily report.suggest some solution.
So your existing solution uses Excel spreadsheets, which are then collated manually to make the monthly reports ? If you are using Excel, you can try using either formulas or macros depending on the daily data as well as the desired output form of the data. I agree with IsolatedSnail in regards to having more information about the problem, possibly sample data and the desired type of output if possible ?
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!