Short instruction in using PC
Contents
1. 1 period sex and marital status 2 Change value order 3 lc ae 1997 12 31 4 ange texts codes den ram 3 Change decimals Mark the area you want 6 Link with table 26 to copy and click on Edit 7 Overlay with table 8 9 Copy Ctrl C Find Fa Select All 419046 40 17740 APh Table R 20 C 6 A Footnote ft Press F1 for Help X Microsoft Excel Boki 3 Arkiv Redigera Visa Infoga Format Verktyg Data Fonster Hj lp x lea siniz leles ole zla s res z ol Population by 5 rsklasser region period sex and marital status JE E KR KK AN KN AA KA AA KK NG AA AN AA AN AN EN Tar y 5 arsklasser region period sex and marital status Women Totalt Men i Women Totalt T Total Total Total Total 5519631 48360 510830 Samson Paste the table into Excel j using Edit Paste or use the keys Ctrl V 219046 407740 Oc 5044 44358 12673 590 i 7608 2008 N N SESE SES EEE Sj Es SA ES ES br a fy bd ri Fra fr CO CK Dim kn 1 1 ODT 2 NJIA A n 4 gt fy Bladi Blad2 Blad3 Blad4 Z Blad5 Z Blad6 f Blad Blad IKI i uf Klar Summa 3 5E 07 NUM PC AXIS for Windows 10 Using convert and save in another file format Save the table in another file format par PC AXIS F SWEDEN SDATABAS BEO001RE PxX FIER2. 8 x EEEE E E E a Tl ea le Pa pee le Py ee et hee SE xi K L M amp Change x x 1 Populatit E 2 Distributi Add a program by entering a menu text and program OK 3 with complete path ock 4 5 Remove a program by removing the menu text Cancel 4 45 49 50 54 55 59 4 gt 6 1992 12 2 Browse 7 Number Browse 8 Men 1 338709 256066 3 Women Menu text File type Enter the fields In 4108 324546 247613 2113 10 Totalt Ese s5 8403 663655 503679 4201 14 Per cent the dialogue box 120 Men Program 51 04 50 84 BS Toat make a link to Excel 100 157 199712 16 Number enu text lle type enu Test ET pe 17 Men PETE 332321 2487 18 Women Program Program Ao ai 322190 2446 19 Totalt 654511 20 Percent 21 Men b1 18 50 77 50 22 Women 48 82 48 6 48 63 40 77 48 99 49 08 48 6 48 82 49 23 49 Totalt 100 100 100 100 100 100 100 100 100 A Footnote Press F1 for Help In the dialogue box above optionally four different software can be linked To establish such a link PC AXIS needs the following information The name of the program is entered in the field Menu text If the character amp is entered in front of one of the letters in the name a shortcut is linked to this very character key on the keyboard The name of the program will then be found in the Archive menu below the names of the previous used files The used file type shall be entered in the field File type If the extension i
3. af Klar Summa 0 mm INUM PC AXIS for Windows 22 Statistics Across Borders Nordic statistics on CD ROM Internet links to the Nordic NSI s is also available in the document Internet user interface to PC AXIS on CD roms F Statistics Across Borders 1998 Microsoft Internet Explorer This HTML document is available on the cd rom Statistics Across Borders The links are heading the different databases on the cd rom and also the Web sites of the National Statistical Institutes in the Nordic countries 4 Arkiv Redigera Visa G til Favoriter Hj lp Ea Bak t Frameat Stopp Uppdatera Startsida S k Favorite Adress F Cdrom98 htm Statistics Across Be zy HEI Danmark Denmark Database Danmark Database in English Danmarks statistik F royar Faroe Islands Datagrunnur f roysk Database in ish E stas land Iceland s Gagnasafn islensku fstafasett 36 G afn islensku fstafaset 850 Database in ish Hagstofa slands JL H Norge Norway Databas p norsk Database in English Statistisk sentralbyr On the 1998 issue of Statistics Across Borders a HTM document named Cdrom98 htm looking as above is available It works in the same fashion as the service Prepackaged files in the Sweden s Statistical databases but you do not require any Internet communication You just select database for any of the present countries
4. 14 15 19 C excluded 20 24 25 29 30 34 o 4 Ff Table R 8 C 20 A Footnote Press F1 for Help If you just want the resulting per cent to remain in the table use exclude in the area Initial values par PC AXIS F SWEDEN DATABAS BEO01RE PX gt Eile Edit Calculate View Window Help 8 x Population by perio sex region marital status and 5 rsklasser Distribution by number of persons and Per cent Sweden Total 0 4 5 9 10 14 15 19 20 24 25 29 30 34 35 39 40 44 45 49 50 54 55 59 1992 12 31 Number of persons Men 310189 261963 Now the per centages are 338709 256066 Women 293395 248369 324946 247613 Totalt 603584 510332 inserted into the table 663655 503679 Per cent Men 51 39 51 33 7 7 Oe 51 04 50 84 Women 48 61 48 67 48 75 49 01 48 51 48 66 JU 48 96 49 16 Totalt 100 100 100 100 100 100 100 100 1997 12 31 Number of persons Men 265400 315363 268386 257486 280269 304492 338412 S299 N46 311369 332321 Women 253132 298141 254030 245139 269193 293500 319925 285 288989 303708 322190 Totalt 518532 613504 522416 502625 549462 597992 658337 SYN 588035 615077 654511 Per cent Men 51 18 51 4 51 37 51 23 51 01 50 92 51 4 WL 50 86 50 62 50 77 Women 48 82 48 6 48 63 40 77 48 99 49 08 48 6 4832 49 14 49 38 49 23 Totalt 100 100 100 100 100 100 100 5 100 100 100 alef Table R 18 A Footnote fT Press F1 for Help Change textual To change the textual information in the stub an
5. 597992 654511 4934 20 Per cent 21 Men 51 18 51 4 51 37 51 23 51 01 50 92 50 77 50 22 Women 48 92 496 4863 4877 4899 49 08 49 2349 23 Total 100 100 100 100 100 100 100 1 4 Fih Table R 18 C 20 A Footnote Press F1 for Help PC AXIS for Windows 19 Select Additions SH 3 es ea es Te es es ka fee Additions 3 a T ajo 543 5054 5559 E ae aes Hine ee 4108 324946 247613 2113 In the window Options for Advanced the folder Additions EET 04 50 Iur is selected with the ss 208 mA subfolder Other programs EEE Men 13046 2487 Womer 2989 309708 2221901 2446 8035 615077 654511 49341 Per cent Women 48 82 ss 6 es 63 er A a or 6 me 82 en 14 es 38 sa T ee s Totalt o ul HE Bres a ET a ras es 5 red EE ea ear Ei EA 2 EE ETA 54 ical ar EE EE a 4 f Table R 18 C 20 As can be seen on the picture it is also possible to change a lot of different parameters In the window Options for advanced you can change directories in which the files shall be stored as default It is also possible to change the layout of PC AXIS PC AXIS for Windows 20 To link another software to PC AXIS Some explanations Zu PC AXIS F SWEDEN DATABAS BEO01RE PX 18 x File Edit Calculate View Window Help
6. 63 298141 252046 240012 492058 268386 254030 274711 261346 536057 257486 245139 296679 285209 581888 280269 269193 333726 314388 648114 304492 293500 296774 281290 578064 338412 319925 299391 286923 586314 299124 285361 314295 304108 618403 299046 288989 330709 324946 663655 311369 303708 256066 247613 503679 332321 322190 208841 211351 420192 248786 244668 199996 215140 415136 199351 207470 197282 221764 419046 184535 207350 184234 223506 407740 172223 207101 133856 183654 317510 146367 197310 86732 141990 228722 89944 144792 37169 78544115713 44358 90757 10219 27979 38198 12673 35147 5901 7608 2008 7503 A Footnote Press F1 for Help Click on the sheet Footnot to get the footnotes for the very table Available information is Latest update Source Contact Units Data type Reference period Database Internal reference code There might even be certain information on the material a variable or a value of a variable Further information is available on a material accessible through the tool button if it is activated When using this button a linked document will be automatically opened in your word processor PC AXIS for Windows 9 Copy the table into another software like Excel Using the table in another software Par PC AXIS F SWEDEN DATABAS BEO01RE PX Py x Fie Calculate View Window Help 18 x e JAA em Delete value D E F G Change variable order
7. 8 6 49 Totalt 100 100 100 100 100 100 100 1 BRE Ba gp h elella a aln lena pa m IEA Sh Table R 18 C 20 A Footnote ZY Press F1 for Help X Microsoft Excel BeO01re_xls olele ellis 4 lel ol a mn ulala gt 2 az EE a ee es Ds a a es ee a a ee Ee Em Population by period sex region marital status and 5 rsklasser Fa Distribution by number of persons and Per cent ET Sweden ra Total aoa a 0A SA When Excel is initialised from S4 5553 z Number of persons PC AXIS the active table is E Men 310189 261963 252046 P56066 208 g women 293395 249369 240012 transferred and opened P47613 211 110 Totalt 603584 510332 44 2058 503679 420 11 Per cent 9 12 Men 51 39 51 33 51 25 50 99 5149 51 34 51 06 5092 51 04 50 84 4 113 Women 49 61 48 67 4875 4901 4851 4866 4894 4918 4896 49 16 14 Totalt 100 100 100 100 100 100 100 100 100 100 45 1997 12 31 16 Number of persons 17 Men 265400 3153 257486 280269 304492 338412 299124 299046 311369 332321 248 148 women 253132 29814 245139 269193 299500 319925 295361 288989 303708 322190 2441 119 Total 518532 613504 502625 549462 597992 659337 584485 588035 615077 654511 493 20 Per cent i Men 51 18 51 4 51 231 51 01 50 92 54 5118 5096 5062 5077 SC 122 women 48 82 48 6 4877 48 99 49 08 486 4892 4914 4938 4923 4 2 Totalt 100 100 100 100 100 100 100 100 100 100 25 26 Era v Kj 4 gt if Table R 18 C 20 Footnote 4l
8. 8412 299124 299046 311369 LA 248786 1 M women 253132 298141 254030 245139 269193 293500 319925 285361 22190 244668 2 M29 Totalt 518532 613504 522416 502625 549462 597992 658337 584485 54511 493454 4 B lh Table R 8 C 20 Press F1 for Help Zu PC AXIS F F SWEDENS DATABAS BEO01RE PX ei a Eile Edit Calculate View Window Help a A B Population bb period sex region marital status and 5 arsklasser Select Base for Per cent Calculation period 2 sex B egion fi 45 49 50 54 55 59 1992 12 31 1997 12 31 338709 256066 208841 Gace 324946 247613 211351 663655 503679 420192 Calculate the ratio of male and 311369 332321 248786 O female Select Calculate Per cent rel oe T total and use the total of sex as 615077 654511 493454 the base for the calculation sh Table R 80 20 Footnote J Press F1 f r Help PC AXIS for Windows 15 Zu PC AXIS F F SWEDEN DATABAS BEO001RE PX za a Eile Edit Calculate View Window Help i Population period sex region marital status and 5 rsklasser bp Select Base for Per cent Calculation period p sex B region a 45 49 50 54 1992 12 31 i p 1997 12 31 dil 208841 Enter a name on the new oe OK value or in this case use 420192 Enter name for new value the default name Per cent 242726 Per cent Cancel marital status 244668 total Initial values 615077 654511 493454 5 9 included 10
9. CIGG Edt Calculate View Window Help 8 x Open Database Cr O I as if E Import Ctrl l x m m wi F G 1 Close and marital status z Save Ctrl S g avez 123 d Page layout Women Totalt Et Print CtP Pl Total Total PER 265400 253132 ao ee 315363 298141 Cc ew directory 267486 2451 39 Fil ai e Save as 1 Excel 304492 293500 1 338412 319925 658337 4 1 CATEMP VOR38EHC Px 299124 295361 594495 4 2C TEMP SWEDO4 Px 299046 298989 588035 1 3 F SVERIGESDATABAS AMO020142 PX 311369 303708 615077 1 F 248786 244668 493454 1c etre FO 9 199351 207470 406821 19 65 69 197282 221764 419046 184535 207350 391885 20 70 74 184234 2235506 407740 172223 207101 379324 21 75 79 133856 183654 317510 146367 197310 343677 22 80 84 86732 4141990 228722 89944 144792 234736 23 85 39 37169 739544 115713 44358 90757 135115 24 90 94 10219 27979 38198 12673 35147 47820 25 95 1707 5901 7608 2008 7909 9817 lh Table R 20 C 6 Zig PC AXIS FT F SWEDEN DATABAS BEO01RE PX a x gt Eile Edit Calculate View Window Help 8 x ESANA E Ea a 1 al ARE Save To Ea 1 Popu 2 3 To Database Convert 4 5 6 04 FileName Directories Save the file as an Excel 7 5 9 BEOOIRE xls c PROGRAMSPCAW32 file or select any of 8 101 aac 9 154 SJ PROGRAM the other file formats 10 20 2 PCAW32 aT 25 2 12 30 3 Drives 13 35 3 Se M 14 40 4 i 15 454 Fil
10. Is using PC AXIS for dissemination of statistics in machine readable form pays an annual fee for system documentation and further versions of PC AXIS The NSI then gets the right for its country to disseminate statistics including PC AXIS to any of its customers Contacts e mail infoservice scb se Infoservice Phone 46 8 783 48 01 IP INFO Fax 46 8 783 48 99 Statistics Sweden Box 24 300 S 104 51 Stockholm Sweden e mail Databanker dst dk Statistics Denmark Phone 45 39 17 31 50 Databanker Fax 45 39 17 39 99 Sejr gade 11 2100 K benhavn Denmark PC AXIS for Windows 24
11. It must be noticed that certain diagrams are based upon a certain number of columns or variables to be presented The population pyramid is based on a table consisting of two columns as showed above PC AXIS for Windows 18 PC AXIS and other softwares Link to another software Some more advanced options in PC AXIS In PC AXIS there is an option to link the active table in PC AXIS direct into another software The software will automatically be initalised by PC AXIS and the table is transferred into the software such as Exccel or Lotus par PC AXIS F ASWEDENS DATABAS BEO01RE PX HETE Window Help gt v Toolbar ieee ire Bee oft a ea a Ru Vv Zero Rows E a T a a e a E a L v Zero Columns v Grid Lines Column Identities v Row Numbers EA a Show Table Title B 1332 122 PEA To use the option to link LT Number of persons Alignment PC AXIS to another software 8 Men Language b 252 314295 338709 256066 2088 9 women Graph ad enter the pull down menu 324946 2476132113 10 Joist PR 49 View Advanced 663655 503679 4201 Men v Advanced 51 22 BT TI 73 5104 5084 48 143 women 49861 4867 4878 48 75 4901 4851 995 4916 50 Totalt 100 100 100 100 100 100 00 100 1 45 1997 12 31 16 Number of persons Men 265400 315363 268386 257486 280269 304492 332321 2487 18 Women 253132 298141 254030 245139 269193 293500 322190 2446 19 Totalt 518532 613504 522416 502625 549462
12. Statistiska centralbyr n Statistics Sweden D Short instruction in using PC AXIS 98 for Windows PC AXIS 98 for Windows 9X and NT Introduction PC AXIS 98 for Windows is a software for the management of large amount of statistics In PC AXIS it is possible to rearrange tables establish local statistical databases and to export the tables into a variety of different file formats Optional formats includes as well Excel as HTML for Internet or Intranet Statistics Sweden normally distribute PC AXIS as an integrated part of a statistical product within the Internet or on CD roms PC AXIS was initially developed for the 1990 Population Census in Sweden The further development is guided by an international PC AXIS Reference Group with participants from other licensed PC AXIS using NSI s Especially close is the co operation between Statistics Sweden and Statistics Denmark Statistics Denmark has not only developed parts of the software but also produced the origin of this User manual At the following pages some of the features and possibilities in PC AXIS 98 for Windows are showed in the appearance of a cartoon This manual is especially developed for the 32 bits version of PC AXIS If you need a similar manual for the 16 bit version of PC AXIS it can be ordered from Statistics Sweden on Fax 46 8 7834899 or go to Statistics Denmarks Website www dst dk Statistics Sweden Statistics Denmark May 1999 PC AXIS for W
13. and then a document showing subject areas will appear Under selected subject area documents showing the content of the different PC AXIS files will turn up When a file name is clicked PC AXIS automatically starts and gives you options to select variables and values as usual in PC AXIS Using the links to the NSI s web sites gives you the opportunity to access PC AXIS files from several of the Nordic NSI s At present such file services are available at Statistics Denmark Statistics Greenland and Statistics Finland PC AXIS for Windows 23 History PC AXIS was initially developed for the Swedish Population Census 1990 The main users got at copy of PC AXIS instead of paper tables The tables then was down loaded from the databases on the Main frame into PC AXIS Since then PC AXIS is used for diskettes CD ROM and from 1997 Statistics Sweden use it as a help application to the database system in the Internet PC AXIS international reference group PC AXIS is used in several National Statistical Offices NSIs At present Brazil Bolivia Denmark The Philippines The Faroe Islands Finland Greenland Iceland Norway Spain Basque autonomy and Sweden For the NSIs to influence the further development of PC AXIS an International Reference Group has been established The PC AXIS Reference Group meets once a year to exchange experiences study related software and most of all discuss further steps of the development of the software NS
14. d heading use Edit Change information in the texts table Mark the value you want to change Enter the new text and press Enter PC AXIS for Windows 16 Diagrams in PC AXIS The tables in PC AXIS can be presented in a diagram according to a number of diagram types pat PC AXIS F SWEDENADATARASARENNMIRE PXI Piel Ea Use the Diagram tool File Edt 7 When you have arranged 18 x button the table to make a diagram you just have to use the diagram tool button Distribution by number of persons Sweden Total 1997 12 31 Number of persons Aone O Press F1 for Help and select your ily File Edt Calculate View Window Help x choice of a diagram Flee ees and select from x the diagram options z iy i a eS SS Ess _ Sn SS A S Chart Designer in the list Edit Chart Data Sie Wizard gt Open ee eats p Save s amp 20 Print A C 3D Copy e 2 22X2213X n u1s gt LSS ne LOo as a p 5 tacked 200000 100000 100000 200000 Clustered Bar 400000 300000 300000 400000 ial m Sweden total 1997 12 31 numbe of persons men Sweden total 1997 1 2 31 number of persons woma Press F1 for Help By clicking the right mouse button it is possible to edit the diagram There are options to change texts characters color etc PC AXIS for Windows 17 Notice
15. den D atabas BE001RE PX x BEOOT RE Population Sintec ramber ok persone denn Units number of persons OK Cancel OF _ Classify the age variable in 5 years aggregates by Cancel using the button Aggregate Press F1 for Help ZH PC AXIS lej x File View Help Select aggregation list be f Sweden D atabas BE001RE PX BEOOIRE Population Onits numbe ea aan Aggregation List x Total no of c Variable OK Cancel All Cancel a Select aggregation list 5 year classes Press F1 for Help Aggregation lists are The option to aggregate values differs from table to table A table distributed linked to certain on municipalities can optionally be aggregated on region tables PC AXIS for Windows 8 Zu PC AXIS x Select values to the a hag tere table f Sweden D atabas BEOOIRE PXx X BE RE Population rite number of persons OK Cancel Total no of cells 5400 20 ag repectively All age classes sex and the time periods 1992 and 1997 and the total of marital status mantal status status eae women married totalt widowers divorced variable period Elimination not allowed Press F1 for Help A table in PC AXIS Par PC AXIS F SWEDEN DATABAS BEO001RE PX a Eile Edit Calculate View Window Help x 1992 12 31 1997 12 31 Women Totalt Men Women Totalt 310189 293395 603584 265400 253132 261963 248369 510332 3153
16. der Cancel Copy Move Delete Subject Area C Change Subject Area Order Copy move or delete a table within a subject area Select Copy Move Delete Tables in the dialogue box Maintenance Select Population and delete move or copy one of the tables Set up your own order of the tables within a subject area Select Change order on tables Move the most used table within Population to the top of the list Copy move or delete a subject area in PC AXIS Select Copy Move Delete Subject Area Copy the Subject Area Population into a new database Make up your own order of the subject areas Select Change Subject Area Order Let the subject area Population be the first subject area PC AXIS for Windows 14 Calculate Per cent To do simple calculations within PC AXIS BEE Par PC AXIS F SWEDEN DATABAS BE001RE PX gt Eile Edit SEMAGI View Window Help Ta o fam Abe IEA E et EA E e a CA TRA 1 Populz gion marital status and 5 rsklasser gt Add 3 Subtract 4 Multiply 10 14 1519 2024 25 29 30 34 5 1992 1 Divide i 6 Men Add table 963 252046 274711 2986793 33374 The pull down menu Calculate 1 Z Wome Subtract table 369 240012 261346 285209 31438 2 8 Totalt Multiply table 0332 492058 536057 581888 64811 EXPOSES the calculation options 9 1997 1 Divide table 10 Men 55300 363 268386 257496 280269 304492 33
17. e Format 46 50 5 Excel 5 0 xls Excel 2 1 xls A 55 5 Lotus wk1 18 60 6 dBase dbf _ 49 65 6 dBase for Mapinfo dbf ee 707 PC AXIS file px 21 75 7 ae 80 84 86732 141990 228722 89944 144792 23 35 89 37169 79544 115713 44358 90757 135115 24 30 94 10213 27979 38198 12673 35147 47820 1707 5901 7608 2008 7909 aP Table R 20 C 6 A Footnote JOY Press F1 for Help PC AXIS for Windows 11 SEA Fe a ha SION fm 2 or save the table in your own database on the hard disk r f BEOOTREPX O Ecs PROGRAM Select the sheet To database Se PCLAW 32 and enter a file name 4 9 37169 78544 115713 44358 90757 135115 10219 27979 38198 12673 35147 47820 a707 5901 7608 2008 7809 9817 E E E 59 104 15 1 20 2 25 2 303 353 505 555 606 656 00 o y aon co co y ad ra a ma 5 Ea a EE g EN E 2 E E a5 67 ar EE EN EE FE FE 337 a 35 Ff Table R 20 C 6 In this option the table is saved in the selected database in the subject area Population PC AXIS for Windows 12 Edit a table in PC AXIS e e far PC AXIS F SWEDEN DATABAS BE001RE PX efx To edit the Heading gt Eie Calculate View window Help x neon p Jagram Bess value D E F G 1 Change variable order period sex and marital status 2 Change value order 3 Change texts 1997 12 31 4 Change
18. gion age period and sex 99 Population 1994 by region age pernod and sex period sex and marital status Population 1995 by region age period and sex Population 1996 by region age pernod and sex BEOOTSEE FA Population 1997 by region age pernod and sex BE00197E F Population by age region pernod sex and marital status BE001TRE Fs Population changes by region and period BE101A3E Fs Foreign citizen by county of citicenship region and period BE00FRE FS Live births by region pernod and mother s age BE026E Pe Deaths by region period sex and age BEDE Pe Da sathe Rhu soe redone oerind snd eau PEN VYRE mo k 4 OF Cancel Press F1 for Help PC AXIS for Windows 6 Select values from the variables in the table Open a table in PC AXIS ZH PC AXIS 181 x Arkiv Visa Hj lp FAS weden D atabas BEGOIRE Px BEOO RE Population Units number of persons Total no of celle 27540 Sweden 1986 12 31 Select variables to 5 the desired table Tryck F1 for hj lp If you want all values from a variable just click on the name of the variable on the top of a list By clicking on the variable name Marital status all values will be included in the table If certain values are to be selected you have to press CTRL left mouse button Only the selected values will appear in the table PC AXIS for Windows 7 Zu PC AXIS x Aggregate values epee hp f Swe
19. iew Help zi Click F1 to get help where SSN ever in PC AXIS Find help Arkiv Redigera Bokm rke Altemativ Hj lp information on menus commands and how to use PC AXIS Overview What is PC AXIS for Windows Menus and commands To Use Commands in PC AXIS File menu Edit menu Calculate menu Classification menu View menu Window menu Help menu How to Work in PC AXIS The Help Function in PC AXIS To Work with a Table mn PC AXIS for Windows 4 Open a database in PC AXIS Far PC AXIS File View Help Open database N Press F1 for Help Me Use the tool button Open database 18 x The Database Fie View Help contains several subject areas Select a subject area let s try population Current Database f Sweden D atabas Press F1 for Help Change active In the bottom of the menu window you will find the active database If you database have access to more databases on a server or a cd rom you can easily switch database Click on the button Change Base and select another database Use the option search to find a certain file PC AXIS for Windows 5 ZH PC AXIS 8 x File View Help Select a table Populati muir Select from the large amount of tables in the area of Population Population 1991 by region age period and sex 5 Population 1992 by region age period and sex Take Population by age region Population 1993 by re
20. indows 2 List of Contents TEP ODUCIION ANEI IEIET ANE ONE E A udwavstuanesadadenasasnecdene 2 On PC AXIS help fUNCtlONsS ssssesssrsserrrrerrrrerrrrerrrrerrrrerrrrnrerrnrrrrerrrrnrrrnsr rss 4 Open a database in PC ANXNIS ossosesssssrsrrsersrrrerrrrerrrrnrrrrerrrrnrrrrnrrrrnrrrrnrrrrnrrrrsrr gt 5 Open a table in PC AMNXIS sosassvssvrssssnondsonesstedsnen sedel EAE RTRA 7 Using the table in another software s s sseessressrersrsrsrsrsrersrrrrrrrrrrrrrrrrnrrrer 10 Save the table in another file fOrmMat ssssrsrsrersrsrsrrsrrrrrrrrrrrrrrrrrrrnrrrrrrr Il Edit t blein PCAXIS svisdidevoisvsdssedss sdenssssessords diken eCare den esa ERNEA NEAN hana 13 To do simple calculations within PC AXISsssessrsssrrressrrrersrrrressrrrnssrrrrnsr 15 Dia rams in PP CANIS aeeiio aaeeea iaiaaeaia ere 17 Some more advanced options in PC AXISsassssesssrressrrressrrreesrsrrrerrsrrnnsrrrrs 19 Internet user interface to PC AXIS on CD roms s ssersssrsrssrersrrererrsrnrrrrrrnr 23 IEL 1 y OITIR EEO EE A E EA E E TE E O A E AT 24 PC AXIS international reference group s sssesssrsersrersrreersrnrrerrnrrsrerrernererrrr 24 COn ae raa E OEO EE OT EOT 24 PC AXIS for Windows 3 Use F1 for help On PC AXIS help functions Ral PC AXIS l Eile View Help eE Open database N Press F1 for Help A When the mouse indicator touches a tool buton explanatory information is showed ij PC AXIS 18 x File V
21. lasser C Stub Heading 199996 215140 415136 199351 207470 406821 197282 221764 419046 134535 207350 391385 134234 223506 407740 172223 207101 379324 133856 183654 317510 146367 197310 343677 86732 141990 226722 89944 144792 234736 37169 z544 115713 44358 9075 135115 10219 27979 38198 12673 35147 47820 1707 5301 7608 2008 7303 9317 Table R 20 C 6 Footnote OO PC AXIS for Windows 13 Editing the table layout Copy move or delete tables and subject areas Pax PC AXIS F SWEDEN DATABAS BEO01RE PX MEE HETE Window Help TIS x gt v Toolbar JL v Status Bar a See es aa Vv Zero Rows ET F 6 H I 3 Kk L M I Population bp pe v Zero Columns al status and 5 rsklasser Sw v Grid Lines Tol v Column Identities O w Row Numbers 1992 12 31 Show T able Title Men lt Fonte M46 274711 296679 3337 Decide the layout of the table using View where you can delete the gridlines line numbers etc by clicking on the V Women 2 Alignment M2 261346 285209 314 Totalt Language gt 058 536057 581888 648 1997 12 31 Graph Men Women Totalt p86 257486 280269 304 30 245139 269193 293 502625 SSC aon E wna Standard p Advanced 549462 4 Ff Table R 8 C 20 Press F1 for Help A Footnote Copy move or delete a table or a subject area using File Maintenance Maintenance OK Change Table Or
22. s not known you can get the information from the Archive Save as Convert to find the relevant extension In the field Program shall be entered the path to the exe module In this case it is the Excel exe which is linked At this stage you have to know where the desired software is located If you do not know where to find the software use the Explorer search function to find it PC AXIS for Windows 21 Excel is now linked to PC AXIS The table in PC AXIS will automatically be transferred into Excel Par PC AXIS F SWEDEN DATABAS BE001RE PX KG Edit Calculate View window Help x Taaa ze x m m F G Tuf tits amp Te LE s and 5 arsklasser Close Save Ctrl S Save as Page layout Print Ctrl P 55 59 45 49 50 54 Maintenance Database contents 46 274711 Now Excel can be t95 336709 256066 2088 Hen aren 2 26136 used from PC AXIS fos 324946 247513 2113 Classification Pe 536057 03 663655 503679 4201 lt CM 51 25 ON 5082 51 04 50 84 49 PE EET E E 8 4875 4901 4851 48 66 M16 51 2 CMEMPASWEDA PX 00 100 100 100 100 100 3 F ASVERIGESDATABAS AMO201A42 PX 4 F Databas AMO10141 PX ae BE 257486 280269 304492 338412 2487 re STA m0 245139 269193 293500 319925 2446 Totalt 518532 613504 522416 502625 549462 597992 658337 4934 Per cent Men 51 15 51 4 51 37 51 23 51 01 50 92 51 4 50 Women 48 82 48 6 48 63 40 77 48 99 49 08 4
23. texts codes otalt Men Women Totalt 5 i Change decimals Total Total Fa 6 Link with table 603584 265400 7 a ils T a Design the table using Edit 8 l 492058 268386 g Co CukC seder oer4ge Change variable order 10 End F3 581888 280269 269133 543462 11 lt Select Al Cie 648114 304492 293500 597992 12 30 34 296774 281290 578064 338412 319925 658337 130 35 39 299391 286923 586314 299124 295361 584485 14 40 44 314295 304108 618403 299046 298989 588035 15 45 49 338709 324946 663655 311369 303708 615077 16 50 54 256066 247613 503679 332321 322190 654511 17 55 59 209841 211351 420192 249786 244668 493454 18 60 64 199996 215140 415136 199351 207470 406821 19 65 69 197282 221764 419046 194535 207350 391885 20 70 74 194234 229506 407740 172223 207101 379324 21 75 79 133856 183654 317510 146367 197310 343677 22 80 84 86732 141990 228722 99944 144792 234736 23 95 89 37169 78544 115713 44358 90757 135115 24 90 94 10219 27979 38198 12673 35147 47820 25 1707 5901 7608 2008 7809 9817 A Footnote Jf PC AXIS F F SWEDEN DATABAS BEO01RE PX aE a Eile Edit Calculate View Window Help Drag and drop variables using the mouse Population by 5 arsklasser region period sex and marital status Sweden 1907 19 31 100719 91 Change variable order Heading region marital status Drag the variable names from Stub to Heading and vice versa 5 arsk
Download Pdf Manuals
Related Search