文档介绍：本科毕业论文(设计)
外文翻译
原文:
The Master Budget Project
If you had a chance to look over the Excel-based Master Budget articles and previous Access columns to prepare for our project, you may have had the feeling—where do I start? e to my world! At first it may seem a little overwhelming, but it’s helpful to think about it in terms of iterations of a design project. We’plete our analysis and design before we start working in Access in order to limit the number of things we have to revise after learning something new. So we’plete the work in the following phases: Analysis, Design, Development, Testing, and Implementation.
One question to consider is: What is the place of Access as a tool in your workplace? It’s likely not your primary software for accounting data. Consider how /what we do in Access can use data from your existing systems and/or export data to those systems. I’m going to make the following assumption—Access does not replace existing systems but supports them. With that in mind, I suggest the following objectives for the system: 1. No duplicate data stored 2. Easy to use 3. Easy to change or adapt as the situation or need changes 4. Accurate
We’ll use the bike example from the Excel articles but create our data structure so that any products could be used. As I systematically worked my way through the six parts of the Excel series, I actually went through them three times. The first time was to see what was there and try to take it in; the second time, I started making some general observations; and the third time, I started sorting my observations into how they relate to Access.
In the first Master Budget article (February 2010), a data input spreadsheet is created. Within the spreadsheet, various areas are set up for specific data, such as sales projections, collections,
products and materials, manufacturing, cash flow, etc. These give us insights into the tables we would like to create. Once we have the tables, we’ll consider the Relationships.