Microsoft Access Projects for $15 - $25. Need to create a sales opportunity database that can be accessed by about 6 employees. This would include various management. Online Sales Tracker. Whether you're just selling a few things or starting a business, easily keep track of sales and profits with this online sales tracker template. Each tab corresponds to the forecast for one. Microsoft Access; Access Database Design for. Does anyone use Access for forecasting purposes for such a big. Each tab corresponds to the forecast for one project. Does anyone use Access for forecasting purposes for such a big number of projects?

Hi Everyone, I have a 110 MB Excel forecasting spreadsheet for our small R&D company. Each tab corresponds to the forecast for one project. Cave Puzzle Excel Game more. Column headings are months that span five-year period and row headings are disciplines of Work Breakdown Structure.

There are 109 projects and one summary tab that sums all project forecasts. So every project tab takes 1MB.

Most of the projects may have never become real projects but we have to forecast anyways and I cannot remove any of them. On each tab there are numerous formulas that shift projects back and forth depending on the expected start day of the project. To reduce the size of the file I removed most of the formatting but the file is still big and it takes couple of minutes to open it. I cannot remove any formulas (there are hundreds of them in each tab), as in this case there will be no use for the file. If there is any other Excel file opened the forecasting spreadsheet doesn’t open at all showing the message “ Not enough memory”. Is there any way to make the file manageable? I was thinking about Access database but how I can link exactly the same 109 tables.

Does anyone use Access for forecasting purposes for such a big number of projects? Excel doesn’t seem to be a right solution for this purpose but I’m not sure if I can put the forecast in Access via linking 109 tables and still being able to perform what-if analysis by shifting starting dates of the projects and adjusting amounts for each WBS item. The only difference between tables would be WBS number compiled with the project name. How should I design database for this purpose? Is is the right tool for forecasting?

Thanks a lot, Minsk. If you have 109 projects right now, then you would not have 109 tables in an Access database. Access is NOT a different way to present an Excel spreadsheet.

A database is actually VERY different than a spreadsheet. A spreadsheet is very good at What-If questions, Access really isn't. It can be done in Access, but not as easily as in Excel. The strengh of Access is in handling a lot of data that fits the same shape. A very good example is an order or invoice. In both of these cases there would be the 'main' stuff, the order information, then the 'detail' stuff which would be the individual lines items of the order.

With your forecasting system, more than likely there is a very obvious (to the trained eye) structure to how the data is organized. Football Manager 2010 Pc Ita Completo Lino more. This structure is what the normalization 'rules' will help you see and then design the table structure to best utilize a database to process your forecasting. Please look at the Access Design Tips in my signature for some excellent guidance in Normalization of data. If you have any questions, present some sample data and specific questions and there will be plently of help coming from members of this forum. A well designed database is a joy to work with. A poorly designed database can be a hugh headache!

Hi Norie, The data structure is very simple. Column headings: Months ( 60 months) five-year period. Row Headings: Work Break-Down structure. 300 numbers Inside of the table are amounts the location of which depends on the starting date of the project. The estimated started date of the project changes every month. The scope of the project changes every month as well.

Everything is linked by SUMPRODUCT, IF, and HLOOKUP functions. If I put all 109 projects in Access in one table where field names will be Months and record names would be Project Name + WBS is there any way to shift amounts for a certain project at the table level or I have to do it in query table or I can’t do it in Access at all? Thanks, Minsk.