【正文】 章的時(shí)候，我正在尋找投入，產(chǎn)出和預(yù)算過程的關(guān)系。加載到另 一個(gè)系統(tǒng)可以用各種各樣的方式來完成。這使我們深入觀察數(shù)據(jù)庫(kù)中的程序，這包括查詢、表格和宏，還有我所說的“如果”變量。 第一篇總預(yù)算的文 章（ 2021 年 2 月）論述了數(shù)據(jù)輸入報(bào)表的創(chuàng)建。 準(zhǔn)確。我們要作如下假設(shè)：數(shù)據(jù)庫(kù)不僅不會(huì)取代現(xiàn)有的系統(tǒng)，而且會(huì)支持現(xiàn)有系統(tǒng)。我們將完成我們的分析和設(shè)計(jì)，然后才開始數(shù)據(jù)庫(kù)的工作，以便我們?cè)趯W(xué)習(xí)新事物之后限制矯正數(shù)據(jù)的數(shù)量。 one query for each line. We may not need lines for the Gross Profit because it’s a calculation, but it may be far easier to do the calculation in a query and update a table than it is to do the calculation on the report. This will bee clear as we work on the details of each of these items. Reports that are easy to do in Excel can sometimes be interestingly plex to do in Access, where reports have structure rules that give us certain constraints a spreadsheet would not have. And we have Plan B—try to calculate the values on the report first, and only include the table field if needed to store data for the report. It’s helpful to keep an open mind in the process so that you can select the best options as they bee clear. For the Balance Sheet, four fields will work in our temporary table: (1) a Category field for Asset, Liability, or Equity summary levels。 and the third time, I started sorting my observations into how they relate to Access. In the first Master Budget article (February 2021), 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. There are also a number of places in the series where calculations are included. This gives us insights into processes in Access that may involve queries, forms, and macros. There are also what I would call “what if” variables. These can be addressed by creating text boxes on forms to input the values. Queries and reports can be used to plete calculations and present professionallooking pro forma financial statements. I’m going to assume that budget data on reports will need to be printed and potentially exported to another system to load the budget. Loading a budget to another system can be acplished in a variety of ways. You can export a file to Excel or some other mon format, or you can use ODBC connections (with update privileges) to the other data source and update queries. The second method requires a lot more care because you are updating live data in another system. We’ll get into that in more detail as we start building the system. When going through the articles, I’m looking for inputs, outputs, and processes. Anything that looks like data input helps determine what tables are needed, for example, the Direct Material Information found on the Data Input Sheet of the Excel Master Budget. Any outputs, such as the Beginning Balance Sheet, will influence reports. And anything that looks like it transforms data, such as the Sales Information Formulas, is a possible process. In my first round of analysis, it looks to me like we’ll need: A table for values for the accounts that make up the assets, liabilities, and owner’s equity items. Maybe a transaction table for debit/credit entries could be created. Initially we could load beginning balances into it, but adjustments could be made or update queries could be used to set the balances from the input data. We could call it Accounts. A table for Pro