User Manual for Prototype of ASEANStats Report Writer
Contents
1. Record 14 1of6 ok rA t Search 4 T 2 After this you close the open windows not necessarily the main editing window and proceed That is all the information necessary for the new page layout but certainly this can and should be facilitated by a programmed approach AN See If you remember from the beginning of the chapter button 2 will be selected to enter new series Edit New Delete Data Series The process of editing and addition of series information works quite similar to the editing and addition of series Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 14 You will have the following screens appear Es A Page DataS NewOrDelete Report Page an Data Series Add Click Select Button to select or delete Data Series in Report Page First select a Line in Box then add Series Number two digits s e g 501 for the selected Report and Page Exit Field to Update List Delete Click Select Button to select or delete Report Page Data Series and click Delete Button in lower right corner Recordi M 4 210 21 Existing Report Page Data Series in ASEANStats Report Writer AEC Chartbook AEC Chartbook AEC Chartbook ASEAN Community in Figures ACIF ASEAN Community in Figures ASEAN Community in Figures A2. Record I4 4 210f21 gt Search 4 To select a data series to be prepared for printing click 1 The Report selection will appear and for the first steps we will select ACIF in the list of Reports Modify Data Modity Dat Modify ct Report AEC Chartbook Page Page 1 ld B ASEAN Community in Figures ACIF Page 004 e Pageo3s ASEAN Statistical Yearbook Page 005 ASEAN Statistics Leaflet a Report x Page 030 gt SEAR f uU E Page 031 ASEAN Community in Figures Page 032 Page 033 Page 036 Page 037 in US millions 502 Permanenent Share in gt 3 The Report Selection will disappear and the Page Selection will appear Here we choose Page 036 The Page Selection will disappear and the Series Selection will appear This appears in the central part which displays elements of the series or graphs Here we choose Series The Page 036 has a table with two sections these are called Series and they appear with a number and the description written in the related header line After this choice the central window of the form fills with the elements of the page In this case the elements of Data Series S01 of Page 036 of the Report ASEAN Community in Figures ACIF This information is repeated in the top section above the central window The elements of the Series are stored and displayed in tables and these tables are displayed ad c
3. 2 2712 7876 9626 9449 2271 12279 10000 3 Rest of the World 3 21632 47175 65058 37317 32995 63929 10000 4 Unspecified 4 168 1597 967 309 3 0 10000 Print 5 New line B 10000 10000 10000 10000 10000 10000 10000 mrss m LE i The data entry screen for page 36 from ACIF 2011 first of the two data series lines and columns added for categories and data series values Data only for explanation New column and line in 1 and new line in 2 e lines can be deleted choose whole line then with right mouse click choose Cut see example below Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 8 3 E e 4 4 d 3 3 d 3 Categories 1 2003 2006 2007 2008 2009 2010 2011p E In USS million 2 IRecori M 4 1of2 b HE k Search 4 ss tui Row Rore TNI mccum zl 9 8 3 l Total 2 1 24512 56648 79650 4 076 38266 20208 10000 Cah 2 Intra E amp R I2 12712 7876 9626 9449 5271 12279 10000 3 Rest of the World 3 21032 47175 65058 37317 22995 63929 10000 4 4 Unspecified 4 168 1597 967 309 a 0 10000 5 New line ES ann 0000 10000 10000 10000 10000 10000 gm Mew Record to Bo Record 14 4 10f5 kl IR Cut Row Mk A Search KE TA gt A The data entry screen for page 36 from ACIF 2011 first of the two da
4. Make sure that ribbon are minimized to make use of full view of the data entry screens and forms see left Minimize the Ribbon Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 6 A first draft is shown for the empty data editing screen which appears when clicking 3 The different elements of a publication page are shown at right in orange yellow i 23 ASEANStats Report Writer Select or Modify Stats Report Modify Data Series of Statistical Report Select Edit New Delete Page Edit New Delete Data Series Edit New Delete Format Back to Switchboard i Report Report Series Watch and use Show Hide Tables the Navigation Buttons at Left Data Series Bottom of Form Page Header Click Select Button for Report and Page The data series for this Report Page will be displayed togeter with available Headers If Page does not exist choose New Page If Data Series required Format does not exist Jeader Lines choose New Format Data Series can be added by New Data Series A li lill How to use a Form On gaining access to Form You will enter a Record of a Page and view and modify the related Print Page to PDF EXCEL Export Current Data Series only Text RTF file Whole Page E iil gt
5. Pag out MES ma Yw Sy n A DataSeries Num forRW Import xlsx A B D E F G Report Report Page Report Data Series Row Columns DataV1 DataV2 ASEAN Community in Figures ACIF Page 007 Page 007 501 5 6 25 E ASEAN Community in Figures ACIF Page007 007 501 5719 6 18 5 ASEAN Community Figures ACIF Page 007 ACF Page 007 501 5 54 7 20 6 ASEAN Community in Figures ACIF Page 007 ACF Page 007 501 518 5 94 5 ASEAN Community in Figures ACIF Page 007 ACF Page 007 SO1 59 72 7 75 ASEAN Community in Figures ACIF Page 007 Page 007 501 5 16 5 16 ASEAN Community in Figures ACIF Page 007 Page 007 501 5 14 4 10 9 ASEAN Community in Figures Page007 007 501 55 90 5 8 ASEAN Community in Figures ACIF Page 007 Page 007 501 5 11 50 12 00 8 25 8 50 7 50 8 25 ASEAN Community Figures 007 007 501 514 4 2 10 2 SIE Bur HO DataSeries Num forRW Import A DataSeries Mix forRW Import A DataSeries Caf S4 12 ASFAN Communitv in Figures ACIF Page 32 No Comment Data Entry from EXCEL with multiple lines copy and paste to table You are about to paste 10 record s and the following message Will appear Are you sure you want to paste these records Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germ
6. file is generated ASEAN and the world Table 7 ASEAN Lending rates in percent dor priodi Indicated 11 M4FLI OU 144 Metric mo data area labia Zounom ASEAN Financs and Macrcaconornic Duca beer RTF file And PDF File generated ASEAN icrmmareby in Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 22 The editing and printing for graph s pages is as to be expected different Selecting the graph series and selecting Graph circled and then clicking the Add Edit Related Elements of Data Series LAUT LS 1 SO Sd Od Back to Switchboard Chartbook Page 001 Chartbook 002 AEC Chartbook Page 005 ASEAN Community in Figures ACIF Page 007 ASEAN Community in Figures ACIF Page 028 ASEAN Community in Figures ACIF Page 029 ASEABMGemrmty in Figures A Pade ASEAN Community in Figures ACIF Page 030 ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF Page 032 ACERT Communia Eius A Delete Selected Data Series in Report ASEAN Community in Figures ACIF Page 032 Page ASEAN Community in Figures ACIF Page 034 ASEAN Community Figures Page 036 E DataSeries E Data Series ASEAN Community in Figures ACIF Page 036 Page Header Footer ASEAN Community in
7. 7876 9626 9449 5271 12279 ASEAN Commu Page 036 Page 036 501 21632 47175 65058 37317 32995 63929 ASEAN Commu Page 036 Page 036 501 168 1597 967 309 5 0 A DataSeries Num forRW ReportsTab P ry V Report Report p V Report Page Report Page Report Data Series Comments W Row H Report Data Se Columns Characterist Data Year DataV2 DataVv3 DataV4 Datav5 DataV6 Field DataV1 DataV2 DataV3 DataV4 DataVS Table A DataSeries Num fo A DataSeries Num fo DataSeries Num fo A DataSeries Num A DataSeries Num fo Total First First First First First Sort Show Criteria or QueryFirst in the Query Editor Report Data Seri FirstOfPlainSNr FirstOfDat FirstOfData FirstOfData FirstOfData FirstOfData FirstOfData ACF 036 501 501 24512 56648 75650 47076 38266 76208 Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 25 The Result of QueryFirst 3 The Query to combine the two Queries in a built expression called QueryPercent 3 QueryPercent QueryFirst Report Report Report Page QuerySimple Report Page RR Report Data Series na ata_ eries i FirstOfPlainSNr PlainSNr FirstOfDataV1 Devi FirstOfDataV2 DataV2 zs 4 ui Field Report Report Page Report Data Seri
8. Add Edit Related Elements of Data Series in Report Page Headers Categories and Footer New Version 0 95 The data table to appear after clicking on Add Edit related elements will be the following T zommunity in Figures ACIF Page 007 501 2 vt Report Row t SFoot1 ASE ACI Report Page ASE ACI ASE ACI ASE Re ACI Reco rd Record Record H 4 4 Ga A DataSeries PageHeader m Repot Report Page Cj ASEAN Community in mi Page 036 ASEAN Community in Page 036 ASEAN Community in Page 036 ASEAN Community in Page 036 ASEAN Community in Fig Page 037 ASEAN Community in Figi Page 037 ASEAN Community in Figi Page 037 ASEAN Community in Figi Page 037 Record H lata k Hk Report Data Series t 1 1 Table 30 2 3 ASEAN Trends in Foreian Direct Invest 4 for periods indicated 5 Table 31 T ASEAN FDI Inflows bv host countrv in 8 for penods indicated Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 16 Starting with table 5 This can be done manually copy line one by one and edit the appropriate fields circled other fields can also be edited but these 3 are mandatory index fields EH A DataSeries PageHeader m Genoa Report i Row ASEAN CommunityinFig Page 036 1 Ta
9. R Federal Foreign Office P T XT 7 Z Deutsche Gesellschaft AS EAN f r Internationale SECRETARIAT Zusammenarbeit GIZ GmbH Description for the User of the ASEANStats Report Writer Version history Version Number Observations Draft 16 11 2012 Klaus Roder Draft Finished Delivered continued Documentation Draft finished 07 12 2012 Klaus Roder Complete Prototype for Prototype 1 Added and Print Mixed Data Value Graph 2 Add Auto Series for New Page 3 Add Calculated Tables Review history Version Number Reviewed by Observations Reviewed Final Draft Klaus Roder Reviewed and Corrected Contents MMO GUC HON 2 Stepwise use of ASEANStats Report 2 me Bis is ERN Et 5 The user interface ieee TEN 6 View Modify and Print content of Data Base 6 Add Import New Data to the Data 11 Using Non numeric data and graphs in pages of the Data Base 21 Creating calculated 1 nnne se sse sees 25 Introduction The objective of the mission for this project is to design and impl
10. because its content will depend essentially on the agreement of layout and production process This is without mentioning a provisional data model prone to future modification The goal of the project start up is that users will be able to modify all editable data numbers and text and apply calculation with ACCESS Operators on tables with number contents The different parts of a printed page are shown again here Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 3 The printed page 36 from ACIF 2011 06 ASEAN foreign direct investment Page Table 30 Header ASEAN Foreign Direct Investment FDI inflows for periods indicated 2003 2006 2007 2008 2009 2010 Series Page BUSS milion Header Total 265118 5004 0 750503 4 0 56 284000 Intra AS EAN 2116 TESE 545 5 s 0 Rest of fe 2163227 4 1 48 650578 3531 3 312809053 Series Header lines Unspecifed r Preliminary Nate Staring 2003 some countries entry on Unspectlie T Bem were inciaded In Categories Source ASEAN investment Mais Ociaiese 26 of 30 September 2011 based on SOU SUDEN In 2010 Foreign Direct investment into fhe ASEAN welded two fokd growth ai U575 7 billion regameng ibs 2007 level at USS 76 bilion series The share of 5 to the total inflows was 169 traceable ip ASEAN e
11. to the source data 5 Append a copy of the records to tab If the specified table exists Access will add the ds to the table If the table does note exist Access will create it Changes made to the source data will not be reflected in the database Link to the data source by creating a linked table Access will create a table that will maintain a link to the source data in Excel Changes made to the source data in Excel will be reflected in the linked table However the source data cannot be changed from within Access Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 18 You select the appropriate Folder in the Worksheet select First Row as Headers and Import one file to the corresponding table Your spreadsheet file contains more than one worksheet or range Which worksheet or range would you like Show Worksheets A DataSeries Num forRW Import J Show Named Ranges A DataSeries SerFooter Import Sample data for worksheet A DataSeries Categ Import Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 501 Com
12. 0 mn m Bc ao Total Hiio ee ibt TEXEO Prat hobim JOCEL some Qo E eis ne urmpascit ed ee ede rn Citar zer of Austria Pagus Bulgaria Corn Grech Pepe Dert Erer lrancm Cecrcary Greece tungacy rea Ha Letrin Lithuania Loxsrrizcurg Fae fe HMatturian zum Poland pemaria 5calr Lacan aci aridis Ei ngricrr bank nc iab aval abis LETE eee Siete Daiabane 30 September 2011 bad m cour banaan BLIT ared ien reer tin oa tha bop proie AAH FOI mens Por S00 enbe 274 eed rir LEN LEA 11 35 end an 1154 m AN L2mmunits in gum JOEL Bb 140 Iu 20 ia incl Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 20 Using data and graphs in pages of the Data Base The last two chapters have been edited for the prototype to print modify and store Numeric Series The Data Base has been prepared after that for all Data Types and has been enhanced to treat these other data types Another feature is the treatment of data in the Data Base to create new data series based on existing ones This relates to numeric data only because with these only calculation is possible An example for doing his calculation is in
13. 35 1741 2861 4 Print Page to POF Print P PDF EU 27 6866 13387 18611 17066 India 104 282 1453 547 2584 EXCEL Export Current Data 7 3903 49413 8844 4128 5 Series only Tad 1015 Recordi M 1015 gt W No Fitter Search Text RTF file Whole Page ow 15 Lag mc p sain an Record 14 4 190f20 gt d NoFilter Search Form View Num Lock E Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 19 Printing will confirm the successful update of the ASEANStats Report Writer with a new Page of ACIF ASEAN foreign direct investment Table 32 ASEAN FDI inflows by source country in USS million Inr period irneiegbad Pie Share Iriri AN Mio aio 122330 1940 14800 1788 5 Carada 2320 Er 0 16410 China inin 1045 1 imo 15870 LEBLLE foo iraia 1040 EJ 1458 4 70 Hip ibid Nan x20 FIO Ern 253 0 Patoten is Bo 5 Rapubiir Koraa AID 1255 0 1556 D Lu simu HETT in 1 En 147 0 LEA 14910 5B D Rast of the World 1a Lrunacfiac 1D 1997
14. CIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF Search Page 001 501 Page 002 S01 Page Pade Page 1728 11 29 501 030 501 030 02 Page Page t zi Fage 032 Fage 032 Fage 034 Page 036 Fage 036 Page Pate Page 38 Page 045 501 045 601 Check existing Data Series for Report Page or Select New New Data Series ir ico Sage E Delete Selected Data Serie prom Page Data Series Data Series Page Header Footer Data Series E Data Series Header Lines Categories Data Series Data Series Numeric Non Mumeric Graphic Data Series Add Edit Related Elements of Data Series in Report Page Headers Categories and Footer pper Notice that a dummy series for the new page has been entered with the name S01 for Numeric Page 038 and Non Numeric Page 007 and G01 for a Graph Series Page 031 See circles This screen allows again selecting between insert edit and deletion of a series The different o
15. Figures ACIF Page 037 ASEAN Community in Figures ACIF Page 038 E DataSeries Data Series ASEAN Community in Figures ACIF Page 038 Header Lines Categories ASEAN Community in Figures ACIF Page 043 ASEAN Community in Figures ACIF Page 045 The following screen will appear the other screens for Headers Categories and Footers are the same as in other series Copy a line edit the index fields circled and add the graph click on the attachment symbol Q with right click of mouse A ReportsTab Pages Graphs Report Report Page Report Data Series PlainSNr Comments Page 043 ACF Page 043 601 601 Comment not yet finished ge Rage 045 G01 G01 Comment not yet finished Page 031 Page 031_G01 G01 Comment not yet finished Record 4 4 30f3 bob or K Search ill The following screen will appear and you can select an appropriate graph po murua niro CUNEN Attachments Double click to open 1 Comment not yet finished 1 Comment not yet finished Comment not yet finished Attachments Double dick to open 0 0 2011 04 Chi Page031 jpg Remove ocs ACIF Files EXCEL Save As Save All Cancel ACIF Files EXCEL ModForTransf ACIF 2011 04 Ch Manage Attachments lll Files EXCEL PDF 1_Page031 jpg v File name ACIF 2011 04 Chl Page03ljpg All Files Tools Open 2 And t
16. N Community figures ye IF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF lt Page 008 a Page 004 Page 005 Page 007 Page 029 Page 030 Page 031 Page 032 Page 033 Page 034 Page 036 Page 037 Page 038 Page 039 Page 040 Page 043 Page 045 gt Delete Selected Page in Report st Page Header d Page Footer Num NonNum Graph E Add Edit Related Elements of Page in Report Page Header and available by click 1 and selecting a line in the selection box and entering a new page name in 2 or delete one or several selected items in the list by clicking 3 Make sure that a line is selected black in the list Existing in lower right corner Report Page 4 otherwise you will get Page Footer Record IM 4 of 24 an error message Search Hint just close and open window if you get stuck Number 1 What to enter or to do Select from list of Report Page click button related selection field is toggled switched on off if button is c
17. S mion iste p Zr Merge amp Center p 50 354 Conditional s 17115 73782 esme 22712 121792 10102 7 Formatting v of tte 118312 171725 23 245 173172 iboard 5 Font fu Alignment Number I KR ee J in percent dure m f Di ces ces 1222 122 aM E F G H J IE Report Report Page Report Data Seri Row Columns DataV1 DataV2 DataV3 DataV4 DataV5 un Md ASEAN Community in Gase STEN mom Taco Sides m s 12 eleme IDII Des e me o 633 Figures ACIF Page 036 ACF Page 036 S02 1 0 6 0 100 0 100 0 100 0 100 0 100 0 E mI ASEAN Community in n H is he STEN dad Dead qas 7 1 DU eager Ca 1007 Figures ACIF Page 036 036 502 2 0 6 0 11 0 14 0 13 0 20 0 14 0 o ASEAN Community in Figures ACIF Page 036 ACF Page 036 502 3 0 6 0 88 0 83 0 86 0 86 0 ASEAN Community in M M e _ Figures Page 036 ACF Page 036 502 40 6 0 2 0 3 0 1 0 s 0 0 Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 10 Add Import New Data to the Data Base The main editing screen allows for the time being the creation and import of new data This function should be dislocated to other section notably sec 1 for generic import and to the section 2 5 for the import to th
18. SEANStatsRW_Version pdf and Introduction to ASEANStats Report Writer pdf The Acrobat Reader is addressed at VBA lt Appl C Program Files x86 Adobe Reader 11 0 Reader AcroRd32 exe gt This is done in the Form_Switchboard Module and can be altered easily by the ACCESS knowledgeable user The ASEANStats Report Writer lt current Version gt accdb is a programmed ACCESS 2007 data base It is programmed in VBA Visual Basic for Applications To use the Data Base elementary knowledge of ACCESS is sufficient For modification and further development of the ASEANStats Report Writer programmers knowledge is indispensable and a full software development suite 1 Requirements Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 5 specification Requirements analysis 2 Software design 3 Implementation and Integration 4 Testing or Validation 5 Deployment or Installation 6 Maintenance is strongly recommended As for this moment ASEANStats will have to resort to external expertise to finalize this process and the product The development of the ASEANStats Report Writer is a software development project and should be professionally treated as such The user interface View Modify and Print content of Data Base Some work has been done on the user interface starting from the calling structure the so called swi
19. ables and Graphs for further use in Data Base Modification of Tables Graphs and Report Elements of the ASEAN Community in Figures ACIF A Page NewOrDel ete A Page DataS NewOrbDelet e Modification of Tables Graphs and Report Elements of the ASEAN Economic Community Chartbook Modification of Tables Graphs and Report Elements of the ASEAN Statistic Leaflet Modification of Tables Graphs and Report Elements of the ASEAN Statistical Yearbook Most of the work has been done to allow creating and modifying ACIF publication Other publications are still pending IN import can be done in section O as will be explained but full menu and form based import is still pending AN of the work has been done for the ACIF publication to be done to be done to be done Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany amp 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 2 The Data Model Relationships for ReportWriter 0 B M Dataseries PageFocterPage dr 3 Reports Tabs Pages DSerdes Frms Report Report Page Conments The Data Model DM Pages Page ldentification is stored in Table 2 are thus always related to one and only one Report in Table 1 and so forth This is indicated by the 1 symbols This means that all table related via a Relationship contain and store information related to a pag
20. ames etc Then copy the data from EXCEL to three different import tables and proceed with the import Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 17 The prepared EXCEL files for import looks like this AN Community in Figures ACIF ity in Figures ASEAN Commi Page 038 ASEAN Comm page 038 AT ASEAN Comm Page 038 ASEAN Comm Page 038 ASEAN Comm Page 38 ASEAN Comm Page 038 1 ASEAN Comm Page 038 0 ASEAN Comm Page 038 ASEAN Comm Page 038 2 ASEAN Commi Page 038 ASEAN Comm Page 038 ASEAN Commi Page 038 ASEAN Comm Page 038 16 ASEAN Commi Page 038 Page 038 Page 038 Row _ 038_S01 ACF Page 038 S ACF Page 038_S0i BEA Page 038 2 ACF_ _Page 038_ 501 ACF_Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 ACF Page 038 S01 8 ASEAN Ci Page 038 ASEAN Cc Page 038 0 ASEAN Cr Page 038 1 ASEAN C Page 038 ASEAN Cc Page 038 ASEAN Ct Page 038 ASEAN Ci Page 038 Columns DataV1 Detav 2112 7 876 155 SFoot Preliminary Starting 2009 some countries s entry on unspecr EU 2 consists of Austria Belgium Bulgaria Cy France Germany Greece Hungary Ireland Ital Netherlands Poland Portugal Romania S
21. an be edited in this screen These elements are once again Data Series Page Header 1 Data Series Header Lines 2 Data Series Categories 3 Data Series Values 4 Data Series Page Footer 5 Selecting Series 502 the central part of the screen changes to show the second data series Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 7 External Data Database Tools Modify Data Series of Statistical Report Page Page 036 Edit New Delete Page Edit New Delete Data Series Edit New Delete Format Back to Switchboard ASEAN Community in Figures ACIF Report 50 Row 1 30 036 Series Record 14 10 4 b ROW Categories 2 In USS million 2 Record 14 1of2 gt bl bE Search v a E 2 2 gt iun 24512 dee 2712 Hot of the World 21632 Unspecified 168 New line 10000 56648 7876 47175 1597 10000 9 nl 75650 47076 9626 9449 5271 65058 37317 32995 967 309 5 10000 10000 10000 38266 Record 14 1of5 gt h a Record 14 1of5 Row M 1 p Preliminary bob ob Search 4 Record M 10114 gt Mk Search so 1 in US millions Watch and use the Navigation Buttons at Left Bottom of Form Click Select Button for Report and Pag
22. any 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net 21 Page The editing and printing is just the same as for numeric data The circled line is the one which is the non numeric External Data Database Tools Es ASEANStats Report Writer Select or Modify Stats Report Modify Data Series of Statistical Report Select Report Edit New Delete Page Edit New Delete Data Series Edit New Delete Format Back to Switchboard Report ASEAN Community in Figures ACIF Page 007 Series 501 Watch and use Series the Navigation Buttons at Left 13 Table 7 Bottom of Form 14 Record 4 10f4 bob WK No Filter Search an nuv v r 11 Country 1998 choose New Format Data Series can be added by New Data Series Record 4 10f1 Filter Search Row 4 Rov zi How to use a Form atedores On gaining to Form You Brunei Darussala i 16 5 wll ener a Record ela Pag Cambodia Indonesia data series Lao PDR Malaysia Myanmar EXCEL Export Current Data ES Series only Pn nine Record 14 4 10f10 gt bl bh Record 14 410110 gt be Navigation Pane Text RTF file Whole Page Notes no data available Record M lt 1of2 gt Search lef lt Printing works just as expected EXCEL file is not completed because of non numeric data but a RTF
23. ble 30 ASEAN Community in Fig Page 036 2 ASEAN Community in Fig Page 036 3 ASEAN Trends in Foreign Direct ASEAN Community in Fig Page 036 4 for periods indicated ASEAN Community in Figi Page 037 6 Table 31 ASEAN Community in Fig Page 037 ASEAN Community in Fig Page 037 T ASEAN FDI Inflows by host country ASEAN Community in Fig Page 037 8 for penods indicated ASEAN Community in Fig Page 038 ASEAN Community in Fig ASEAN Community in Figg Page 038 ASEAN Community in Fig Page 038 12 for periods indicated Record 4 41120112 M A NoFilter Search A DataSeries SerHeader Report v Report Pagt Report Data Series Row ASEAN Community in Figures Page 036 ACF Page 036 501 7 Categories ASEAN Community in Figures Page 036 ACF Page 036 501 7 In USS million ASEAN Community in Figures Page 036 ACF Page 036 S02 7 in percent shares to total ASEAN Community in Figures Dage 037 Page 027 S0 7 Host Countries 2003 ASEAN Community in 1 7 Host Countries 2003 Record 505 4 Search 4 n like the data series header 3 only need a change in the index fields circled After editing you close the tables For the other tables entering the data by typing is not such a good idea This will be 15 and 7 columns for the values In this case Import per EXCEL sheet is a better choice For this we first export the tables to maintain the data structure field n
24. cluded The modification treatment of non numeric data is very similar to the treatment of numeric data The data table to appear after clicking on Add Edit related elements will be the following yea ces nimmer ensi cp itcr rA tp MEINEN FILUM CIC EM Back TO 3wimnpaara q h and use 2 Navigation at Left Fand x EH A DataSeries Mix forRW es i non pu Report Data Seri ROW ASEAN Community in Figures ACIF ACF Page 007 501 ASEAN Community in Figures ACIF Page C ACF Page 007 S01 ASEAN Community in Figures ACIF Page 007 ACF Page 007 501 ASEAN Community in Figures Page 007 ACF Page 007 501 ASEAN Community in Figures Page 007 ACF Page 007 501 ASEAN Community in Figures Page 007 ACF Page 007 501 ASEAN Community in Figures ACIF Page 007 ACF Page 007 S01 ASEAN C Page 007 ACF Page 007 S01 Column 4 3 Cn t E 007 _ ca Search The Tables are now in the latest version 0 95 rearranged so that the data table always appears on top Here the data table for non numeric data circled The update of the table can be done manually copy lines and edit the appropriate fields other fields can also be edited The three circled fields are mandatory index fields So data can be arranged in EXCEL and then be copied also as multiple lines provided the structure of the table is respected and the index fields 3 m
25. d and also a file is ELT NN re not generated ed Still something has to be done on the formatting and the fine tuning of the page layout Again it might be that a DTP program is necessary to improve and fine tune the layout of the pages ORO EN COUTE INN COME ee Tra eed ai kimrtet basTber in d zzcniriar acest Meyarerae hep coe docs 1354 pele Zngxcona Mabey az Decr arr AEM Community im Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany 28 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 24 Creating calculated tables Tables with numeric data might be used to create others An example is given creating percentages out of the series table 1 of page 036 to create table 2 of page 036 oeveral queries are created here and used for demonstration of the procedure this can be shorter in a production data base Other examples of aggregations of data like sums averages etc would be easy to implement in a similar way 1 The Query with the table data called QuerySimple QuerySimple AseanStats Report Writer O abase Tools m Report Page Report Data Seri PlainSNr DataVl DataV2 DataV3 DataV4 DataV5 DataV6 Data a ASEAN Commu Page 036 036 501 24512 56648 75650 47076 38266 76208 ASEAN Commu Page 036 Page 036 501 2712
26. e The data series for this Report Page will be displayed togeter with available Headers If Page does not exist choose New Page If Hide Table required Format does not exist choose New Format Data Series can be added by New Data Series How to use a Form On gaining access to Form You will enter a Record of a Page and view and modify the related data series Print Page to PDF EXCEL Export Current Data Series only 6 Text RTF file Whole Page Series Footer 4 Search Record 4 4 190f21 gt We Form View Showing and Modifying Statistical Report in ASEANStats Report Writer The data entry screen for page 36 from ACIF 2011 first of the two data series The movement within the central window and the five different sections is standard to MS Windows computer users The scroll bars if available allow scrolling right left up down Now all of the different parts of the page can be changed e data cells can be edited e columns of tables can be added this is only possible for some tables like the data series series header lines and categories table e lines can be added only in all tables you see a line number called row make sure to enter new row number to add a new line see example below Row 2003 2006 2007 2008 Categories 1 In USS million decor H 1 of 2 Row 1 Total 1 24512 56648 75650 47076 38266 76208 2 Intra ASEAN
27. e This the principle of relational database based on a relational model Using the top down structure you can delete all Report related information all Page info all Data Series info and all Training info deleting the data sets in the appropriate files Note that the table structure 1 to 2 Reports to Pages contained in the reports is rather straightforward the next step is already more complex relating data series i e tables 6 and 7 differentiating between tables with numbers and those with mixed contents i e numbers and text these latter tables do not allow calculation on their content and graphs table 12 to the pages The data series can be several per page so the definition not the series itself is stored in table 8 The various elements belonging to one page are stored as Page footer Table 13 Page header T14 Series Header T11 and Series Footer T3 The most complex pattern is the deconstruction of the table elements like categories T10 series header lines T11 and proper cell contents tables 10 and 11 There is a multitude of different patterns e g two line headers nested structure in column and row headers The less complex data structure is those of the graphs in table 12 The page layout headers and footers in text is designed by the tables 3 4 and 5 and is again less complex meaning one set of lines per page Finally there is table format information table 9 the elaboration of table 9 is still pending
28. e specific publications A generic form of data import is shown in this So section Generic means general import based on a mix of typing and the use of ACCESS mu m import facilities i In order to create a new page for publishing Watch anduse the Navigation Buttons at Left Bottom of Form Click Select Button for Report and Pi je Seri n Fori t Lines choose New Format Data Series can be added by New Data Series How to use a Form Text RTF file Whole Page earch you need to create a new page instance and a data series belonging to that page The first step to introduce a new page is by clicking 1 After that button 2 will be selected to enter new series The following screen will appear after clicking 1 1 Es A Page NewOrDelete This screen allows selecting between insert edit and deletion of a page The different options are Add Click Select Button to select or delete Report Page First select a Line in Box then add Page Number three digits e g Page 001 for the selected Report Exit Field to Update List Choose the Data Type of new page Numeric Text or Mixed or Graph One empty series S0 1 will be created in the Series table of this type Delete Click Select Button to select or delete Report Page and dick Delete Button AEC Chartbook L ASEAN Community ir 22 282 ASEA
29. ement an integrated database to produce and streamline the production of statistical abstracts at ASEANStats the main publications of the department the ASEAN Statistic Yearbook the ASEAN Community in Figures ACIF the ASEAN Economic Community Chartbook and the ASEAN Statistic Leaflet The Database is functional and is filled with some dummy material in order to allow testing and handling of the database screens The ASEANStats Report Writer concept follows the following scheme of steps for data input and related report writings The green marked parts of the indicated steps is ready for input and produce and release Assessment Report and can be tested This part should allow understanding the handling of the Database how the steps are executed in the Database how the Reports are produced and how they appear That symbol will indicate that there is still work to do and Stepwise use of ASEANStats Report Writer Section Title Description Cite Remarks and Tables Modify Create Delete Data Series for Statistical Report Import Data Series for Statistical Report Print Create Modify ACIF Print Create Modify AEC Chartbook Print Create Modify ASEAN Statistic Leaflet Modify Statistical Yearbook Print Create Look at the Data Tables and Graphs and the associated elements StepO on Switchboard ASEANStatsRW _FormSec0O_ Create OrModify StatsReport Import of Data T
30. es Expr1 Format Qu vi Expr2 Format QueryS Expr3 Format QueryS Expr4 Format QueryS Expr5 Format O Table QuerySimple QuerySimple QuerySimple Sort Show Criteria or Expr 1 Format QuerySimple DataV 1 QueryFirst FirstOfDataV 1 Fixed 100 4 uil QueryPercent in the Query Editor with Expression built in Expression builder P QueryPercent Report Page Report Data Seri Expr2 Exp3 Exp Exp5 ace 036 036 501 100 100 100 100 ASEAN Community F Page 036 ACF Page 036 S01 14 13 20 14 ASEAN Community in F Page 036 ACF Page 036 501 83 86 79 86 ASEAN Community in F Page 036 ACF Page 036 501 3 1 1 0 Results of QueryPercent as can be used and copied to tables This is series 2 in Page 036 With this manual and the contained instructions the prototype for ACIF should be functional and working Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 26
31. es in ASEANStats Report Writer Back to Switchboard New Data Series in Report Page Page 001 Page 002 50 005 ASEAN COMMUNITY IN 5 LALIT ASEAN Community in Figures ACIF ASEAN Community in Figures ACIF ASEAN Community in Figures ASEAN Community in Figures FR DataSeries 1 Data Series Page Header Footer B DataSeries E Data Series ASEAN Community in Figures Header Lines Categories ASEAN Community in Figures ACIF Ir Data Series Data Series 1 2 The check box below is again for editing modifying the elements of the series the series page header the series footer the series header lines the series categories and the series values The data type will be read from the data base In this section it is Shown how it was done manually in a previous version the new version has facilitated this procedure by programmed approach as is explained in the next chapter Data Series M Data Series Page Header Footer Data Series Page Header Data Series Footer Data Series Categories Data Series Non Mumeric Data Series Header Lines Data Series Categories Num C NonNum 5 Graph Likewise select in the data type of the series to be created only Numeric was available in the old version all data types are now available Add Edit Related Elements of Data Series in Report Page Headers Categories and Footer Old Version before 0 9
32. fforts of integration Values Series Page Footer Page Footer 35 ASEAN Community in Figures 2011 hi m D ASEANStats Report Writer is tool to store the publication reports of ASEANStats It will allow to modify them make amendments add and delete and finally print or export the elements on form of formatted printout PDF unformatted text printout RTF and tables and graphs EXCEL It must be mentioned that the Database in a developing stage and shortcomings might still occur The current development stage allows testing all input schemes and practices It generates the elementary and most important Reports for further analysis Apart from technical problems the central problem might be the comprehension of the Workflow by the user ASEANStats Report Writer has to be tested by a variety of users to overcome any traps and hurdles for inexperienced users Although on part largely self explaining the database handling presupposes basic computer skills as well as knowledge of MICROFT Office Tools and programs It has been developed and tested for screen resolutions of 1366 768 and higher Higher resolution will improve readability lower resolution is not recommended as it will make orientation on input Forms more difficult although functionality of ASEANStats Report Writer is fully assured also for lower screen resolutions It is further recommended that Toolbars or Ribbons will be switched off to be able to view the En
33. foreign dire investment ASEAN Community in Figures ACIF Page 037 1 06 ASEAN foreign dire investment ASEAN Community in Figures ACIF Page 036 1 06 ASEAN foreign dire investment Ga G E Ok d Record H 1of amp ORE fe Mo Search Example 2 In Table 1 copy a line and edit the appropriate fields circled Be aware that the page footer changes for left and right pages see below Klaus R der amp Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 13 L ata eries rageroorerPage m m x Report Report Row FPage r FPage2 Years FPage0 Add New Field 4 ASEAN Community in Figures ACIF Page 036 ASEAN Community in Figures 2011 ASEAN Community in Figures ACIF Page 037 ASEAN Community in Figures 2011 ASEAN Community in Figures ASEAN Community in Figures 2011 x Record 4 3of3 Mk A DataSeries PageFooterPage Repot QM em ages ea FPageO0 ASEAN Community in Figures ACIF ASEAN Community in Figures ASEAN Community in Figures ACIF Page 036 ASEAN Community in Figures ACIF Page 037 ASEAN Community in Figures ASEAN Community in Figures ACIF Page 036 ASEAN Community in Figures ASEAN Community in Figures ACIF Page 043 ASEAN Community in Figures ASEAN Community in Figures ACIF Page 045 1 ASEAN Community in Figures
34. he graph can be attached There will be different ways to add graphs to the data base The graph files can increase the size considerably linking a file to an EXCEL chart will be another solution After editing the corresponding header and footer files the editing screen just looks as expected showing the graph instead of categories header lines and data values Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 23 External Data Database Tools Modify Data Series of Statistical Report Edit New Delete Page Edit New Delete Data Series Edit New Delete Format Back to Switchboard Report ASEAN Community in Figures ACIF Page 043 Series co 1 13 Chart 4 114 Record 1of4 b PL be iK Filte Search with available Headers If Page does not exist choose New Page If required Format does not exist choose New Format Data Series can be added by New Data Series How to use a Form On gaining access to Form You will enter a Record of a Page and view and modify the related data series Navigation Pane EXCH Export Current Data Series only Record 14 1 of 1 K te Search Record 14 1 of 1 Form View Showing and Modifying page 043 from ACIF 2011 a graphs page 08 ASEAN telecommunications Printing works just as expected EXCEL file is not complete
35. licked Button Delete Selected appears to delete a selected page from report Be aware that all related information for this page is deleted as described in the Data Model Select Report Page and enter new page the just leave the field or press lt Enter gt The choice is transferred to list Existing Report Page A Deleted Selected Button Appears by toggling Button 1 Selected Items are selected and a message box confirms deletion List is updated Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 11 This is how you enter a new page 038 for ACIF Enter and leave field 2 or press lt gt List is updated Existing Report Page in ASEABStats Report Writer Genuine i us ASCA CUITITILIEILCY IET mTIHYU ES LT Pape 02 B New Page for Report ASEAM Community in Figures ACIF Page 003 ASEAM Community in Figures ACIF Page 004 ce Qr im Page mosh ASEAN Community in Figures ACIF 2 ASEAN Community in Figures ACIF nien ASEAN Community in Figures ACIF Page 007 Page 029 Fi Page 030 Page 031 Page 032 Page 033 a ACF 1 2 The red box is for editing modifying the elements of the page the page header the page footer and generically new dummy series for the page Obviously a new page does not have a series or graph a
36. lovak no data available ASEAN Investment Statistics Database as of 30 EU 2 intra ASEAN USA and Japan remained 1 MASEAN Ct Page 038 SEAN CiPage 038 ASEAN FDI inflows for 2010 EU 27 contributed 2 ASEAN 16 USA 11 3 and Japan 11 4 W A Dataseries Categ Import _DataSeries The circled areas have been modified with EXCEL means to correspond to the index field contents These sheets in the same EXCEL file PO38 Data Series for Import From File Tab 1 A DataSeries Categ Import the Categories are imported gt to ACCESS Table A DataSeries Categ From File Tab 2 A DataSeries SerFooter Import the Series Footers are imported gt to ACCESS Table A DataSeries SerFooter From File Tab 3 A DataSeries Num forRW Import the Data Values are imported gt to ACCESS Table A DataSeries Num forRW The ACCESS import facility allows importing and appending to existing tables This is how you import to the Categories Table from the Yellow to Blues circled file Specify the source of the data File name MO 121128Mission 2012 2 DocsMACIF Files EXCELTrz sferPage038 DataSeries for Import xisx Specify how and where you want to store the data in the current database Import the source data into a new table in the current database If the specified table does not exist Access will create it If the exists Access might overwrite its contents with the imported data Changes made
37. munity in Figures ACIF 038 501 Community in Figures ACIF 038 501 Community in Figures ACIF 038 S01 Community in Figures ACIF 038 501 N e Jee e e t lols le fom en o w f E Again that import of data for now has to be done manually and should be facilitated by programmed approach Opening the main editing window and selecting S01 of Page 038 of ACIF shows that the Database contains the right data Circles indicate es ys Home Create External Data Database Tools age Modify Data Series of Statistical Report Select Report Page Page Page 038 Edit New Delete Page Edit New Delete Data Series Edit New Delete Format Back to Switchboard Report ASEAN Community in Figures ACIF Pace 038 Series S01 Watch and use o1 IA the Navigation Buttons at Left Bottom of Form l Click Select Button for Report and 4 1of4 gt VK NoEFilt Page The data series for this Report Page will be displayed togeter with available Headers If Page does Host Countries 2010 p Share 2 not exist choose New Page If ti required Format does not exist choose New Format Data Series can be added by New Data Series Record 14 10 1 bE OX Wi Ros How to use a Form Intra ASEAN ategore On gaining access to Form You will enter a Record of a Page Australia 5 20 z and view and modify the related Canade 82 data series China 201 10
38. nted page will look like this in the Acrobat Reader Now this is very similar from the copied page File Edit View Window Help from ACIF 2011 page 36 Formatting details might need some work 06 ASEAN foreign direct investment overhaul AN ASEAN Trends in Foreign Direct Investment FDI Inflows You will fer piradi indicated also notice the changes in the cells which have been ET EN G3 oe aoa oO OOO O stored in the Data Base UOI ENS for further use M 756501 470TED JOELO TENEO It IS obvious that other meo 9U60 mao buttons in 6 produce Toit e then World a7175 0 37317 0 329535 1 TUTUP T EUST UESTRE unformatted EXCEL files wen moan iwona TEXT files inpercent shares totai respectively which are ND ane stored in the same directory with the file extensions xlsx and rtf The EXCEL file contains just the data values Preity 208 seme ceri s amry him aere naded in Others ASEAN esate Sic a of D Septum 202 had on country Categories and Column Headers should be added in 2030 Fare inet Their ASEAN peeled tai renes th al bin ip In the futu re Thee ed lth ASEH to res postal FD sisi 1556 raconte to AS EAM efforts of imegration ASEAN Cosimi bs In US
39. oter age Footer y Darl DataSeries PageHeaderPage Report e Report Page Row HPage HPage1 ASEAN Community in Figures ACIF Page 007 1 01 ASEAN and the wo ASEAN Community in Figures ACIF 036 106 ASEAN foreign dire investment ASEAN Community in Figures ACIF Page 037 1 06 ASEAN foreign dire investment ASEAN Community in Figures ACIF Page 036 1 06 ASEAN foreign dire investment LA COCA BRL ee eee ee m ACDSN 7 7 Ll PLE b t li Record 1 of 6 E H Search 4 I Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 12 In table 2 copy a line and edit the appropriate field circled The first example is for the Page 038 with numeric Data Series the example 2 is for Page 007 with Non Numeric Data Series EH A DataSeries PageHeaderPage Report Report Page HPage1 ASEAM Community in Figures ACIF Page 036 ASEAN foreign direct investment ASEAN Community in Figures ACIF Page 037 ASEAN foreign direct investment f ASEAN Community in Figures ACIF Page 038 ASEAN foreign direct investment Record 4 4 3of3 ko KN LE Search 4 Example 1 A_Lie lea Se lies r Report Report Page Row HPage HPage1 Ae 101 ASEAN and the wo _ ASEAN Community in Figures ACIF Page 036 1 06 ASEAN
40. ptions are available by click 1 and selecting a line in the selection box and entering a new series name in 2 or delete one or several selected items in the list by clicking 3 These two fields buttons alternate It is just for demonstration that they are shown together Make sure that a line is selected black in the list Existing Report Page Data series 4 otherwise you will get an error message Hint just close and open window if you get stuck Number What to enter or to do 1 Select from list of Report Page Data Series click button related selection field is toggled switched on off if button is clicked Button Delete Selected appears to delete a selected series from page report Be aware that all related information for this Data Series is deleted as described in the Data Model 2 Select Report Page and enter new page then just leave the field or press Enter The choice is transferred to list Existing Report Page 3 A Delete Selected Button Appears by toggling Button 1 Selected Items are selected and a message box confirms deletion List is updated Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Page 15 This is how you enter a new Series S02 page 038 for ACIF Enter and leave field 2 or press lt gt List is updated Existing Report Page Data Seri
41. ssociated with the page Select in section 1 if you want the page header or footer to be updated This has to be done manually and should be facilitated by programmed approach E Page Header 5t Page Footer Num MonNum Graph Likewise select in section 2 the data type of a series to be y C created All data types are available now Numeric Non Numeric E S NE E EEN ASEAN Community in Figures ASEAM Community in Figures ACIF g ASEAN Community in Figures Page 029 ASEAN Community in Figures Page 030 ASEAN Community in Figures ACIF Page 031 ASEAN Community in Figures Page 032 Add Edit Related Elements of Page in Report Page Header and Page Footer ASEAN Community in Figures eat Page 033 Delete Selected Page in Report 1 1 ASEAN Community in Figures Page 034 and Graphs Selecting as p the ASEAN Community in Figures ACIF Page 036 example Page 007 of type Non ASEAN Community in Figures ACIF Page 037 wil ASEAN Community in Figures Page 038 Numeric and clicking the button ASEAN Community in Figures Page 039 Add Edit Related Elements of BM oen s ASEAN Community in Figures Page 043 Page in section 3 and the ASEAN Community in Figures Page 045 m A following tables will open for editing RR PEINE the Page header and the Page Page in Report Page Header and Page Footer Fo
42. ta series delete lines Data only for explanation Data lines have be deleted separately 1 and 2 Columns values have to be deleted one by one Finally the section to print and publish in section 6 from the main entry screen above emat s Las Here the choice is obvious Seer Press any of the keys to print a page PDF or WORD format save the appropriate EXCEL file Note that only the current data series value will be save as an EXCEL file and NOT both data series For all file storage the following message box will appear Choose a parameter e g P036 V1 to save the file according to the explanation in the message box If for example you enter a P036 V1 in the message box your save file name will be according to the box s message Data Test your text to add pdf that is the file Data Test P036 V1 pdf will be saved to your destination directory which is neta C temp for the time being This will be modified in the our destination directo Cancel 2 amp future to allow a user defined directory as the file name vil can be chosen by the user AN Notice that old files with the same name will be overwritten without warning Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 OG e mail Kroeder gmx net Page 9 The pri
43. tch board which will be the main control centre of the ASEANStats Report Writer The principal screen can call different subsequent control screens to allow calling the ASEANStats Report Writer functions usually in proper ACCESS forms screen All forms all switchboard forms allow to see a version information 1 or and help text 2 as mentioned above This is a PDF text book Es Section 0 Modify Pages in Xii ew si 15 Sets Es Section 1 Import or Delete Data Sets E Section 2 Create Modify ACIF Sample of Calling Structure of ASEANStats Report Writer Wa Home Create External Data Di v 5 E 9 3 o gt 5 E Customize Quick Access Toolbar New Open Save E mail Quick Print Print Preview Spelling Undo Redo Mode Refresh All More Commands Be Ribbon This calling structure repeats throughout the switchboards of the ASEANStats Report Writer Section 2 Sec 2 is repeated for the other section documents produced by ASEANStats Section 1 is for the import of external data as well as for eliminating information Tables and Graphs Certainly standard ACCESS options and user interface can be used for this as well Menu External Data Ribbon Import Section 0 SecO contains the centrepiece of the ASEANStats Report Writer as it has been developed so far the modification of numerical data series tables and the modification of series and page elements
44. try Screens and or Reports in Full Size Klaus R der G Seidelbaststr 7 amp D 80939 M nchen Germany 2 49 89 23925824 83 mobil 49 162 4067907 Fax 49 89 32705463 e mail Kroeder gmx net Starting the Database LLLA Call ASEANStats Report Writer lt current Version gt accdb and enter the Switchboard The central data handling cockpit The five steps above reflected in the five sections of the Switchboard the step 0 ss SEC is the central modification section The icon left has been created for the ASEANStats Report Writer and is included among the documents delivered ASEANStatsReportWriter ico Es Switchboard 4E ASEANStats Costumize ASEAN statistics m Section 1 Import Data Tables and Graphs for Statistical Report ASEAN Community in Figures Section 2 Print Create Modify ALIF AEC Chartbook Section 3 Print Create Modify AEC Chartbook ASEAN Statistics Leaflet Section 4 Print Create Modity ASEAN Statistical Leatlet Section 5 Print Create Modify Statistical Yearbook Close Application Remain in ACCESS fers DA 121128 by Klaus Rider on iiber Huit ACCESS ASEANStats The Form Fields Version and allow to show current information about the Version and presenting a Help Screen a User Manual Both auxiliary Files are currently stored as PDF Files at C temp and are called A
Download Pdf Manuals
Related Search