Sample microsoft access project database1/24/2024 ![]() ![]() Obviously i have the complete process as i am working in this field only. ![]() ![]() I have manged to twist one db but failing to get success in it First of all i would like to say that i need to star from scratch. Is it important that you can distinguish between attempt 4 and attempt 5 that there was a minor grammar correction for example? It must be a requirement at your business level, but it seems misguided to me. I doubt there is any ISO type systems standard that requires you to record every edit between approved version 1 and approved version 2. When it requires revising, it goes through the process again and the revision number isn't updated until it goes back into approved status. Once it is approved, the revision number is typically indicated on a document (be that in the document numbering format or whatever) and is made available for use. Not trying to tell you how to run things, but I don't see the point in recording each revision that is made to a document while it is in revision status. Secondly, if you intend to store documents, you should be using something other than Access as a back end (where tables are kept) otherwise you will quickly bloat your application. If your situation is the former (starting from scratch) I suggest that you need to sit down and write out a synopsis of what are the elements of your process and the detail the flow of your process. Even your post is a bit confusing to me because at first it seems you're starting from scratch, then you show a form you have. This is not a small task and it requires that you outline the entire process - unless what you are really saying is that you have most of this done and only require help with a certain part of it. You can also contact me on I had the time to take on a job right now (assuming you are talking about a paying job) you would have to be much more forthcoming in your responses. Manage means i mean including attachments and storing the database recordsĬan you please help me to develop this system Depending on what you need from it, it can be a really big project - take it from me. I could probably dig up an old PowerPoint on how it worked if you're interested, or you might be more inclined to start from scratch and develop your own. There were a few sales, so it wasn't a total loss. Everything was migrating to web based software at the time and we didn't feel like learning that curve so we abandoned it. In conjunction with someone else I developed a system called Envisotrak (quality systems document, record and calibrated tool management system) but it was back in Access 97 I think. You can even put your data in PowerPoint presentations.Exactly what does manage them mean? It can mean anything from storing attachments (including marked up copies sent for approval) or just storing the database records that document revisions/approvals, tool calibrations and record archiving was handled in a timely fashion. You can easily filter through all these data and generate reports for all the data so you can easily analyze how your projects are doing. Similarly, the Employees tab shows you all the employees involved in each project, and their contact information. The Vendors tab lets you store contact information of specific third-party vendors or suppliers. Meanwhile, the Deliverables can show you who is in charge of every task and the details behind them. This can be very useful especially when you are managing multiple projects simultaneously. For example, in Projects, you can find your Marketing Projects Home, Open Projects Chart, Open Projects List, Project Deliverables Chart, Project Balance Sheet, and many others. Related content: Download MS Project Templates & Toolsįor each database category, you can find various forms and reports. Here, you can go to your Projects, Deliverables, Vendors, Employees, and Supporting Objects. The whole database template can be navigated from the navigation pane. The Marketing Project Management Database contains forms, tables, and queries specific for managing your marketing project. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |