By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Can you pull reports

P: 1
We are looking for a tracking system where you can pull a report everyday of what dates/tasks need to be taken care of. Does Access have this function? We are currently storing information in excel but to the best of my knowledge you cannot pull a report.

Thank you.
Jul 6 '12 #1
Share this Question
Share on Google+
2 Replies


ariful alam
100+
P: 185
Are you trying to generate report of future task from Access Database tables using dates?
Jul 7 '12 #2

zmbd
Expert Mod 5K+
P: 5,397
That's a fairly open question...
Let's say you're doing preventative maintenance work, you can certainly create a database that keeps track of the current work, work completed, and then based on completed work dates schedule new dates... and so forth.

As you have such an open question... if you have MS Access, you might start here if you're looking for something "off the shelf." http://office.microsoft.com/en-us/te...010214400.aspx. These may not be the best templates in the world; however, they will give you idea as to what can be done with Access. The best thing about these templates is that you can say... well this one does almost what we need; however, can it be modified to do.... that question either for people here or your inhouse DBA

Once you see what is there, you can start to design your own database that will do what you need... there are several steps to good database design. You can google these, several good books out there, and of-course some resources like here. One of the most important aspects is the normalization of the underlying data... http://bytes.com/topic/access/insigh...le Structures. I can almost guarantee that your excel data is not normalized in the least little bit.

Once you get a chanc to look at things, post back if you have any more questions.

-z
Jul 7 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.